I have a question regarding display of columns. If you refer to the dashboard in the attached, right now columns are shown: Passengers, market share, amt change from prev year, % difference, etc... then next to it the previous year's measures.
I would like it to show 2011 passengers, market share, 2010 passengers, amt change, % diff, etc... There are several more metrics in this data view, and some are from a different data source, and some are combined calculated from both sources.
Is there a way to change the orders of the columns around how I have it set up? Currently I am operating within Tableau's features using filters and table calculations for time range and metrics (so it shows all of 2011 first, and then measure for 2010).
I have explored using calculated fields but hit a wall because fields calculated from the secondary source are joined based on month (so you would have to work in time-specific localized calculated fields). There are 15 measures so it did not seem practical to approach it this way, at least in my limited working knowledge of Tableau.
Furthermore, localizing time fields too much in calculations seems like would make it impossible to toggle between a month view, a quarterly view, and year to date month/quarterly views by filtering to months necessary. From my explorations so far if time is localized in calculations, you would need to create exponentially more calculated fields to show them all separately. Please correct me if I'm wrong.
I would really appreciate if someone could show me how to set up my view so year over year measures are adjacent. Keep in mind, this will be a monthly report going forward though, so calculated fields would have to be replicated annually. What is the best method to approach in this situation? Really appreciate your help!!
avops_ex2.twbx 675.8 KB