12 Replies Latest reply: Nov 13, 2014 9:06 PM by jagan mohan rao appala RSS

    Limiting the date as a calculated dimension

      Good day!


      I have a transaction table in DB and load data from it. In this table all the transactions have its own timestamps (EFFECTIVEDATE) and types (SOURCEKEY). I group them by date using DATE(FLOOR(EFFECTIVEDATE)) function and use this field as a dimension.

      Could you please help me to limit dimension by last 10 days and show them in the bar chart?