RRD Conversion
Posted: Fri Dec 21, 2018 4:16 am
Hi Ladies and Gentlemen
First off I want to wish you all a very Merry Christmas and a Happy New Year, and I apologise if this has been mentioned in a previous thread but I am far to lazy to read every post on the forum, I have found a few similar but none that ask exactly what I am about too.
OK so what I am trying to do it convert the RRD timestamp into a human readable format. So after dumping the graph to the CSV I can open the spreadsheet and use a simple formula to convert the EPOCH/UNIX time & date to human readable. What I need to do next has me stuck and headbutting my keyboard in frustration
.. What I need to do is convert the graph output results from "4.00000e-02" into "0.04" for example. Does anyone know how this can be done, there has to be a way because Nagios does it when applying the results to the graphs.
The plan is to make a pretty dashboard for the management which is to be built in PowerBI, because we all know they love pretty graphs at their meetings without the hassle of actually logging into a Nagios and searching for what they need
First off I want to wish you all a very Merry Christmas and a Happy New Year, and I apologise if this has been mentioned in a previous thread but I am far to lazy to read every post on the forum, I have found a few similar but none that ask exactly what I am about too.
OK so what I am trying to do it convert the RRD timestamp into a human readable format. So after dumping the graph to the CSV I can open the spreadsheet and use a simple formula to convert the EPOCH/UNIX time & date to human readable. What I need to do next has me stuck and headbutting my keyboard in frustration
.. What I need to do is convert the graph output results from "4.00000e-02" into "0.04" for example. Does anyone know how this can be done, there has to be a way because Nagios does it when applying the results to the graphs.The plan is to make a pretty dashboard for the management which is to be built in PowerBI, because we all know they love pretty graphs at their meetings without the hassle of actually logging into a Nagios and searching for what they need
