This is a migrated thread and some comments may be shown as answers.

Week days are not shown in order on pie chart

4 Answers 15 Views
General Discussions
This is a migrated thread and some comments may be shown as answers.
Shiwani
Top achievements
Rank 1
Shiwani asked on 15 Mar 2017, 01:22 PM

Hello,

I created a report in Telerik report designer R3 2016, in which i created a Pie chart which is showing data availability % in days with days name in series, But the days name coming in ascending order not in day's order (i.e. Sunday, Monday, Tuesday, Wednesday, Thursday, Friday, Saturday)  

Please refer the attached image.

4 Answers, 1 is accepted

Sort by
0
Stef
Telerik team
answered on 15 Mar 2017, 02:16 PM
Hello Shiwani,

The order of series determines the order of legend items.
You can define the sort order through the data and its order of records, or through the Graph.SeriesGroups.Sortings where you can create an expression setting the order of series.

In case each pie is a separate series object, you can set the order of the Graph.Series elements in the report designer.

I hope this helps.

Regards,
Stef
Telerik by Progress
Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Feedback Portal and vote to affect the priority of the items
0
Shiwani
Top achievements
Rank 1
answered on 16 Mar 2017, 05:56 AM

Hi Stef,

Thanks for reply, But your given solution sorts the weekdays in alphabetical order.

can you suggest me the expression to sort days in daywise order i.e.(Monday, Tuesday, Wednesday, Thursday, Friday, Saturday, Sunday)

0
Stef
Telerik team
answered on 16 Mar 2017, 05:38 PM
Hello Shiwani,

The sorting order is determine by the used field and its type.

In the data source, you can add a field that sets the order of each record, and use that field in the sorting expression. Or you can use a custom function that gets the string representing the day and returning an integer, that can be used for sorting the series.

Regards,
Stef
Telerik by Progress
Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Feedback Portal and vote to affect the priority of the items
0
Shiwani
Top achievements
Rank 1
answered on 17 Mar 2017, 04:40 AM
Thanks, I used the same.
Tags
General Discussions
Asked by
Shiwani
Top achievements
Rank 1
Answers by
Stef
Telerik team
Shiwani
Top achievements
Rank 1
Share this question
or