1 Reply Latest reply on Apr 19, 2018 2:27 PM by Amber Loranger

    % Difference QoQ using date field

    Jesse Narang

      Hi, tableau community,

       

      I have a simple viz that looks like below:

       

      I have an activity date filter on the top right as you can see. I am trying to do one of the 2 things below:

       

      1. Have another date field right underneath the activity date filter which will compare the values from activity date vs other date field column and show % difference values right next to the measure i.e something like below

       

      or

       

      2. Comparing same time previous quarter using date range selected in the activity date filter i.e if I select 1/1/2018 - 2/28/2017 in the activity date filter then automatically the % difference column should compare the first 2 months of the current quarter against 2 months of the previous quarter.

       

      I hope I was able to explain my problem but more than happy to explain further if required.

       

      I have attached my workbook also.

       

      Thanks in advance!

       

      Best,

       

      Jesse