logarithmic scale in charts

**sandy.s** · 12-09-2010, 06:44 PM

I am trying to set up a chart, which would have several categories of very different magnitudes. For example, imagine a chart of two trends: total number of some kind of events in millions and a number of events with errors in, say, hundreds or thousands. Errors will be invisible without logarithmic Y scale. So I want Y-axis to go 1, 10, 100, 1000, 10000 etc. instead of 1, 2, 3, 4... One possible way is to do it on a level of DB query: "select category, log10(amount) from ...", but it changes the labels on the Y-axis to logarithms. I want labels to stay the same: original number of events.

**pmalves** · 12-09-2010, 06:48 PM

I think that can be implemented with CCC ..

**sandy.s** · 12-09-2010, 09:03 PM

Originally Posted by pmalves

I think that can be implemented with CCC ..

Could you elaborate a little?

**sandy.s** · 12-13-2010, 12:10 PM

Originally Posted by pmalves

I think that can be implemented with CCC ..

Could you at least decipher what does CCC mean? Thanks.

**sandy.s** · 12-22-2010, 06:05 PM

That was super helpful so far

**pmalves** · 12-22-2010, 06:08 PM

Right... nothing a quick view on this forums couldn't answer, but anyway:

http://pedroalves-bi.blogspot.com/20...omponents.html

http://www.webdetails.pt/ccc/pvcTest.html

**sandy.s** · 12-22-2010, 08:27 PM

Any documentation to get started? I am running biserver-ce-3.6.0-stable now and use .xaction with SecureFilterComponent for html forms with parameters like date ranges and such, then feed those to SQLLookupRule and then to ChartComponent, which has .xml file with properties. Do I need to upgrade to 3.7.0? Do I just change ChartComponent to some other component with different properties in .xml? Or something else? Are there examples in 3.7.0 similar to those for ChartComponent and Flash charts in Steel Wheels solution example? Thanks.

**pmalves** · 12-22-2010, 09:21 PM

You can try downloading and installing CDE 1.0-RC3, it has an example of a dashboard that uses CCC charts

**sandy.s** · 01-06-2011, 03:01 PM

I installed CDE 1.0-RC3 and played with dashboard editor. Very nice. What I could not do so far is to change X axis labels on a time series line chart so it would show every hour. By default it only shows 6 AM and 6 PM of each day.

And how do I approach doing my log Y-axis scale? I did not notice such settings in the advanced properties of charts.

Thanks.

**pmalves** · 01-07-2011, 06:55 AM

Originally Posted by sandy.s

I installed CDE 1.0-RC3 and played with dashboard editor. Very nice. What I could not do so far is to change X axis labels on a time series line chart so it would show every hour. By default it only shows 6 AM and 6 PM of each day.

This is a bug in protovis - need to fix it...

Originally Posted by sandy.s

And how do I approach doing my log Y-axis scale? I did not notice such settings in the advanced properties of charts.

Thanks.

I need to implement it yet, but you could try to go to the source and chance pv.Scale.linear with pv.Scale.log

-pedro