Discussion board where members can get started with Qlik Sense.
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..
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..