6 Replies Latest reply: Nov 18, 2015 2:27 PM by Sunny Talwar RSS

    exclude string set  and date today set analysis

    Joanna Seldon



      I have a calculation - set analysis  as follows


      count({$< Department = {"Furniture"} >}Customer_No)





      but my two tables have a string in my data load 





      'Daily' AS "DateType"  .......Table 1


      'Weekly' AS "DateType"  .......Table 2


      I need it only to count


      count({$< Department = {"Furniture"}, DateType="{Daily"} >}Customer_No)


      but I still have to on the filter pane DateType select the  Daily, for the correct number to show




      also I need to only include OrderDate Today(),  weirdly in kpi on date shows  1899




      please help