100% Stacked Line graph

[#1]

Hello,

I wanna create a 100% stacked line graph like in this : How to create a "100 % Stacked Column Excel Chart" in QV

But I dont know how to do it with my expression.

I have these 3 expressions:

=count({<GroupingBuyers={'One'}>} DISTINCT CookieIDINT)

=count({<GroupingBuyers={'Two'}>} DISTINCT CookieIDINT)

=count({<GroupingBuyers={'Repeat'}>} DISTINCT CookieIDINT)

Dimension is Week (Could maybe also be GroupingBuyers?)

[MK_QSL]

Can you provide sample file pls?

I don't think so Stacked Line Chart is possible !

[#3 · Accepted solution]

I figured out how to do it.

Sliced it on the dimensions, removed my filter in the expression and added a total. So my expression looks like this now:

=count(DISTINCT CookieIDINT) / count(Total <Month> DISTINCT  CookieIDINT)

Added groupingbuyers as dimension

[#4]

Hi Thomas! Can you attach a file with your solution?

Thanks,

Joakim