Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi,
Total field is not available to use in script, it is allowed only in charts and front end.
Regards,
Kaushik Solanki
Hi,
Total field is not available to use in script, it is allowed only in charts and front end.
Regards,
Kaushik Solanki
Thanks Kaushik Solanki for fast response!
But do you have any idea about the workaround to show this expression?
Thanks and best regards,
Chanel
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