Is it possible to set Min/Max value to the Y-axis on Dashboard chart.
I know that there is an option 'Always show zero level' but that is not good for me
I have % for axis Y and want to specify 90% as Min value, and 100% and Max value
How can I do that?
Thanks in advance
Currently our dashboard chart items do not provide the capability to specify axis ranges, they are calculated automatically. I have passed this ticket to our developers' team for further research.
Would you please clarify whether you need to use constant values as range bounds or use data binding to determine the range's bounds based on your data? Describe your scenario in greater detail. Our developers will take this information into account while discussing this feature.
Thanks for the reply and thank you for asking me to describe in details.
My scenario is the relatively simple: I have a system and want to monitor the availability of that system. The 'normal' values are around 98%, but they can deviate. Never above 100% though.
I would like to specify the min value 95%, max 100%. Probably to show the values as on the attached picture. I have also 3 ranges - bad (red) - below 95%, good (green) above 98.5% and Yellow (middle) range.
I would love to show yearly values as a bar chart, and clicking on an year, to change the graph to ->Line chart monthly for that year, and clicking on a month --> to show a graph for a daily values for that month.
The data for the Month is not aggregated from daily data, neither Yearly data is aggregated, but I have already pre-calculated data:
- ID, Date, DailyValue, MonthToDate, YearToDate, like that:
Id Date SADaily SAMonthly SAYearly LastUpdated
9 01-01-2013 0.99741 0.99741 0.99741 28-08-2013
10 02-01-2013 0.99106 0.99402 0.99402 28-08-2013
11 03-01-2013 0.98178 0.98976 0.98976 28-08-2013
12 04-01-2013 0.99450 0.99100 0.99100 28-08-2013
I would love as well to put some Gauge with ranges - see the attached picture.
Can you suggest some way to achieve good looking dashboard?
Thanks in advance
Hello Tzvetan,
Though the dashboard does not provide a way to customize the chart's max and min value, I suggest that you refer to a workaround from the Dashboards - winforms workaround to collect items controls article. I have prepared a sample to illustrate how to set min / max settings for the dashboard chart.
See also:
Visual Ranges and Whole Ranges
Thanks, Maxim
I am interested in Web application, not in Winform application
Any suggestions?
Hi Tzvetan,
Maxim's workaround is not applicable in a web application. I do not see any possible solution until this feature is implemented.
As for your question about gauges, our dashboards provides gauge items. Their ranges are calculated automatically. We have a separate ticket to extend this functionality: Gauge Item - Provide more binding parameters.
Hello,
I build the application DX_Sample.zip. When I run it and click on "Test" button, it does not rescale the Y Axis. What is the problem?
Hello Atilla,
I have checked these workarounds with version 14.2 and have not found a way to adapt it to this version. I understand why it is necessary for you to have this feature. We will notify you once we will have any news about in feature out of the box.
Copied from Dashboard chart - Introduce the capability to specify Min/Max axis range values
Hello Atilla,
I have checked changes made in version 14.2 and modified your code in the following manner:
private void simpleButton1_Click(object sender, EventArgs e) { ChartControl chartControl = (ChartControl)((IUnderlyingControlProvider)dashboardViewer1).GetUnderlyingControl("chartDashboardItem1"); SecondaryAxisY secondaryAxesY = ((XYDiagram)chartControl.Diagram).SecondaryAxesY[0]; secondaryAxesY.VisualRange.Auto = false; secondaryAxesY.VisualRange.SetMinMaxValues(Convert.ToDouble(0.4), Convert.ToDouble(0.7)); }
Please look at the attached sample.
Update:
Starting from 14.2 version WinForms Dashboard controls provide access to underlying controls and allow customizing them. Refer to the Access to Underlying Controls topic for additional information.
Use the following code to customize a chart's axis using this approach.
private void dashboardViewer1_DashboardItemControlUpdated(object sender, DevExpress.DashboardWin.DashboardItemControlEventArgs e) { if (e.ChartControl != null && e.DashboardItemName == "chartDashboardItem1") { XYDiagram diagram = e.ChartControl.Diagram as XYDiagram; if (diagram == null) return; SecondaryAxisY secondaryAxesY = diagram.SecondaryAxesY[0]; secondaryAxesY.WholeRange.Auto = false; secondaryAxesY.WholeRange.SetMinMaxValues(Convert.ToDouble(0.4), Convert.ToDouble(0.7)); } }
Hi,
It would be marvelous if you could enable us to specify this information as an option while designing the dashboard. Besides in real life a dashboard is not always designed by a developer but an end user. All end users will require it so. An option in X or Y axis settings or values pane in dashboard designer would be perfect!
Thanks
Onur
Any update on this feature ?
Thanks & regards
Hello,
We have not introduced this feature yet. At present, I cannot provide you with any estimated time frame on when it will be introduced. We will update this topic once we have any news. You will be notified of our progress.
In the meantime, I suggest you use workarounds described in this topic. Let me know if you require any assistance with implementing it in your application.
Hi
I would also like to know when this feature becomes available.
Regards
Kasper
Hi,
Any updates from 'Dashboard chart - Introduce the capability to specify Min/Max axis range values ' feature.
Thanks,
Ravi R.
Hi Ravi,
This feature is not available yet. At present, I can only suggest you use the workaround described in this topic.