Hello! I've been asked for an Analytics dashboard on how many people attended our museum over Memorial Day weekend (Fri-Sun) each year. I have it set up as a pivot table for each year with the three days broken out and then totaled. But I'm thinking that there must be a way with multi pass aggregation to do this as a column chart with each three-day block as a single column, but I don't even know where to start. Has anyone done something like this?
Thanks!
Anne RobichauxCRM AdministratorThe Historic New Orleans Collection
Hi Anne,Are you trying to have something look like this, or is this what you already have?
That would work! What I have right now is this:I'd rather have a total for each year and have it all in a single widget.
Thanks - what I have are 2 values(custom quick formulas), (1 is just a copy of the other, with the date changed):I'm just looking at total ticket count, filtered by performance date (days in date):The 1st value would be this here with the filtered date range:Then the 2nd value would be the copy of that value, and with the date range looking at last year's comparable weekend:Then you could just keep making copies and changing the date range.
Thank you! I knew I was missing something incredibly easy and obvious. I was able to turn it into a column chart and get what I wanted.