Discussions
Categories
Choose a Product
THRUST SERVICES
CORE APPS
CE PRODUCTS
...
Quick Links
POPULAR
HELPFUL TIPS
Groups
My Links
FOR SIGNED IN MEMBERS:
Back to website
Home
Designing Analytics Reports
Change max value of y-axis scale by group
Migrateduser
I am trying to figure out a way to change the maximum value of the y-axis scale of a chart dynamically within a report (by lowest level grouping) without having to calculate the maximum value in a query or computed column. The goal of changing the y-axis scale is to be able to visually compare the charts.<br />
<br />
The attached example shows more clearly what I am trying to do. The charts show the total price of products sold grouped by year and then by customer number. As you can see, within each year, the charts are scaled differently because each customer purchased different items. This makes it harder to compare.<br />
<br />
I'd like to be able to change the y-axis scale to be the same across all customer numbers, for <span class='bbc_underline'>each </span> year. It doesn't necessarily have to be the maximum data value, just the maximum value that BIRT chose as the y-axis scale.<br />
<br />
The issue with the charts I am working with in my actual report is that they have 4 groupings and the aggregations are a bit complex, so I am unsure of how to calculate the maximum data value beforehand. I would much rather change the axis dynamically as they are being rendered. Any thoughts?
Find more posts tagged with
Comments
There are no comments yet