Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
i have a table like below.
VALUE METRIC
C COUNT(ID)
A AVG(NUM)
Then a chart that change based on expression, if 'A' is selected that measure should be Avg(num), I give metric in the measure value in the chart but it is displaying as 'Avg(num)'.
Thanks,
Using this data.
Metric:load * Inline [Value,MetricC,Count(ID)A,AVG(NUM)];
Data:Load * Inline [ID,NUM1,1001,2002,2003,300];
If 'A' is selected
When 'C' is selected
When nothing or both are selected