Forum Discussion
Dynamic axis with dynamic grouping/hierarchy
Hi, I am facing an issue while trying to build a chart with dynamic axis. My data is in the following format (attached) Dimension table: Main Table I want the report to be something ...
Hi Maggie Yes, I want to display the dimension names of the metrics that have been selected in the chart context. Suppose I select 3 metrics A,B,C (in this order) then the chart should show the values sliced by the chart filter with dimensions of C in the y axis which are grouped by dimensions of B, grouped by dimensions of A. Like the last image that I had attached.
Hi Anonymous
You could unpivot columns from "m0" to "m10" in main table, then relate the new column with dimension table based on the "metric id",
next add metric id into "row" bucket of a matrix.
Best Regards
Maggie