how to suppress blank dimension values

[Anonymous]

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

[Anonymous]

Hi Shiva

I have attached the application. Do let me kow if you need further information

[sakamsureshbabu]

Hi Sanjyot,

Do below thing for two dimensions

Chart Properties -> Dimensions -> tick "Suppress When Value Is Null"

[buzzy996]

pleas share ur app?

[Anonymous]

attaching the app

[PrashantSangle]

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

[Anonymous]

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.

[avinashelite]

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.

[Anonymous]

Hi

I wanted to suppress the blank ones.how do i go about it then?

[avinashelite]

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