Need help sorting in a bar chart

[#1]

Hello Friends

I have bar chart the dimetionn is Product and the expressions are like

Networking days(Start_Date - Process_Date),

Netwroking days (Process_date - Final_Date) and

Networking Days(Final_Date - End_Date)

I don't know how to sort the higest combined of all in a decending order.

Could you please suggest a solution for this.

Regards

Chriss

[advait_thakur]

Hello Chriss,

To achieve the same you need to go to the properties of bar chart.

Go to the Sort tab and choose your dimension and click on Numeric Value.

Choose Descending in order.

May be this is the solution you are looking for.

Thanks

Advait

[#3]

Hi Advait,

Thanks for your reply, I tried all the options in the sort but its not coming as what I expected.

in the Sort/ expression option I tried Max(

(Start_Date - Process_Date) or

(Process_date - Final_Date) or

(Final_Date - End_Date)) but the output is wrong.

can you please suggest any workaround.

Regards

Chriss

[advait_thakur]

Hello Chirss,

First of all you cannot display sort on all three expressions.

Will you please let me know on what format your date is coming ?

Also try to convert the date in numeric value and then perform the sorting which will be the easy way.

In the meantime will you please try sorting on Y axis by going to the properties.

Thanks

Advait

[#5]

Hello Advait,

Thanks for your help, now its working fine...

Regards

Chriss