Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I have 2 dimensions to show in a chart. i.e. Ticket owner and tools handled. This needs to be shown on Y axis.
X axis I am counting the number of tickets handled. Essentially I need to show number of tickets handled by each tickets owner per application.
I would like to suppress blank values wherever there were no tickets handled by the ticket owner for a particular tool. Can anybody please advise how do i modify the dimension for it?
I am attaching my graph. I need to suppress the tools wherever its blank
Hi Shiva
I have attached the application. Do let me kow if you need further information
Hi Sanjyot,
Do below thing for two dimensions
Chart Properties -> Dimensions -> tick "Suppress When Value Is Null"
pleas share ur app?
attaching the app
Hi,
As you said you required two Dimension Ticket Owner and Ticket Impacted
but in your chart there is oner more dimension TR_Priority_Group
Just removed it if dont required. then your will get desired result.
Regards
Hi
I need Priority of the tickets as well in the dimensions to show the level of tickets worked upon by the ticket owner for a particular tool.
Hi Sanjyot,
I checked your qvw file your not getting any blank or null values ..since the values are less it appears to be no bar ...check the below images i just selected the values which appear like blank ...it has very less values when compared to other so it appear like this.
Hi
I wanted to suppress the blank ones.how do i go about it then?
blank values are already suppressed...do to more number of values its appearing like that ...enable scroll for 5 or 10 values and then check