2 Replies Latest reply on Apr 18, 2016 11:46 PM by Michał Wrobel

    How countD dimension elements in date range

    Michał Wrobel

      Hi,

       

      I have Date and dimension.

       

      For each Day I need to countD dimension element in last 5 days.

       

      For example for 12.01 i need to countD element from 7.01 to 12.01 = 3

      For example for 13.01 i need to countD element from 8.01 to 13.01 = 3

      For example for 5.01 i need to countD element from 1.01 to 5.01 = 5

      ScreenHunter_121 Mar. 31 17.17.jpg

       

      How to calculate this in tableau ?

       

      Is it possible ?

       

      Regards Michał