ws01

Order On X-Axis In Drilldown (Collabion Chart)

Recommended Posts

I DrillDown a MainChart in months, but the order in wich months appear on X-Axis isn't correct. Data Provider for the Chart is a SharePoint List. Please see screenshot at attachement. Thxs for help ...

Share this post


Link to post
Share on other sites

Hi,

 

I am afraid, you missed to attach the screen shot.

 

Regarding the issue, could you please make sure that the column type for Month field is of DateTime Data Type? And could you please also post the screen shot of the wizard after moving to "Select Fields" step and highlighting the columns which you use for Grouping and Drill-Down?

Share this post


Link to post
Share on other sites

Hi,

 

I am afraid, you missed to attach the screen shot.

 

Regarding the issue, could you please make sure that the column type for Month field is of DateTime Data Type? And could you please also post the screen shot of the wizard after moving to "Select Fields" step and highlighting the columns which you use for Grouping and Drill-Down?

 

Hi,

 

column type for month is "Choice" , and the 12 monthes are listed in the Choice-Window. If the column Type is DateTime users can't enter a month ? I attached the differents screenshots. ?I'm working in a german country, so: "Monat" = Month . Thanks for helping me !

post-35531-0-86132800-1358946965_thumb.png

post-35531-0-92971200-1358946974_thumb.png

post-35531-0-74668600-1358946983_thumb.png

post-35531-0-46128800-1358947014_thumb.png

Edited by ws01

Share this post


Link to post
Share on other sites

Hi,

 

Thanks for the information.

 

We have checked the scenario but I am afraid, it would only if the column type is Date and Time.

 

Hi,

 

Sorry for delay !

 

I don't understand, if column type is Date and Time I can't type in a month ?

 

Best regards

Share this post


Link to post
Share on other sites

Hi,

 

What I mean is if type of column is not datetime, the code will not be able to identify whether the data inside that column is datetime value or plain text value. And even if we forcefully check and convert words like 'Jan', 'Feb', 'Mar' etc to datetime fields there'll be still issues which can arise such as:

1. Conflict with the Month name e.g. 'Jan' or 'January'

2. Things will be more complicated if data contains month text in different language other than English.

Share this post


Link to post
Share on other sites

Hi,

 

What I mean is if type of column is not datetime, the code will not be able to identify whether the data inside that column is datetime value or plain text value. And even if we forcefully check and convert words like 'Jan', 'Feb', 'Mar' etc to datetime fields there'll be still issues which can arise such as:

1. Conflict with the Month name e.g. 'Jan' or 'January'

2. Things will be more complicated if data contains month text in different language other then English.

 

Hi,

 

I understand, Thanks for your help.

 

Best regards

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now