Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
Acn anyone let me know why the message is not showing. I don't want to supress zero values or supress missing values.
I would need to show if there are no values it should populate as 'No fail'
Dimension: Error Code
Expression : If(Sum({<[Overall Result]={'Fail'}>} [Error Flag])/Count(Distinct(ID))=0,'No Fail',
Sum({<[Overall Result]={'Fail'}>} [Error Flag])/Count(Distinct(ID)))
Thanks.
Go to dimension tab and select show all values
Go to Expression tab and untick Show values on datapoints
Now copy the same expression and create a 2nd expression
Untick Bar and Tick Text on axis..
Please see attached.
Uncheck "exclude zero values" check box
Thanks. where can I uncheck this in bar chart?
Go to dimension tab and select show all values
Go to Expression tab and untick Show values on datapoints
Now copy the same expression and create a 2nd expression
Untick Bar and Tick Text on axis..
right click on the object -> properties
presentation tab -> suppress zero values
Thanks. It is looking messy in the chart Is there anything I need to change?
GO to presentation tab
Chart Scrolling
Tick Enable X-Axis Scrollbar
when number of items exceed (10 or whatever you want)
You may have to use a scroll bar enable in your chart due to huge data points.
Please take a look at the attachment. As Manish suggested Text on Axis is your solution.
hi, Your expression is ok,
You just need to Check the 'Text on Axis' under Chart -->presentation tab.
I checked it and found the it reflects