2 Replies Latest reply on Nov 19, 2018 10:29 PM by manoj kumar

    Random Day over Day, hour over hour live comparison

    manoj kumar

      Hi Everyone,

       

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

       

      My aim is to have a live dashboard which compares the sales on the date & hour with another sale day & hour. Sale day is 14th Nov & 9:30 AM. Sale is in progress.

       

      If i wanted to check the total sale made until this hour and compare the total with another random sale day for the same hour on that specific day. How it can be calculated.

       

      It will be really helpful if anyone could suggest how this can be accomplished and share the calculation or formula.

       

      I use Tableau 10, so it will be best if you could share the formula.

       

      Thank you in advance,

      Manoj