I've got data structured like the below:
What I'm trying to make is a time series line chart, where the x axis is the date, the y axis is the count of the IDs, and there are three lines- each is the count of the ID that occurred on the date for event1, event2, and event3.
Is that possible in Tableau from the way my data is structured? I imagine I can pivot my data so that it looks like
and build the chart from there.
However,I'd really prefer to not have to do that in my data source itself (lots of other parts of my Tableau dashboard are based on the existing data structure as it is currently laid out, and it's by far the most efficient for these other aspects of the dashboard).
Is that pivoting action possible to perform within the chart calculations and rendering?
You can connect more than once to the same data source. Just duplicate the data connection. Then edit the copy to pivot the Events into a single date field. Best of both worlds.