Skip to Content

Hiding a measure in chart so that "No Data Available" does not show

Aug 30, 2017 at 11:13 PM


avatar image

Hello Everyone,

I have a trellis chart in my dashboard that shows the Percentage Pass value for employee timesheet entries for a month. There is also a "Detail" button in the same panel as chart which takes to a tab that has a crosstab display of Month, Day, Employee, Pass, Fail. Pass / Fail are zero or one depending if a the employee submitted the timesheet data "on-time" on a particular day.

Both the chart and the cross tab are based on same BeX query.

Now for an employee, who did not submit timesheet through out the month, the "fail" value has 1 (pass=0) consistently for all days in a month in the crosstab. But, the chart since it showing pass percentage (pass / (pass + fail))*100 is zero, there is "No Data Available" showing up in the report.

This is misleading for the users, because the "Detail" button next to the chart is active and there is data in the crosstab.

Is there any way we can display the chart and its axis without any data? Can I bring it Pass / Fail measure in the datasource and then hide it so that the chart appears even if Pass % is zero.

We are using version 1.6 SP 4 Patch 2 of Design Studio.

Would really appreciate your help.


10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers