Scaling Problems and using/forcing Decimals on Y-Axis

Post general support questions here that do not specifically fall into the Linux or Windows categories.

Moderators: Developers, Moderators

Leddy
Cacti User
Posts: 93
Joined: Sun May 15, 2005 6:55 pm

Scaling Problems and using/forcing Decimals on Y-Axis

Post by Leddy »

Just started using cacti, so far so good.

I'm trying to create a Barometer graph with a range of 29.5 to 30.5. I try and specifiy the min max as decimals and it won't save unless I use whole numbers. My other other problem is the scaling of it since the numbers are so close it looks like a straight line across. I want a greater resolutions of numbers. I'm not concerned about "LINE" vs "AREA" as far as how it looks. Just what was mentioned. Any Ideas?

Auto Scale: unchecked
Auto Scale options: Use --alt-autoscale-max
Logarithmic: unchecked
Rigid Boundaries Mode: checked
Auto Padding: checked
Allow Graph Export: checked
Upper Limit: 31
Lower Limit: 29
Base Value: 1000
Unit Value: empty
Unit exponent Value: empty
Vertical Label: inHg
Attachments
2.jpg
2.jpg (79.28 KiB) Viewed 6149 times
This is what I have:
This is what I have:
1.jpg (88.26 KiB) Viewed 6149 times
Last edited by Leddy on Sun May 15, 2005 9:56 pm, edited 1 time in total.
Leddy
Cacti User
Posts: 93
Joined: Sun May 15, 2005 6:55 pm

Post by Leddy »

This is what I want:
Attachments
4.png
4.png (4.51 KiB) Viewed 6148 times
3.png
3.png (3.13 KiB) Viewed 6148 times
Leddy
Cacti User
Posts: 93
Joined: Sun May 15, 2005 6:55 pm

Post by Leddy »

I just wanted to bring this thread back to the light of day in hopes someone might have any suggestions on what settings I can use to get my graph to look similar to the sample ones shown. I'd like to see the greater accuracy of it that mine doesn't.

Any ideas?
User avatar
TheWitness
Developer
Posts: 17080
Joined: Tue May 14, 2002 5:08 pm
Location: MI, USA
Contact:

Post by TheWitness »

Laddy,

Open MySQL and look at the structure of the "data_template_data" table. Look for the MIN and MAX values column. If it is an integer format, it needs to be changed to VARCHAR. Then, you should be able to add a MIN value of 30.5 and a MAX value of 32.8 (or something like it).

Don't alter the structure without first backing up your database.

TheWitness
True understanding begins only when we realize how little we truly understand...

Life is an adventure, let yours begin with Cacti!

Author of dozens of Cacti plugins and customization's. Advocate of LAMP, MariaDB, IBM Spectrum LSF and the world of batch. Creator of IBM Spectrum RTM, author of quite a bit of unpublished work and most of Cacti's bugs.
_________________
Official Cacti Documentation
GitHub Repository with Supported Plugins
Percona Device Packages (no support)
Interesting Device Packages


For those wondering, I'm still here, but lost in the shadows. Yearning for less bugs. Who want's a Cacti 1.3/2.0? Streams anyone?
User avatar
TheWitness
Developer
Posts: 17080
Joined: Tue May 14, 2002 5:08 pm
Location: MI, USA
Contact:

Post by TheWitness »

Oops! Wrong table. Here are the two columns from:

Table: graph_template_graph

upper_limit bigint(12) NOT NULL default '0',
lower_limit bigint(12) NOT NULL default '0',

We need to change these from bigint to varchar(xx). I will send a note to the author, we have a release pending and maybe this should go into it.

TheWitness
True understanding begins only when we realize how little we truly understand...

Life is an adventure, let yours begin with Cacti!

Author of dozens of Cacti plugins and customization's. Advocate of LAMP, MariaDB, IBM Spectrum LSF and the world of batch. Creator of IBM Spectrum RTM, author of quite a bit of unpublished work and most of Cacti's bugs.
_________________
Official Cacti Documentation
GitHub Repository with Supported Plugins
Percona Device Packages (no support)
Interesting Device Packages


For those wondering, I'm still here, but lost in the shadows. Yearning for less bugs. Who want's a Cacti 1.3/2.0? Streams anyone?
Leddy
Cacti User
Posts: 93
Joined: Sun May 15, 2005 6:55 pm

Post by Leddy »

That did the trick! Thanks so much!
denverh
Posts: 10
Joined: Sun Mar 12, 2006 5:27 pm

Re: Scaling Problems and using/forcing Decimals on Y-Axis

Post by denverh »

[quote="Leddy"]Just started using cacti, so far so good.

