I’m in need of some help regarding an advanced Tableau viz i’m trying to come up from scratch.

The idea is to recreate some kind of barbell chart that displays over time the days (or weeks?) that a Campaign_ID has recorded some kind of data (i.e impressions, reaches, spend) and hence was active. We have been turning our marketing ad campaigns on and off depending on current performance and budgeting limits. Our management would like to have an overview for each campaign when it was active and when it was turned off.

I would really like to display this via a barbell chart but can’t get it to work since my calculations always run into the issue of mixing up aggregated and non aggregated data. As of now I don’t really have an approach to share a tbw. file and am very open to any approach proposed.

I’ve figured, I’d need the following:

Calc field Active Period = indicating activity i.e filtering for all days where impressions of campaign ID > 0

Start Date = Date Campaign was tuned on (min timestamp of campaign activity

End date = Date Campaign was turned off (max Timestamp of campaign activity)

If the campaign has been turned off in the past and is still running to date there should be a continues line without stop circle.

The viz should also account for multiple start and stop dates for an individual campaign as you can turn on a campaign at random and only have them run for a handful of days at a time over multiple weeks.

I will attach of a picture that somewhat shows the principle of a barbell chart  I want to create. Furthermore, I will also attach a snippet of the data source I have available to achieve this project. Thanks for your help and insights!