Eve Report post Posted August 8, 2013 How you adjust how Month (text) is displayed in a drill down chart? Parent Chart is grouped by Fiscal Years, when you click on the a FY the drill down displays the month data. However, the incorrect order of the months display. Accending/Descending is not practical in this situation. The months are listed in the correct order in the SP list. SharePoint 2010 I am new to Collabion charts so any guidenance you can provide would be helpful. Thank you in advance. Eve Share this post Link to post Share on other sites
Rahul Kumar Report post Posted August 8, 2013 Hi Eve, Could you please check and let us know the following: 1. Column type of your year column 2. Column type of your month column If both are of Text type then it'll be considered as normal text string not as month. Please refer to http://forum.fusioncharts.com/topic/13183-order-on-x-axis-in-drilldown-collabion-chart/#entry51866 to know more on this. Share this post Link to post Share on other sites
Eve Report post Posted August 8, 2013 I updated the Month from Text to Date/Time field in the SP list. In the drill - down chart, I would only like to display "January, February, etc" instead of 01/31/2013 12:00:00 AM. How would I do that? Share this post Link to post Share on other sites
Rahul Kumar Report post Posted August 8, 2013 Hi Eve, Please open the wizard, go to "Group & Drilldown": 1. Select the Month column in "On the horizontal axis, group by: " option, now since it has Date/Time field you'll see a new option "where dates are grouped by the". Choose "Year" in it. 2. Select "one or more field(s)" radio option. 3. Select required aggregation function in "Choose from the following series" option. 4. Check the option "Display a drill-down chart..." and select "Month" in this combo box. 5. Finally click 'Apply' and 'Finish' the wizard Now, you'll be able to group you data with Year and drill down to Month. Share this post Link to post Share on other sites
Eve Report post Posted August 8, 2013 That worked great! However, a year is different then a Fiscal Year. I will have to display the data this way for now. Thank you Share this post Link to post Share on other sites
Rahul Kumar Report post Posted August 8, 2013 You are welcome. And we'll try to improve this in coming version of the product. Share this post Link to post Share on other sites
Eve Report post Posted September 11, 2013 Do you have a beta out for the next version? I would love to give it a run Share this post Link to post Share on other sites
Rahul Kumar Report post Posted September 13, 2013 Hi Eve, I am sorry, it is still in development stage. Share this post Link to post Share on other sites
