Ho wto display text instead of blanks in bar chart?

[#1]

Hi,

I have Bar chart which displays count of Pass and count of Fail.

for now I have only Pass data. so, in Fail data instaed of blanks how can I show 'There are no failures' . Please can anyone suggest me.

I tried Error Message caption but it is not workign for this requirement.

Thanks.

[#2]

Please find attached.

[MK_QSL]

What you want to achieve?

[rustyfishbones]

Hi Amelia,

You could create a text object, and conditionally show it on the graph based on the Expression

IF(Count({<Result={'Fail'}>} Distinct Reference) = 0,1,0)

See the attached file

[#5]

Thanks. Actually the attached showing the bars only for Count of Pass because the data exists only for Pass on 12/03/2014. There are no Fail data. Eventhough there is no data I would need to show the bars withe text on top as 'There are no Failures'. Please see attached.

[rustyfishbones]

Hi Amelia,

I don't think that can be done, at least I don't know a way

Regards

Alan

[MK_QSL · Accepted solution]

Change your failed expression as

Count({<Result={'Failed'}>} Distinct Reference)/Count(Distinct(Reference))

[#8]

Thanks. But when I am moving the text object to the chart it is disabling . How can I set this. Moreover I would need to show the bars for Failures also. Is it possible?

[#9]

Thanks. That's perfect. Is there any way that I can show for the remaining people there are no failures?

[MK_QSL]

like this?