Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
First you need to make all your different date formats to single date format...
I have done the same in enclosed file.
Now rest you can do yourself.
as usual, share your sample data file..
Use chart properties -> Values on data point -> Plot value inside Segments.
Hope this helps
Thanks & Regards
Hi
Try like this
Chart properties -> Axis -> Expression Axes -> Scale
In that, give static step , static min and static max.
Hope that helps
Please find attached.
Thanks for your file.
Can you explain what exactly you want?
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....
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
Check your date field of Data table which is cross table in source there is a problem.
Hope this helps
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?