2 Replies Latest reply on Oct 24, 2016 6:03 PM by Pallavi Sarawgi

    How to calculate a sum over a period of time?

    Pallavi Sarawgi

      Hi,

       

      I have a situation where-in i need to calculate sum of a record's value for a period of 10 seconds. If the time now is 04/08/2016 4:17:46 PM, then i need to know how many alarms have been raised within the next 10 seconds and so on.

       

      Is there a way to do over-a-time-period calculation in tableau?

        • 1. Re: How to calculate a sum over a period of time?
          praveen p

          Hi Pallavi,

           

          Could you please provide some sample data

           

          Thanks

          • 2. Re: How to calculate a sum over a period of time?
            Pallavi Sarawgi

            Hi Praveen,

             

            My workbook fetches data from database (MYSQL). However, i can provide some info here. Developing report for a trouble-ticketing system, i have a scenario where in we monitor number of alarms raised every second. My data looks like:

             

                         DateTime                                    AlarmCount

                         04-08-2016 11:12:23am                 4

                         04-08-2016 11:12:25am                 1

                         04-08-2016 11:12:27am                 2

                         04-08-2016 11:12:35am                 1

                         04-08-2016 11:12:45am                  2

             

            and so on.. Here number of alarms raised in the system and their time is being stored in database. I have a requirement where-in i need to calculate number of alarms between every 10 seconds i.e, between

            11:12:23 to 11:12:33 and then 11:12:34 to 11:12:44 and so on....is there a way i can calculate sum over a period of time?