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

    exclude string set  and date today set analysis

    Joanna Seldon


      Hiya

       

      I have a calculation - set analysis  as follows

       

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

       

       

       

       

      but my two tables have a string in my data load 

       

      e.g

      dataload

       

      '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