Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
i'd like to aggregate data 2 categories and then sum hours within that aggregation. then if the sum of the hours is greater than zero, i'd like to count how many there are within the aggregation. this is the formula i have, but I'm missing something..
count({<{$(aggr(sum([Planned Hours]),[Pva Macro],[Pva Emp Name])={">0"}}>} [Planned Hours])
please do not attach qvf files because I cannot load them on my machine.
Thanks,
Maria
I believe this works. thank you. now I'd like to make a histogram of the results. I was thinking I'd make a dimension like this..
ValueList('0-2','3-5','6-8','9-11','12-14','15-17','18-20','21-23','24-26')
but then how would I get the correct values as the measures? would I chart the results from above with an if statement to match the intervals in the value list?
What are these intervals here? These are related to the calculated avg above?
so let's say that the original question I had yielded these results
marco a - 3 people have hours in this macro
macro b - 2 people have hours in this macro
macro c - 6
macro d -17
macro e - 10
marco f - 3
macro g - 2
macro h - 6
macro i -17
macro j - 10
now I want to chart that 2 macros had between 0-2 people, 2 macros had between 3-5 people, 2 macros had between 6-8 people...etc..