I'm trying to create a Barometer graph with a range of 29.5 to 30.5. I try and specifiy the min max as decimals and it won't save unless I use whole numbers. My other other problem is the scaling of it since the numbers are so close it looks like a straight line across. I want a greater resolutions of numbers. I'm not concerned about "LINE" vs "AREA" as far as how it looks. Just what was mentioned. Any Ideas?
/quote]

I have a related situation. I am currently using version 0.8.6g_41 on FreeBSD, and part of what I'm doing is collecting barometric pressure data. I had no problems with a previous version, but when I started using this version, the charts for barometric pressure lost the decimals on the y-axis. You can see from the attached sample that they are all "30". I would like to see at least 1 decimal place, preferrably two.

My settings are:
Auto Scale: checked
Auto Scale Options: --alt-autoscale
Logarithmic Auto Scaling: no
Rigid Boundaries Mode: no
Auto Padding: no
Allow Graph Export: yes
Upper Limit: 31.00
Lower Limit: 28.00
Base Value: 1000
Unit Value: blank
Unit Exponent Value: blank

If I turn off autoscale, I get a y-axis range of 25 to 40, with an interval of 5. That results in an essentially flat line.
Attachments
y-axis values are all integers.
y-axis values are all integers.
graph_image.png (19.52 KiB) Viewed 5889 times
ldrolez
Posts: 9
Joined: Mon Nov 12, 2007 8:24 am

Post by ldrolez »

To have the same effect, I've added to '-Y' option (or --alt-y-grid) to the "$graph_opts .= " line in lib/rrd.php.

Maybe support for activating this option could be added for next releases ?

Ludo.
User avatar
gandalf
Developer
Posts: 22383
Joined: Thu Dec 02, 2004 2:46 am
Location: Muenster, Germany
Contact:

Post by gandalf »

087b currently supports
Use --alt-autoscale (ignoring given limits)
Use --alt-autoscale-max (accepting a lower limit)
Use --alt-autoscale-min (accepting an upper limit, requires rrdtool 1.2.x)
Use --alt-autoscale (accepting both limits, rrdtool default)
Support for --alt-y-grid is either planned or already implemented (I do not remember exactly if I've done it already. If not, it's definitively on the list)
Reinhard
marlow
Posts: 11
Joined: Tue Nov 06, 2007 12:04 pm
Location: Rahara, Co. Roscommon, Ireland
Contact:

Post by marlow »

ldrolez wrote:To have the same effect, I've added to '-Y' option (or --alt-y-grid) to the "$graph_opts .= " line in lib/rrd.php.

Maybe support for activating this option could be added for next releases ?
I second this. It would be nice to have.

I'm plotting voltage values from Mikrotik Routerboard 333's, the result of my query is the volt with one decimal, but the y-axis only shows it, if i add '-Y' to the rrdtool command.

/Martin
Communication is the beginning of understanding
-- AT&T
some_guy
Posts: 6
Joined: Tue Mar 04, 2008 2:58 pm

--alt-y-axis implementation?

Post by some_guy »

I saw a while ago that having an option for --alt-y-grid was in the roadmap for cacti, but I've upgraded to the latest version and still don't see it in the 'Auto Scale Options' for graph templates. Am I missing something, or is it still not implemented?

I have a need for it regarding a few graphs that are only changing extremely small amounts between data points and my graphs look weird without that option enabled...

Thanks!
some_guy
Posts: 6
Joined: Tue Mar 04, 2008 2:58 pm

Post by some_guy »

Oh, I see this thread:

http://forums.cacti.net/viewtopic.php?t ... alt-y-grid

So I guess it is in the pipeline. I thought Reinhard said it was in the pipeline a year ago (see earlier message in this thread, April 2008), is it reasonable to expect it to be in the next release of cacti?
User avatar
gandalf
Developer
Posts: 22383
Joined: Thu Dec 02, 2004 2:46 am
Location: Muenster, Germany
Contact:

Post by gandalf »

It's definitively in. See attached
R.
Attachments
--alt-y-grid is in SVN/main
--alt-y-grid is in SVN/main
grd.png (14.15 KiB) Viewed 4269 times
some_guy
Posts: 6
Joined: Tue Mar 04, 2008 2:58 pm

Post by some_guy »

Great!

I guess the next question is, do you have an estimate of when the next version will be released?

Not that I'm eager or anything. ;)
User avatar
gandalf
Developer
Posts: 22383
Joined: Thu Dec 02, 2004 2:46 am
Location: Muenster, Germany
Contact:

Post by gandalf »

some_guy wrote:Not that I'm eager or anything. ;)
Granted
I suppose the code won't be ready for BETA in 2009 (which is not much time left); perhaps in January 2010. You may want to watch ANNOUNCEMENT forum to participate in the beta program
R.
Post Reply

Who is online

Users browsing this forum: No registered users and 6 guests