3 Replies Latest reply on Jun 21, 2018 11:49 PM by Mavis Liu

    Need help in Date Calculation

    Joydip Thakur

      Hi Experts,

       

      In the current world we've one dataset like this -

       

          

      UPCPromoidStartEndDiscount
      UPC-1Promo-11/1/20171/4/201710
      UPC-1Promo-21/5/20171/8/201720
      UPC-1Promo-31/9/20171/12/201715
      UPC-1Promo-41/13/20171/16/201718
      UPC-1Promo-51/17/20171/20/2017

      30

       

      Now in Tableau we want something like this -

       

       

      UPCPromoidDateDiscount
      UPC-1Promo-11/1/201710
      UPC-1Promo-11/2/201710
      UPC-1Promo-11/3/201710
      UPC-1Promo-11/4/201710
      UPC-1Promo-21/5/201720
      UPC-1Promo-21/6/201720
      UPC-1Promo-21/7/201720
      UPC-1Promo-21/8/201720
      UPC-1Promo-31/9/201715
      UPC-1Promo-31/10/201715
      UPC-1Promo-31/11/201715
      UPC-1Promo-31/12/201715
      UPC-1Promo-41/13/201718
      UPC-1Promo-41/14/201718
      UPC-1Promo-41/15/201718
      UPC-1Promo-41/16/201718
      UPC-1Promo-51/17/201730
      UPC-1Promo-51/18/201730
      UPC-1Promo-51/19/201730
      UPC-1Promo-51/20/201730

       

       

      Can you please suggest any way we can achieve this in Tableau ?

       

      Thanks!
      Joydip.