Has anyone tried to build a scorecard app with minicharts showing Variances? I am building a metrics scorecard where by the Variance Trend is displayed as a Whisker +1, -1 based on comparison to Last Year or Forecast Data's results.
I have a listbox for MTD, YTD, QTD and another listbox for Forecast, Prior year, Budget data.
Users can pick the combination with the 2 listboxes above and compare actual results. For some reason, QV ignores my MTD, YTD, QTD selection in a mini-chart because I use the pick() function to select the proper metric's expression.
When I take the pick() function out and just show one metric at a time, it works like a charm. I wonder if this is a WAD (working as designed) pick function or really a bug. Thanks for your help folks.
