Selectable Expressions for Charts

[Anonymous]

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

[prat1507 · Accepted solution]

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

[Anonymous]

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