Add stacking bar charts 100%

[owlas]

If user has added a Group in the Layout tab, they will see options for stacking.

Related design files here

Stacking bar charts 100% requires some extra work vs. stacking without transforming the data.

Originally posted by @owlas in https://github.com/lightdash/lightdash/issues/820#issuecomment-1077746303

Acceptance criteria

• [ ] I'm given teh option to stack 100% on my grouped bar charts
• [ ] On hover over the tooltip, I see the % value, but I also see the count for that bar that the % was built from! (e.g. 30%, count: 10)

[rephus]

Didn't we decide to de-prioritize this task @owlas ? Too much work for little impact /cc @TuringLovesDeathMetal

[TuringLovesDeathMetal]

yep - been deprioritized.

Here's an open issue instead for docs on how to do this using table calculations: https://github.com/lightdash/lightdash/issues/2656

[stale[bot]]

Is this issue still relevant? There have been no updates for 60 days, please close the issue or keep the conversation going!

[TuringLovesDeathMetal]

@rephus how much work is "too much work" for this? 👀

it's come up again, and I feel like we should just bite the bullet and try to build it!

[Jake-Curtis]

@TuringLovesDeathMetal As a relatively new user to Lightdash - I would find this really useful functionality. I think converting bars into '% of total' is far and away the most common table calculation that I have to do (followed closely by rolling sum). I find having to dig into the table calculation docs every time I want to get this functionality is challenging - especially as I have to write new code for every time granularity I want to build the view over.

Appreciate it might be lots of work but I think it's a great feature and one that we're feeling the pain of missing when compared to tableau (which we're trying to pivot away from!)

[stale[bot]]

Is this issue still relevant? There have been no updates for 60 days, please close the issue or keep the conversation going!

[owlas]

This issue was mentioned by a user in slack: https://lightdash.slack.com/archives/C06PAANFYKF/p1710518826027099?thread_ts=1710518826.027099&cid=C06PAANFYKF

[jpetey75]

Requested by user in Slack: https://lightdash.slack.com/archives/C075JNX28GG/p1720549035474479?thread_ts=1720534167.110709&cid=C075JNX28GG

[jpetey75]

request by customer in slack https://lightdash.slack.com/archives/C06J189BQCR/p1723719687397579

[lightdash-bot]

This issue was mentioned by a user in slack: https://lightdash.slack.com/archives/C06H50RC4QH/p1724781771636019?thread_ts=1724781771.636019&cid=C06H50RC4QH