"TOTAL" is not working in the script?

[#1]

Hey community,

I found that my expression : =avg(DISTINCT total  <Route> loadfactor)

is working fine in chart.

But when I want to load this expression in script, it is not working.

Chart expression:

Script:

Anyone know why TOTAL is not in blue color in the script?

Thanks and best regards,

Chanel

[kaushiknsolanki · Accepted solution]

Hi,

     Total field is not available to use in script, it is allowed only in charts and front end.

Regards,

Kaushik Solanki

[#3]

Thanks Kaushik Solanki for fast response!

But do you have any idea about the workaround to show this expression?

Thanks and best regards,

Chanel

[kaushiknsolanki]

Hi,

     You can use the normal Avg function with group by of the field and then you can join them together to get the values.

Regards,

Kaushik Solanki