Hi Superstars,
My data lives in a table with metrics in their own column, which has made it awesome for letting users dynamically modify their report views because we have 50 or so metrics. So the base table looks something like this:
ID Category Metric Value
1 A Name Item A
2 A Price 5.20
3 A Quantity 8
4 B Name Item B
etc...
I have the report set up with a matrix visual, with [Category] as a row header and [Metric] set as the column headers, so the users see:
Category Price Name Quantity Other-Metrics-Selected-by-user-with-filters
A 5.20 Item A 8 abc
B 4.50 Item B 6 xyz
With this method though, when a user uses the "export data" function, the extract returns data in the format of my table, with the Metric listed as a column. This is fine for users who know how to use pivot tables, but we have a bunch of people who don't and pretty much need this data to come out with Metrics across columns.
Does anyone have ideas for how I could do this? The only thing I can think of is basically making a copy of the table with all metrics in the new format, but that would lose the dynamic functionality on the report they would be extracting from, plus i think it's unneccessary to have to load the data twice.
Would love some bright ideas! ❤️
