Announcement

Collapse
No announcement yet.

Jon00 Database Charting Utility for Homeseer 3

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • #91
    It's running again.

    I've forgotten to copy and paste the Scheduler.dll .

    Still one issue: The TitleColor doesn't work.
    If I leave it blank it is black.
    If I write a color there is no title shown.

    Regards, Fischi

    Comment


    • #92
      Not a good day yesterday.

      I've now hopefully sorted out all the issues with V1.0.3.2 which is now available.

      Steve,

      Not in the docs but there are now two values you can add to the Database:

      AutoAdjust=

      (Headroom adjustment 0.0 to 1.0 - Internally set to 0.1)

      AutoRoundValue=

      (Round up/round down value - Internally set to 10)

      For Example:

      AutoAdjust=0
      AutoRoundValue=1

      This should create a chart with the Y-axis showing the absolute Max/Min values.

      Hopefully it will give you the tools to get it looking as you want.
      Jon

      Comment


      • #93
        Originally posted by jon00 View Post
        Not in the docs but there are now two values you can add to the Database:

        AutoAdjust=

        (Headroom adjustment 0.0 to 1.0 - Internally set to 0.1)

        AutoRoundValue=

        (Round up/round down value - Internally set to 10)
        want.
        Works great. The flexibility you are giving us with this charting PI is just incredible.

        Currently I find
        AutoAdjust=0.05
        AutoRoundValue=5
        works well with most of my charts, but it's down to personal taste and the particular set of data you are representing.

        Thanks again.
        Steve

        Comment


        • #94
          Quick question on hourly data...

          Not sure if this has to be addressed here, or maybe requires me to create a script...

          I would like to chart hourly values, for example gas consumption of my boiler. I have one device from RFXCOM that gives me the accumulated daily usage, but if record that at hourly intervals, the data will only increase.

          Say at 09:00 accumulated consumption has been 5L
          At 10:00 accumulated consumption has been 6L
          At 11:00 it has been 6.5

          I would like to plot:

          at 10:00 --> 6-5 = 1
          at 11:00 6.5 - 6 = 0.5
          etc.

          Can this be achieved with the tool as-is? Any suggestions?

          Thanks!

          Sandro

          Comment


          • #95
            I do nothing with the data except store it in the database so you would need to manage this with a script.
            Jon

            Comment


            • #96
              OK, thanks Jon. I think I will go the route of creating a virtual device to hold the hourly consumption, populate that with data using a script and then chart it.

              Cheers!

              Sandro

              Comment


              • #97
                If you are using the internal 1 hour timer, it will run exactly on the hour so make sure that you update your virtual device just beforehand!
                Jon

                Comment


                • #98
                  Hello Jon,

                  Today I've tried the AxisXInterval to override the grid lines.
                  If I leave it blank it shows me a grid line every 5 minutes.
                  My X axis contents HH:mm .
                  I want to have a different with between the grid lines e.g. every 15 minutes.
                  Is this possible with an specified entry e.g. AxisXInterval=15 ?
                  I've tried this but it deoesn't work.

                  Regards, Fischi

                  Comment


                  • #99
                    I think you will need to have a play with different numbers as it depends on the time span of data you are displaying.
                    Jon

                    Comment


                    • Every time I put an entry (tried from 1.....25) into
                      AxisXInterval=
                      the grid disappears.

                      Fischi

                      Comment


                      • Jon, I see in the documentation that you allow reading and storing data from HomeSeer global variables. Have you thought about allowing reading and storing of data from HomeSeer Timers and Counters?
                        Billy Draper

                        Comment


                        • Jon,
                          is it possible to show the devicestring instead of the devicevalue
                          in the AxisXLabel ?

                          Regards,
                          Fischi

                          Comment


                          • Attached Files

                            Comment


                            • forgot to post the ini file's

                              Ed
                              Attached Files

                              Comment


                              • Originally posted by bdraper View Post
                                Jon, I see in the documentation that you allow reading and storing data from HomeSeer global variables. Have you thought about allowing reading and storing of data from HomeSeer Timers and Counters?
                                I'm not sure about timers but counters can be added.
                                Jon

                                Comment

                                Working...
                                X