Hello Experts,
I have the following query related to counting occurences of a particular characteristic related to the Calendar month
1) When I choose the option "Average of all values" within exception aggregation for the calculated keyfigure that I am using for the count, it counts all the values including duplicates .i.e. if the charcteristic has repeated occurences for a given month, then it is counted distinct occurence. However, in this case it is not showing me "0" for no occurence but just displaying a blank
2) But when I choose the option "Counting all values" within exception aggregation for the calculated keyfigure that I am using for the count, it does provides me "0" for no occurences but it counts the repeated value as single occurence
How can I get around this? I mean to get repeated values to be counted as separate occurences and also being able to show "0" for no occurence.
Any help will be appreciated
Thanks,
Rishi