How to change the Y axis values in bar chart?

[#1]

Hi,

I have a bar chart with below

Dimension1: Month

Dimension2: =IF(FiscalWeekSerial>=$(curFiscalWeekSeq)-4,FiscalWeek)

Expression as below:

% of Fail: Count({<[Overall Result]={'Fail'}>} Distinct [ID])/Count(Distinct([ID]))
Number Review:Count(Distinct([ID]))

Number of Fail: Count({<[Overall Result]={'Fail'}>}DISTINCT [ID])

In bar chart the Y axis values are showing as 0%,100%,200%,300%,400% and so on up to 1,200%

There are Number of Fail as 2. Because of this the Number of Fail is not showing? Is there any way that I can change the Y axis values?

Thanks.

[MK_QSL]

as usual, share your sample data file..

[its_anandrjs]

Use chart properties -> Values on data point -> Plot value inside Segments.

Hope this helps

Thanks & Regards

[MayilVahanan]

Hi

Try like this

Chart properties -> Axis -> Expression Axes -> Scale

In that, give static step , static min and static max.

Hope that helps

[#5]

Please find attached.

[MK_QSL]

Thanks for your file.

Can you explain what exactly you want?

[MK_QSL]

Why you dont get fail is because there is a problem in your data model.

Create a list box of overall result and select Fail...

you can see that the Date coming is in numeric format... May be you need to set your date as

Date(Date, 'DD/MM/YYYY') as Date in your script....

[its_anandrjs]

Hi,

Your date field is not correct they contains number date and date field for single date format change in your load script for Date field like

Date(Date#(Date,'DD/MM/YYYY'),'DD/MM/YYYY') as Date

Hope this helps

Thanks & Regards

[its_anandrjs]

Check your date field of Data table which is cross table in source there is a problem.

Hope this helps

[#10]

Thanks. Yes you are right. I changed my Date field. But still showing the same result. Any solution please?

EDIT:  I can able to see the count of Fail in straight table. But the problem is with Bar chart?