Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
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