1 of 1 people found this helpful
Unfortunately my internet isn't quick enough to download and work on your workbook! But please see the below instructions:
1) Create a calendar dataset - this is just a list of dates, make sure it includes the min and max of your date range:
2) Inner join this to your dataset using a join calculation of 1, this creates a many to many match and adds in new rows of data. E.g. if the start and end date if 1st jan and 3rd jan, there will be 3 rows of data created:
Then go to a worksheet and create the calculation
Calendar date >= start date
Calendar date <= end date
Put this in the filters shelf and set it to true.
Then use calendar dates in your visualisation, and use something like a count distinct of an id to plot the line.
Like this ? note I've filtered the nulls.
Step 1 - drag Start date onto columns shelf
Step 2 - calculate date difference
Step 3 - drag date difference onto size
HTH 18.2 attached
Clubs Visualization.twbx 203.5 KB
Thanks very much for this--I made an attempt, but am still... stuck.
I think the problem might be that I am doing the join improperly. When I attempt to join the Calendar Date dataset onto my data, it doesn't know just what to join it onto--the beginning date, the end date, or the IDs of the various organizations in the datasets.... I've tried a bunch and they don't seem to work properly.
I've attempted to re-upload a smaller packaged workbook. But it's still pretty big.
Thanks so much for your help, but I'm looking for a different visualization--I'd like the X axis to be year, and the Y access to be the number of clubs which are active during that year.
I made a mistake in joining the tables: here's an updated version if you'd like to take a stab.
Well it's a Halloween miracle! I fiddled around with the joins and I got the visualization working! Thank you so much for your spooky help!
Now to make sure everything's working out as it should!