Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.5K Microsoft Dynamics NAV
- 18.5K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 115 Navision DOS
- 854 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 615 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 267 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 992 SQL General
- 384 SQL Performance
- 33 SQL Tips & Tricks
- 34 Design Patterns (General & Best Practices)
- Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.7K General
- 1.1K General Chat
- 1.6K Website
- 79 Testing
- 1.2K Download section
- 23 How Tos section
- 259 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
Options
Sorting on X-Axis in Chart in RTC
wellington
Member Posts: 10
Hello,
I have generated a chart where on X-Axis, I have months like January 2011, February 2012, March 2012 etc., and on the Y-Axis I have total sales amount for that month.
The table from where I get data has following structure.
No. Month Sales
1 Jan 2011 $10,000
2 Feb 2011 $5,000
3 Apr 2011 $9,000
Now when I generate a chart, it shows following way.
15|
|
|
10| x
| x
|
5|_____________x_____________________
Apr 2011 Feb 2011 Jan 2011
Here, as you can see X-Axis values are sorted ascending. Instead, I want to sort it in the periodic way.
i.e. Jan 2011...Feb 2011...Apr 2011 etc.
Can you please help me solving it?
Regards.
I have generated a chart where on X-Axis, I have months like January 2011, February 2012, March 2012 etc., and on the Y-Axis I have total sales amount for that month.
The table from where I get data has following structure.
No. Month Sales
1 Jan 2011 $10,000
2 Feb 2011 $5,000
3 Apr 2011 $9,000
Now when I generate a chart, it shows following way.
15|
|
|
10| x
| x
|
5|_____________x_____________________
Apr 2011 Feb 2011 Jan 2011
Here, as you can see X-Axis values are sorted ascending. Instead, I want to sort it in the periodic way.
i.e. Jan 2011...Feb 2011...Apr 2011 etc.
Can you please help me solving it?
Regards.
0
Answers
In NAV 2009 R2 charts with a discrete axis always sort the strings alphabetically.
In NAV 2013 we have switched off the default sorting, in order to allow using a discrete axis inorder to allow situation where the sorting in the table is important, like for custom data axis rendering.
Christian Abeln
Program Manager Microsoft
Dynamics NAV
blogs.msdn.com/cabeln/
You're right my friend. The table contains the Dates as strings, as I have to show them in X-axis in <Month Text> <Year,4> format. I hope we get more control over Chart customization in NAV 2013. Btw, when is NAV 2013 going to be released?
Thanks for your post.