1 Reply Latest reply: Jun 13, 2013 3:06 PM by Carlos Reyes RSS

    Variable min and max gauge chart

      Trying to assign variable min and max value to a gauge chart, and show the employer selcted accordingly on the graph.



      To explain in detail: using an expression to calculate the percentage of families for each employer within a topic category.(expression works right can see the values in a pivot table).



      Would like to assign the minimum and maximum percetage values to Gauge chart, and when a employer is selected should allign accordingly to the min and max values.




      =Count(DISTINCT familyid)


      Count(total<Employer> DISTINCT familyid)



      expressions for min and max: min(variable), max(variable)



      Also tried aggr: =max(aggr(sum(variable),familyid))



      Thanks in advance.