topic Re: Continous Axis Issue in App Development

Continous Axis Issue

anushree1 — Tue, 20 Aug 2019 10:53:04 GMT

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

Re: Continous Axis Issue

anushree1 — Wed, 21 Aug 2019 06:32:50 GMT

Hi,

Any suggestions?

@sunny_talwar , @kaushiknsolanki , @Vegar , @tresB

Re: Continous Axis Issue

Vegar — Wed, 21 Aug 2019 08:49:02 GMT

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.

Re: Continous Axis Issue

anushree1 — Wed, 21 Aug 2019 09:45:56 GMT

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

Re: Continous Axis Issue

Vegar — Wed, 21 Aug 2019 11:19:00 GMT

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?

Re: Continous Axis Issue

anushree1 — Wed, 21 Aug 2019 11:52:51 GMT

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

Re: Continous Axis Issue

Vegar — Wed, 21 Aug 2019 18:49:20 GMT

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