1 Reply Latest reply on Aug 6, 2018 3:32 PM by Patrick A Van Der Hyde

    How to edit alias from a Table calculation

    Júlia Dreher

      Hi,

       

      I´m using a table calculation, with the option 'Nulo será gerado se não houver valores suficientes', according below:

       

       

      The point is that legend show the calculation, and I would like to show something more understandable:

       

       

      I tried to transform the Table Calculation into a Calculated Field, but the option 'Nulo será gerado se não houver valores suficientes' is lost. So the average shown is wrong because even when there are not enough results, the average is calculated and presented.

       

      So, to solve I need tho edit the alias or to replicate the option 'Nulo será gerado se não houver valores suficientes' in the calculated field

       

      calculated field:

       

      WINDOW_AVG(SUM([Trafego Faturavel]), -11, 0)

       

      How can I solve it?

       

      Regards.

      Júlia Dreher