Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I Have a Horizontal Stacked Bar chart with 2 dim and 4 expressions.
Dimensions: 1)KPI
2)Zone
Expression are Count of employees(with filter)/ count(All employees)
When i am unticking the KPI Suppress when value is NULL it is solving my purpose but i am getting extra KPI in the end looks like '-'.
Need help to either avoid the KPI named '-' or any other method which we can use.
Thanks
Manish Madan
Hi,
Can you post sample app.
Regards
ASHFAQ
Why do you untick "supress vaelue when is null"?
If you need to manitain this then you need to avoid null values for this domension in script. Perhaps you can use a wehre cause to prevent them to be loaded.
Set the Total Mode to No Totals in the Expressions tab.
If this is grayed out, change the chart type in the General tab to Straight Table and then change the Total Mode to No Totals. You may change the chart type to Bar chart after this.
Hi NagainK,
Its not giving the expected output.
Hi Manish,
- is a null values, some employees are not linked to KPI, that's why you are gettting -. If you dont want to see that then you should select Suppress Null Values in Presentation or Dimension tab.
Regards,
Jagan.