topic Aggregated function when used in Bar chart doesnt work properly when used inside a variable in App Development

Aggregated function when used in Bar chart doesnt work properly when used inside a variable

kusha_2007 — Fri, 01 Mar 2019 09:39:03 GMT

Hello All ,

I have a bar chart with Dimension as MonthYear and my Measure is sum(AGGR(Count (distinct InteractionCallDate), AccountPlanOwnerID,CountryCode,MonthYear)). When I store the above calculation in a variable and use the variable in the Chart , the result is not correct . it gives the total sum for all the months .

If I Use the calculation directly in the chart , it behaves properly .

I hope I am able to explain the issue correctly . I am not able to figure why its not working properly when used inside a variable.

Re: Aggregated function when used in Bar chart doesnt work properly when used inside a variable

marcus_sommer — Fri, 01 Mar 2019 11:56:05 GMT

Make sure that your variable-content looked like:

sum(AGGR(Count (distinct InteractionCallDate), AccountPlanOwnerID,CountryCode,MonthYear))

and not

= sum(AGGR(Count (distinct InteractionCallDate), AccountPlanOwnerID,CountryCode,MonthYear))

The essential difference is the leading equal-sign.

- Marcus

Re: Aggregated function when used in Bar chart doesnt work properly when used inside a variable

kusha_2007 — Fri, 01 Mar 2019 13:00:44 GMT

Thanks a lot...