It would be great if dimensions could be added to metrics sheets in a similar way to dimensions on rows on pivot tables, with associated metric sub totals.
For example we might to present metrics split by Region.
In these cases, a new metric sheet with a filter set to that Region would need to be added for each version of the dimension, as well as an unfiltered aggregate version.
1 Like
We have the same - we would want to ‘pivot’/partition the metric sheet by a dimension - this limits our ability to use the metric sheets to its full capability.
For now, I think you can create Business Calculation Fields to overcome this shortcoming.
Btw, it’s only a workaround, there may be a lot of copy and paste when the dimension has too many value.
Absolutely, although this multiplies out for each metric that needs to be included, creating friction / overhead. Not an essential as there is a workaround, just nice to have for quality of life.
1 Like