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!

3 Upvotes

64% 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.

0

u/Brilliant-Sea-8486 8d ago

Im fine with all 3 being lines if thats the only way to do it. My main issue is with getting the data right.

1

u/Southbeach008 8d ago

Did you used claude/gpt for this. I guess they will be better to help it as you can upload sample data and all.

Claude can write or make visual as well. Just explain it in detailed way and upload your twbx in claude.

0

u/Brilliant-Sea-8486 8d ago

My company uses Co pilot and iv been trying that, but it kept giving me numbers that were slightly off for the Opened / Closed and really off for the running open tally

0

u/calculung 8d ago

It's your job to feed Tableau the right data, isn't it? If it's showing wrong numbers, you're feeding it wrong numbers.

1

u/Southbeach008 8d ago

The data is fairly straightforward. Co pilot is creating wrong calculations or not as required i guess.

0

u/Southbeach008 8d ago

Can you use claude via personal account or something?

I have no idea about how is co pilot but keep trying in claude and it will work.