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.

       

       

      variable:

      =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.