| Author |
Message |
thakuramit1981
Newbie
Joined: 13 Apr 2009
Online Status: Offline
Posts: 14
|
   Topic: set maximum and minimum limit of gauge chart
Posted: 13 Apr 2009 at 10:22am |
|
The problem i am facing is :
I have a requirement in which the i need to display the data based on
1)completed Inspections.
2)total inspections.
The data is grouped in two levels district and county.
so
the chart displays the completed inspections for all districts and
compared with the total inspections.Then the chart further drill down
to county level when the user selects the district, it generates the
chart for all the counties.
The number of completed inspections
and total inspections is different for each district and county. so the
minimum and maximum limit should be shown independent for each district.
but currently it show a constant limit based on the highest value for the district.
suppose we have 6 districts., the data for:
district 1: completed inspection:2684,totalinspections :5184
district 2: completed inspection:3000,totalinspections :6000
I want to show the graph min: value for district 1 is 0 and max 5184
min value for district 2 is 0 and max 6000.
Could someone please help me as this is very urgent
|
 IP Logged |
|
|
DBlank
Moderator
Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
|
Posted: 13 Apr 2009 at 12:52pm |
|
What is the data you are using to display in the chart (Chart Expert Data tab) and how do you have your Data Values set in the Chart Expert > Axes Tab > Data Values section?
Edited by DBlank - 13 Apr 2009 at 12:53pm
|
|
IP Logged |
|
thakuramit1981
Newbie
Joined: 13 Apr 2009
Online Status: Offline
Posts: 14
|
Posted: 13 Apr 2009 at 12:59pm |
|
I using a group chart and advanced chart
in group chart : on change of district Id
show Summary for completed Inspections
In the advance chart
I am showing on change of district Id show
total inspection and completed inspections.
In the data section i have data axis set to auto range.
I can not set a manual limit as the data for each district is different
Edited by thakuramit1981 - 13 Apr 2009 at 1:01pm
|
|
IP Logged |
|
DBlank
Moderator
Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
|
Posted: 13 Apr 2009 at 1:04pm |
What about the setting for the Data Values in the Chart Expert > Axes Tab > Data Values section?
This is where you control your min and max...
It should auto change your min and max values if you have Auto Range set as True.
|
|
IP Logged |
|
thakuramit1981
Newbie
Joined: 13 Apr 2009
Online Status: Offline
Posts: 14
|
Posted: 13 Apr 2009 at 1:10pm |
|
I tried to put in the maximum and minimum value. but then that does not provide a solution as the maximum value remains constant.
i want the maximum value to be the value of total inspections for that district.
I want it like this: http://epic229.dep.state.fl.us/WasteFirst/Menu.do?menu=charts
this application is based on kawa charts, i am trying to convert it to crystal
if you click on the completed contractor inspection: you will know what i am trying to accomplish, I am using group charts to accomplish drill down
|
|
IP Logged |
|
thakuramit1981
Newbie
Joined: 13 Apr 2009
Online Status: Offline
Posts: 14
|
Posted: 13 Apr 2009 at 1:13pm |
|
I will be very grateful to you if you could help me solve this issue
|
|
IP Logged |
|
DBlank
Moderator
Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
|
Posted: 13 Apr 2009 at 2:59pm |
Sorry but nothing is jumping out at me right now.
Note that you can only use drill down in a chart if you use the Data as a Group. As far as I am aware you cannot use the Advanced option in the chart and still drill down. If you must use the chart drill down you have to design the report around this.
I'll have to look at this some more tomorrow to see if I can come up with anything.
If anyone else has any ideas feel free to jump in.
|
|
IP Logged |
|
thakuramit1981
Newbie
Joined: 13 Apr 2009
Online Status: Offline
Posts: 14
|
Posted: 13 Apr 2009 at 6:31pm |
I am using a drilldown chart, it works fine , but i am not able to set the limits, that is what is causing trouble.The maximum limit is same for all districts, its should be different for each district.I.e the value of total inspections for each district.
I really appreciate your help and hope to find a resolution soon as this is a critical requirement.
|
|
IP Logged |
|
DBlank
Moderator
Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
|
Posted: 14 Apr 2009 at 7:43am |
I think I know what may be going on here. Are you placing this in the Report header or a Group Header?
If you place it into the report where there is only one Gauge per header it will aplly the individual range, if you place it in a header that would require it to have more than one gauge it applies the values from the gauge with the largest range to all of the gauges.
Make sense?
Edited by DBlank - 14 Apr 2009 at 7:44am
|
|
IP Logged |
|
thakuramit1981
Newbie
Joined: 13 Apr 2009
Online Status: Offline
Posts: 14
|
Posted: 14 Apr 2009 at 7:49am |
yes thats true i have it placed in the report header so it displays me 6 gauges for all 6 districts. This is the requirement too.
Is there a way we can handle this and set the limit based on actual value
?
|
|
IP Logged |
|
|
|
