Sorting Values in Stacked Area Chart not working as I wish

[igdrazil]

Hi there, I have a problem with my area chart.

I can set it up as need but when i'm done it is headfirst (see picture)

The red parts should be at the bottom of the Chart and the light and "normal" blue ones should be on top.

To Data:

Dimensions:

-TimeField

-Field for different areas with 8 different values (e.g. working, change cube, etc)

Measure:

-sum(x)

i tried to swap sorting so it should be in the right order, only the bottom of the chart is changing (see next picture)

It looks like only a part of the field changes its order.

I hope someone could help me. Thanks in advance.

Regards

Chris

P.S.: Things i don't want to do but worked in other cases with such a problem:

-adding a field with values and sort by expression to get the desired sort order.

[umartareen]

Hi,

Try swapping the dimension in the Data tab.

[igdrazil]

sadly it's not that easy  I'll show you what it will be then:

Regards

Chris

[sfatoux72]

Hi,

could you share your app? It will be more easy to help you.

Regards

[igdrazil]

Here is the test-app with the original Dataset (removed the loading script due to security issues)

Regards

Chris

[sfatoux72 · Accepted solution]

Ok,

Your problem is just do to the fact that you don't have data for the first date for "Working" and it could not be include in the sort until the

It will work if you add "0" for working instead of Null for the first date

For example, if I select only the date with no null data we could see the result that you want.

The dimension "value_string" is sorted alphabetical descending

[igdrazil]

Thank you Sébastien! I will check my data for that.

Regards

Chris