0 Replies Latest reply: Aug 10, 2012 9:00 AM by Laurent Jonette RSS

    Having total of charts line into the axis?

      Hello,

       

      Is it possible to have a graph with total into the axis like this ( but "0" replace by the total of the line):

      2012-08-10_093256.png

       

      I have 3 dimesions: Date_Creation, Type_Opération_GRP and Type_Opération.

       

      Expressions are:

      1- "Nbre Log" =if(inweek(Date_Creation,today(),0) or inweek(Date_Creation,today(),-1), count(distinct ID))

       

      2- "" =sum([Nbre Log]),  to have the total on axis with checked box "text on axis"

       

      2012-08-10_094103.png

       

      Thanks in advance for your help

       

      Laurent

       

      Edit: I've made this in 2nd expression in pop-pup and text on axis:

       

      =sum(distinct if(inweek(Date_Creation,today(),0) or inweek(Date_Creation,today(),-1),aggr(count(total<Type_Opération_GRP,Date_Creation> ID),Type_Opération,Type_Opération_GRP,Date_Creation)))

       

      It works but seems encounter a bug: The obtained value for 1st value of the 3d dimension is repeated for each distinct name of the field on 3d dimension (here "Type_Operation") to others lines an over value. For others, lines there is no duplicate. See screen shot below for example:

      2012-08-10_145108.png

      The value in pop-up is good vs "text on axis" (duplicated on other lines for first value)