Continous Axis Issue

[anushree1]

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

[anushree1]

Hi,

Any suggestions?

@sunny_talwar , @kaushiknsolanki ,  @Vegar , @tresesco 

[Vegar]

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.

[anushree1]

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

[Vegar]

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?

[anushree1]

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

[Vegar · Accepted solution]

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)

Select with lassoSelection is applied