1 of 1 people found this helpful
I would actually recommend putting the data in this structure:
Dates Class abs rates Q2 2016 A 63,312 $ 21.07 Q2 2016 B 2,500 $ 16.87 Q3 2016 A (214,856) $ 21.15 Q3 2016 B (46,299) $ 17.22 Q4 2016 A 118,480 $ 21.23 Q4 2016 B 39,231 $ 17.39 Q1 2017 A 56,382 $ 21.30 Q1 2017 B 14,886 $ 17.50
This organizes the data so that each column represents the same consistent definition and can be aggregated together easily. I would also recommend removing the totals - Tableau can recompute those easily, and having it in the data can duplicate the values. The only thing that isn't clear is how to represent the Total rates - not sure if that can be computed based off the class A/B rates or whether it is only something that lives separate. Either way, hope this helps!
Yep, that works. Hard to get away from thinking about the data in the other way.
Yes, I'll have to figure out the rates, as they are definitely weighted, but that is a small price to pay. Awesome, thank you.