Hi,
The best way to explain my problem is with the example I attached:
Each day I get apples from more than one client.
I also know, for each day and client, what is the percentage of bad apples I got from him.
I want to chart the total number of bad apples I got from the selected client (if none then all).
I've tried to do so with a line chart, where the dimension is the date and the expression is:
sum(aggr((PercentOfBadApples/100)*NumOfApples,Client))
But for some reason it returns only zeros.
Even more weird is that when I choose only one date, it returns the right value!
What can I do so it would return the right result?
Thanks!
