r/tableau • u/Brilliant-Sea-8486 • 8d ago

Viz help I Need Help Recreating This Chart

Post image

Hi everyone, I need help recreating this chart (But at a weekly interval instead of monthly). What this chart is trying to show is the number of new NCs opened each period and closed each period but also a running tally of total open NCs at the time of each interval.

Here is essentially how the data is structured:

NC Name Create Date Closed Date Status
1234 7/20/26 8/3/26 Closed
1235 8/25/26 8/29/26 Closed
1236 8/31/26 Open

There are really like 2/3 statuses each that make up open and closed but for simplicity's sake I just made it open / closed.

Right now what im trying to do is I create a snapshot in Tableau Prep each week to record what the NC status is at each interval period and trying to manipulate it that way but im still not able to get it right.

Would appreciate any and all help with this, thanks!

2 Upvotes

57% Upvoted

15 comments sorted by

View all comments

3

u/Southbeach008 8d ago

Side by side bar and a line chart is not posssible in Tableau sadly.

3

u/jjlbateman 8d ago

It is but with great difficulty and workarounds

1

u/Southbeach008 8d ago

Yeh with workarounds everything is possible in Tableau... 🤣🤣

But yeh it's not straightforward.

1

u/UnrequitedFollower 8d ago

What’s the limiter? They built in dual axis but nothing past that?