5 Replies Latest reply on Oct 30, 2018 8:06 AM by Tim Dines

    Compare live sales data with sales on another date

    manoj kumar

      Hi Everyone,

       

      I'm new to Tableau and need a bit of guidance with respect to dates & calculations.

       

      My aim is to have a live dashboard which compares the sales on a specific day with the ongoing sales for the current day.

       

      Present day sales for each hour should be added & compared with the sales made on Day-X for the same time.

      Say the elapsed time is 1 hr 3 Mins on the present day. I wanted the sales made for with-in that 1hr + 30 mins to be added and compared with the sales made within that 1 hr 30 mins on Day-X.

       

      It will be really helpful if anyone could suggest how this can be accomplished. I have attached the sample data set, which has data for 12th Sep, which needed to be compared with 29th Oct.

       

      Thank you in advance,

      Manoj