I have a project which requires generation of many pie charts with a very similar expression. The only difference is in the dimension used. The current painpoint is that when we need to create a new pie chart, we must manually change the dimension in the expression/dimension/presentation/title/etcetc. I was hoping to put the dimension name in the Object ID and fetch the Object ID as a variable in the expression, but that doesn't seem to be feasible from looking at the solutions.
As an example, let's say the expression I have right now is:
count(col_1) for piechart_1, count(col_2) for piechart_2, .....
Ideally, what I can have is the below:
count(variable_name) for all pie charts,
where variable_name is dependent on a property of each individual chart (such as Object ID).
Has anyone faced a painpoint similar to this and have a workaround? Thanks in advance
There are no functions available which could return the objectid. Therefore you will need to remain by manually adjusting each pie whereby it might be worth to consider if there are ways more suitable to display these information - maybe a table-chart with gauges or mini-charts as expression-types ...
