Export CustomReports csv missing data #20124

Expected Behavior

When i have a custom reports that has been created, and i want to export data as a csv file, I should have all data in several "levels".

Current Behavior

Actually when i click and "export" button and choose "CSV" only the first level of data has been exported.

Possible Solution

Using XML or JSON solved the problem but CSV is more convenient for some people.

Steps to Reproduce (for Bugs)

1. Go to : https://demo.matomo.cloud/index.php?module=CoreHome&action=index&idSite=1&period=day&date=yesterday#?period=day&date=yesterday&idSite=1&category=CustomReports_CustomReports&subcategory=2
2. Click on export and choose CSV
3. Open CSV and there is no mention of "Client habitué"

Context

We wanted to get csv data and process them.

Your Environment

• Matomo Version: 4.13.0
• PHP Version: 8.0.20
• Server Operating System: Debian (docker container)
• Additionally installed plugins: All premium Bundle
• Browser: Chrome or Firefox same issue
• Operating System: Linux

Hi,
I think this is possible this way:

(I choose TSV instead of CSV because my Excel is French and understand TSV instead of CSV...)

Already tried this way and it doesn't change anything.

Same issue with TSV format.

The options to use were mainly:

• Limit: All
• Flatten report: Yes

@Aguay-val How would you expect a multilevel table to be structured in CSV format?
While that is easy in JSON and XML, I can't think of a structure in CSV that is able to handle that in a useful way.