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
Hello Julia,
In this example, I do not believe you need to check mark the box for 'nulls if there are not enough values' since this is not a moving calculation. Other than that, you can edit the alias.
patrick