topic Measure Calculation should change dynamically in App Development

Measure Calculation should change dynamically

jjustingkm — Tue, 25 Apr 2023 18:48:21 GMT

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,

Re: Measure Calculation should change dynamically

jwjackso — Tue, 25 Apr 2023 20:04:03 GMT

Using this data.

Metric:
load * Inline [
Value,Metric
C,Count(ID)
A,AVG(NUM)
];

Data:
Load * Inline [
ID,NUM
1,100
1,200
2,200
3,300
];

If 'A' is selected

When 'C' is selected

When nothing or both are selected