Uploaded image for project: 'Observium'
  1. Observium
  2. OBS-4785

Export Counter Values for a specific date

Details

    • Help
    • Resolution: Done
    • Minor
    • None
    • Professional Edition
    • Default

    Description

      Hi,
      I am currently looking for a way to bulk display/export a lot of counter values for a specific date.

      The idea behind this would be to obtain the energy values for the monthly or annual bill. The values are all available in Observium and I would like to avoid using other software for this.

      I imagine this as in the view: /health/metric=counter/
      Except that I can still select the time period for the value displayed in the list.

      Is this possible?

      Thanks!

      Attachments

        Activity

          [OBS-4785] Export Counter Values for a specific date
          adama Adam Armstrong added a comment -

          Hi,

          The only place this data exists is in the RRDs. It's quite fiddly to get data out of the RRDs in a generic fashion, but you can generate a graph of the period you want and then ask for the JSON representation of the graph, and use the data provided.

          If you click on a graph, you can select JSON format in the export menu. This basically just puts &format=jsontime on the image URL and outputs a JSON block instead.

          For power you can probably extrapolate a single usage value from the average W * time. 

          If you're using a Wh sensor, you can probably ask for a graph of a time period and diff the min + max from the legend? These are contained in text near the top of the JSON output.

          Note that data in RRD is averaged over time, so it's not accurate enough to do 95th or similar billing from.

          Adam.

          adama Adam Armstrong added a comment - Hi, The only place this data exists is in the RRDs. It's quite fiddly to get data out of the RRDs in a generic fashion, but you can generate a graph of the period you want and then ask for the JSON representation of the graph, and use the data provided. If you click on a graph, you can select JSON format in the export menu. This basically just puts &format=jsontime on the image URL and outputs a JSON block instead. For power you can probably extrapolate a single usage value from the average W * time.  If you're using a Wh sensor, you can probably ask for a graph of a time period and diff the min + max from the legend? These are contained in text near the top of the JSON output. Note that data in RRD is averaged over time, so it's not accurate enough to do 95th or similar billing from. Adam.

          People

            landy Mike Stupalov
            swfeldkirch Siegfried Gumilar
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: