5 Replies Latest reply: Dec 1, 2017 7:44 AM by Supriya R RSS

    Compare two date fields using set analysis in table

    Supriya R

      Hi,

       

      i have table with Date dimension and measures. Here i want to compare dimension date with canonical date in measures and get value for only that date.

       

      Dimension:

      campaign_start_date


      Measure:

      count({$<CanonicalDate = {'=campaign_start_date'},DataType = {'opens'}>}distinct invitation_id)

       

      Here i want count of invitation where campaign start date equals canonical date

       

       

       

      Please let me know if i you need more info.

       

      Please help me on this