One-Bar Stacked Bar Chart

[#1]

Hi all,

as the search didnt get me a suitable answer I ask you guys to help me.

I try to make a Stacked Bar chart with only one bar divided by areas and it should display the difference to last week.

So the bar in total is the complete difference to last weeks value and that divided by areas in the stacked bar.

I tried several things and variations of expressions like restrict the dimension to the largest week and sum()-below(sum) and so on.

Nothing worked out yet.

Do you guys have an idea?

Best regards,

Seb

[Clever_Anjos]

Not sure I´m following you.

Maybe if you post a sample of your data and a prototype (Paint, Excel, whatever) we could figure out a way to help you

[#3]

This is a super simplified mockup I try to give you a sample but this will take some minutes.

[Clever_Anjos]

4 expressions and 0 dimension solves your need?

[Clever_Anjos]

Attaching my sample

[#6]

Here is a super super simplified sample. The original data is much more detailed with more subareas and so on

[#7]

Unfortunately it doesnt solves my need.

If I would do it with only expressions I cant filter by Area or whatever.

It must be dynamic.