Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I am facing few issues when using continuous axis setting on stacked bar chart:
1. Yearly view the X:axis is appearing as 2,011k 2,012k 2,013k.....(If i use custom as per the attached)
2. Monthy view in X: Axis is appearing as Year-Month and not tied to year(If i use Auto Continous setting as per the attached)
Note: I would like to get Yearly View of Auto Continuous Setting and Monthly View of Custom Continuous Setting , so not sure how to get the same
Also , when i select certain values through lasso over the chart the selections are not getting applied , is this the case with all continuous chart, can we not select the values by choosing the bars of interest
I agree,thats a strange behaviour. I do not have an straight answer why, but I can offer you a workaround.
Adjust your period table to this:
Period:
load * Inline
[Period, PeriodExp
Year, =makedate(Year)
Qtr, Qtr
Month, YearMonth
]
Adjust your dimension expession to this:
=$(=PeriodExp)
Contious axis doesn't look pretty on the Year integer. You could try to transform it into a date by using makedate(Year) as a dimension? See picture below.
Thank you so much @Vegar , that was very helpful also could you please answer the second part of my question viz.,
when i select certain values through lasso over the chart the selections are not getting applied , is this the case with all continuous chart, can we not select the values by choosing the bars of interest
I don't see this behaviour in my environment. Could you please explain using the attached application or create an small sample to post with an explanation?
Sure,
Please check the attached app here I have used a calculated Dimension.
So, when you try to select the bars 2018 and 2019 and make them as your selections they do not get applied on the application .
Hope its clear
I agree,thats a strange behaviour. I do not have an straight answer why, but I can offer you a workaround.
Adjust your period table to this:
Period:
load * Inline
[Period, PeriodExp
Year, =makedate(Year)
Qtr, Qtr
Month, YearMonth
]
Adjust your dimension expession to this:
=$(=PeriodExp)