Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello all.
I am working on a dashboard where I want the user to be able to select which expression to display on the charts.
This was working for me but abruptly stopped working and I can't determine why.
What I have is an inline LOAD with the metric name, dimensions and expressions to use.
I have a list box where the user can select the metric they wish to display. I have three charts (2 bar charts and one pivot table) that have the Expression definition set to $(=Expression).
As I said this was working but has stopped. Any help troubleshooting is appreciated.
Here's the LOAD statement.
LOAD * INLINE
["Metric", Dimension1, Dimension2, Expression
"Utility Pct By Wgt", Wgt, Hrs "=Avg(utilPctGrWgt)"
"Utility Pct By Hrs", Wgt, Hrs "=sum({<dispInd = {1}>} DispHours)/Sum(TotalHours)"];
Thank you,
Nate
Use
LOAD * INLINE
["Metric", Dimension1, Dimension2, Expression
"Utility Pct By Wgt", Wgt, Hrs, "=Avg(utilPctGrWgt)"
"Utility Pct By Hrs", Wgt, Hrs, "=sum({<dispInd = {1}>} DispHours)/Sum(TotalHours)"];
You missed out on "," after Hrs.
Regards
Pratyush
Use
LOAD * INLINE
["Metric", Dimension1, Dimension2, Expression
"Utility Pct By Wgt", Wgt, Hrs, "=Avg(utilPctGrWgt)"
"Utility Pct By Hrs", Wgt, Hrs, "=sum({<dispInd = {1}>} DispHours)/Sum(TotalHours)"];
You missed out on "," after Hrs.
Regards
Pratyush
Thank you Pratyush!
That was what I was missing. I looked and it so many times I never noticed the missing comma.
Thanks again,
Nate