how to show only total in Bar chart

[#1]

Hi,

Could anyone let me know is it possible to show only Total bar instead of all bars for a month data. for more clarification I am attacing my Bar chart.please could anyone help me as my user wants to see only total data.

Thanks.

[Anonymous · Accepted solution]

Amelia

Try removing the dimension 'Test'.

If that does not give what you are after then please clarify your requirements.

Best Regards,     Bill Markham

[christian77]

Hi:

If you want to see only one bar in a bar chart, do not place any dimension, that means adimensional.

Then place your expresion and you`ll have only a bar with the total.

I hope that's what you want.

[#4]

Thanks excellent it's working.

[#5]

Hi,

I need to create a Bar chart by Team member and error type. showing week1, week2, week3, week4 and so on on X axis and percentage of failures on Y axis. But this all should by considering Team member and error type.

For more clarification I am adding the expression

Sum

({<Result={'Fail'}>} distinct Reference)/Sum(Distinct(Reference))

And I need to use the calculated dimensions as

=

IF(FiscalWeekSerial>=$(curFiscalWeekSeq)-4,

FiscalWeek)

and how can I add columns Team Member and Error types? Could you help me

Thanks.