• Register
    • Login
    • Search
    • Recent
    • Tags
    • Popular

    Please Note This forum exists for community support for the Mango product family and the Radix IoT Platform. Although Radix IoT employees participate in this forum from time to time, there is no guarantee of a response to anything posted here, nor can Radix IoT, LLC guarantee the accuracy of any information expressed or conveyed. Specific project questions from customers with active support contracts are asked to send requests to support@radixiot.com.

    Radix IoT Website Mango 3 Documentation Website Mango 4 Documentation Website

    Charting number of events over time

    User help
    3
    4
    67
    Loading More Posts
    • Oldest to Newest
    • Newest to Oldest
    • Most Votes
    Reply
    • Reply as topic
    Log in to reply
    This topic has been deleted. Only users with topic management privileges can see it.
    • ricardo
      ricardo last edited by

      Hi all,

      I looked through the forum, but I cannot find anything related. How can you chart the number of events over time? For example a bar chart of number of urgent events of data points per day for a 1 week?

      BR,
      Ricardo

      1 Reply Last reply Reply Quote 0
      • ricardo
        ricardo last edited by

        Any ideas?

        1 Reply Last reply Reply Quote 0
        • R
          Ralf last edited by

          Hi Ricardo,

          maybe:
          create a SQL-Data-Source and connect to the h2-db,
          Select statement: SELECT COUNT(ID) FROM events WHERE ISNULL(ackTs)
          create one numeric datapoint, run the query and log the history.

          Or:
          Check the alarm-icon with the counter inside the header.
          There is something like

          <span ng-bind="$ctrl.renderCount($ctrl.events.totalCount)">16</span>
          
          1 Reply Last reply Reply Quote 0
          • MattFox
            MattFox last edited by MattFox

            Just a thought, but is there not an internal mango datapoint you can take a snapshot of with a meta datapoint? Either that or make api calls and store the result.
            At least then you could graph that however you like.
            Nice idea with the SQL query Ralf

            Fox

            Do not follow where the path may lead; go instead where there is no path.
            And leave a trail - Muriel Strode

            1 Reply Last reply Reply Quote 0
            • First post
              Last post