Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

SSRS secondary axis percentage Expand / Collapse
Posted Wednesday, June 25, 2014 11:30 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, October 26, 2015 12:06 PM
Points: 9, Visits: 126
Hi All,
I have tried all possibilities and searched several forums but none of them specify in detail how to display percentage values in SSRS chart. I need to set min value, max value and the interval. If I do that, the chart does not plot my graph properly. This is my query

SELECT Weekend

And the raw data.

Weekend TotalItems Pickedup on time Delivered on time

2014-05-24 00:00:00.000 2071 1000 600
2014-05-31 00:00:00.000 2440 800 1200
2014-06-07 00:00:00.000 2499 300 1600
2014-06-14 00:00:00.000 2662 1700 500

I need to show Total Items on Y-axis and WeekEnd on X-axis. Also I need to have secondary axis to show Pickedup On time and Delivered On time as line chart. To achieve this I am showing this on secondary axis and Total Items on primary axis. My problem is that if I set y-axis percentage properties (min value, interval etc), it displays the axis labels properly but does not plot the lines on the chart. If I do not adjust the label properties, it plots the lines on the chart but not using the correct values.

I have spent almost whole day researching this but of no use. Can someone please explain me clearly how do I prepare the data to display percentage value properly on the chart? Do I need to calculate those as percentages or decimal values or an express as pickedupontime/totalItems? The following is the chart I am expecting but the pickupontime/deliveredontime lines should be plotted properly.

Please let me know if you have any questions to solve this problem.


  Post Attachments 
chart.png (7 views, 68.85 KB)
Post #1586025
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse