3 Replies Latest reply on Jun 18, 2019 5:16 AM by Mahfooj Khan

    Hour Wise Calculation in Tableau

    Rajiv Kumar

      Hi,

       

      I am working on a report in which I have to calculate some data with respect to current date. That means calculation changes with hours on each date. I am working on a MYSQL Server Data base through which Tableau is connected.

      I have to calculate last one hour data every hour from my SQL Data Base. Since there is no "Hour" function in Tableau, this makes my calculation not working properly.

       

      For example current time is 3:00  and i want  a calculation which gives me last one hour data ( i.e. 2 to 3 PM) and similarly after one hour that is at 4:00 it gives me last one hour data (i.e. 3 to 4 PM) and so on.

       

      I have date but i don't know how to calculate w.r.t. hour.

       

      Any help will be appreciated.

       

      Thanks,

      Rajiv