2 Replies Latest reply: Feb 20, 2012 2:50 PM by gerardo.pauza RSS

    problem with expression

      hi everyone,

            i have with an expression "Cant Usuarios Acum" in a chart:

       

      the chart is this:

      CALENDARIO_DEAL_EXTERNALS.AñoMesCant. UsuariosCant Usuarios  Acum
      Nov-2010408408
      Dic-2010438846
      Ene-201111121958
      Feb-201111213079
      Mar-201112744353
      Abr-201134917844
      May-2011470812552
      Jun-2011625818810
      Jul-2011793226742
      Ago-20111192838670
      Sep-20111027248942
      Oct-20111333962281
      Nov-20111361775898
      Dic-20111119687094
      Ene-20121130998403
      Feb-20126135104538
      Mar-20120104538
      Abr-20120104538
      May-20120104538
      Jun-20120104538
      Jul-20120104538
      Ago-20120104538
      Sep-20120104538
      Oct-20120104538
      Nov-20120104538
      Dic-20120104538
      Ene-20130104538

       

       

      and this is the expression:

      "=aggr( rangesum( above(

       

      Count({<CALENDARIO_DEAL_EXTERNALS.AñoMes=>} DISTINCT DEAL_EXTERNALS.user_id)

       

      ,0,rowno()))

       

      , CALENDARIO_DEAL_EXTERNALS.AñoMes)"

       

      I don't know why but its generate a lot of rows with 0 values. With out that expression the chart looks well with out 0 values.

      CALENDARIO_DEAL_EXTERNALS.AñoMesCant. Usuarios
      Nov-2010408
      Dic-2010438
      Ene-20111112
      Feb-20111121
      Mar-20111274
      Abr-20113491
      May-20114708
      Jun-20116258
      Jul-20117932
      Ago-201111928
      Sep-201110272
      Oct-201113339
      Nov-201113617
      Dic-201111196
      Ene-201211309
      Feb-20126135

       

       

      the expresion of Cant. usuarios is:

       

      COUNT(distinct DEAL_EXTERNALS.user_id)

       

      thanks for any advice

      gerardo