Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I want to add fractiles (preferably as limits on a gauge, but reference lines would be okay too).
I can do this with simple data, but not when I make things more complex.
This works:
=fractile({$<Question={"Cat1"},Company>}Response,0.75)
This doesn't:
=fractile((max( {<Year = {"2019"},Company>}
Aggr(((Sum({1<Question={'Cat1'},Company>}Response)))
/(Sum({1<Question={'Cat2','Cat3','Cat4'},Company>}Response))
,Company,Year))),0.50)
My error message says I can't have nested aggr functions. If I remove the first part of my expression (first line of the above), it gets rid of the error messages and accepts the expression, but when I filter my data based on a company, the fractile changes. I can successfully specify the min and max on my gauge using the above equation, but not the fractiles.
Any suggestions about what I'm doing wrong?
May be try this
=Fractile({<Year = {"2019"}, Company>} Aggr(
Sum({1<Question = {'Cat1'}, Company>}Response)/Sum({1<Question = {'Cat2','Cat3','Cat4'}, Company>} Response)
, Company, Year), 0.50)
May be try this
=Fractile({<Year = {"2019"}, Company>} Aggr(
Sum({1<Question = {'Cat1'}, Company>}Response)/Sum({1<Question = {'Cat2','Cat3','Cat4'}, Company>} Response)
, Company, Year), 0.50)