8 Replies Latest reply: Sep 14, 2012 6:55 AM by Anna Perini RSS

    Gauge chart: how to set min e max depending on cycle dimension

    Anna Perini

      Hi, i've a total quantity of products i want to represent on a gauge chart depending on a cycle group:

      - Agent

      - Sales manager

      - Area manager

      I've tried to settle a MAX like this

      =max(aggr(sum(QUANTITY),SALES_MANAGER)) but when a cycle my dimension on agent, it doesn't report their efforts in the right way.

      The same for the MIN. Is anybody able to give me a suggestion about this.