4 Replies Latest reply on Jun 9, 2018 3:13 PM by Deepak Rai

    How to consider the union of date fields in Tableau to populate a line and bar chart in tableau

    Archana Sharma

      Hi Team,


      Case study: I have  two fields called snap shot IB and Snap shot PQM, I want to consider the union of these 2 fields and need to drag it on column section and I have 2 measure values called IB and Complaint #, which I need to drag it in row shelf to visualize a line/bar chart.

      My Snap shot IB and Snapshot PQM is having same values in year/mm form (i.e, 201601, 201602 until 201806)


      I need to validate the things like


      if (snapshot ib >= '201601' or snapshot PQM >='201601') then 'yes' end


      So, when I am considering only snapshot pqm in column shelf my Complaint # is coming fine as expected, whereas my IB # goes off. And when I am only considering snapshot ib in column shelf my IB # comes fine and Complaint # goes off.



      My ask : How I can consider the 2 date fields in column shelf and populate the line/bar chart so that my IB # and complaint# are as expected .


      Attaching the .twbx created from Tableau 10.2



      Looking for any solution or suggestion ASAP.