Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have the following fields: Company, Question, Response, Year.
I am trying to create a gauge that shows the response to a specific question for a specific year.
Here is my equation:
KPI: SUM({$<Question={"Cost"}>}Response)
My min/max bounds are:
Minimum: =MIN({<Question={"Cost"}>}Response)
Maximum: =MAX({<Question={"Cost"}>}Response)
This works fine, but I want to lock my min and max so they don't respond to a filter. That way I can filter by company and the gauge value will change, but the min and max will not. However, I still want to filter by year. I want the 2018YE min value and the 2018YE max value for my min and max.
I found several methods of attempting this, but none had an equation for the KPI. I'm sure I'm just messing up my brackets or parentheses somehow, but I can't figure out how to tell my max and min to ignore all filters except the filter on Year.
Any suggestions would be appreciated. Thank you!
Hi @Stars ,
Please use below . The expression value will not change based selction on company.
Minimum: =MIN({<Question={"Cost"},Company>}Response)
Maximum: =MAX({<Question={"Cost"},Company>}Response)
Hi @Stars ,
Please use below . The expression value will not change based selction on company.
Minimum: =MIN({<Question={"Cost"},Company>}Response)
Maximum: =MAX({<Question={"Cost"},Company>}Response)
That is amazing. Thank you so much!