Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello all,
I would like to fix a KPI whatever the filters selected.
To count the number of unique X it works: Count(Distinct{1}(X)) but I am not able to fix the expression below:
sum(aggr({1}WE_Total_Cost_Max, PN1,PN2))
Thanks
Why are you summing aggr()? Why not just sum the value?
because I can have duplica such as:
total cost=5, PN1=a, PN2=b, c=x1
total cost=5, PN1=a, PN2=b, c=x2
and I would like to have the total cost=5 and not 10. it is why I take the sum aggregated on PN1 and PN2