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



      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.





      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