Hi everyone!
I’m trying to build a screen where users can view raw data and select their own dimensions (Group by) for a report on the client side. However, the current table grouping isn’t working quite right, so I’m looking for a clever workaround.
The goal is to pull raw data from the database with both dimensions and metrics, and allow users to pick the dimensions and see the data properly.
For example, some of the dimensions could be:
• Date
• Country
• Analyst
• Device
And metrics like:
• Spend
• Revenue
• ROAS (Revenue/Spend)
Ideally, users should be able to create a table with dimensions like Date > Country, or just Date, and the metrics should calculate properly. Sorting and filtering by both dimensions and metrics should work as well.
Any ideas or suggestions on how to make this happen? Would love to hear your thoughts!
Thanks in advance!