Pie chart sorting

[#1]

In the below chart,

1. Removed "Suppress when value is NULL" and "Show all values" under Dimension tab.

2. Removed "Supress Zero values" under Presentation tab.

Correct sorting order:

             <=40

40<.......<=50

50<.......<=60

60<.......<=80

             >80

I had created a sort order as above under the "Expression" option under sort tab.

As far as i see the sort is also happening correctly. Actually its treating the categories with values separately and 0s separately. So if i remove the zeros from the chart, it shoufd be good.

But what i want is the Correct sorting order irrespective of whether it as values or not.

Any ideas guys?

Thanks in advance

Robinson

[#2]

Please post sample qvw so we will you more

[nizamsha]

post some sample qvw .

[#4]

Hi Robinson,

How are you boss.

Create a small inline table with the same order and link into the base field this table like below

LOAD * INLINE [

    Bucket, Rank

                 <=40, 1

    40< to <=50, 2

    50< to <=60, 3

    60< to <=80, 4

                 >80, 5

];

After that in front end go to the sort tab choose expression as sort type call the field Rank as created on inline table.

Regards,
Santhosh G

[#5]

I am fine Santosh.

Thanks guys... I will try what Santosh has suggested and let you know.

Will post a sample if above doesnt work. I hope it does 😉

Thanks,

Robinson

[nizamsha]

PFA