did you try to PIVOT your rows into columns before use in Tableau?
Not sure how I would do that as this is coming from a SQL query. Can you point me at some reference material possibly? Thanks so much for assisting me with this!
if you do PIvot in Custom SQL in Tableau, you would get Column structure for your dates instead on rows.
And I think after you can do your comparisons in easier way.