Hi, just a simple question about the aggr() function.
I try to create an aggregation of the following expression :
sum
(RAMA_COUNT)/count(distinct {<TYPE={RAMA}>} Hour)/[Nombre de postes]which calculates the number of type <RAMA> every hour per operator in a month(as dimension in a graphe). It works well and draws the line.
However, when I want to calculate the max and the min of this expression, I have to create an aggregation like:
aggr
(sum(RAMA_COUNT)/count(distinct {<TYPE_HIS={RAMA}>} Hour)/[Nombre de postes],Month)
and this gives different results, and I can't calculate the right min and max.....
Could anyone help !!!
THANKS SO MUCH