Bar Chart Help

[Anonymous]

Hi guys,

I have a bar chart that I'm looking to show our top 10 suppliers on.

I should have 10 suppliers all showing as 100% (as defined by a score expression), so to then order them correctly I would do a sort on the amount of Spend.

However, it's not bringing them back in the order I would expect.

What should I specifically do to achieve this? I've tried all manner of sorts, expression limits, etc.

Many thanks,

Gareth

[kusumanchir]

Hi Gareth,

Please find the modified app with my sample data.

Regards,

Rasly.K

[sunny_talwar]

What is the expected output that you need here?

[Anonymous]

Hi Sunny,

I need a bar chart to show the top 10 suppliers based on their overall score, and where suppliers have the same score a secondary sorting using their spend is needed.

The examples I've seen work, but yet it won't work on my master data.

[Anonymous]

Hi all

I'm wondering if my Overall Score expression is the cause of the issue.

//Weighted Overall Score % (Comprised of Averaging the Overall PO, Invoice and Pay scores)

//Weighted as follows - PO (20%), Invoice (60%) and Pay (20%)

((RangeAvg(Count({<[Receipt Entry Date(GL)],[Receipt Entry Date(GL)]-={''} >} Distinct [PO Number])

/

Count(Distinct [PO Number]),

1-(Count({<[PO Number] ={"=[Invoice Date]-[Order Date]<0"}>} Distinct [PO Number])

/

Count(Distinct [PO Number])))*0.2)

+

(RangeAvg(Count({<[FTMR_P2P_KPI]={"Success"},[Purchase Order Document Type - Code]-={''} >} Distinct [Invoice Number])

/

Count({<[FTMR_P2P_KPI]={"Failure","Success"},[Purchase Order Document Type - Code]-={''} >} Distinct [Invoice Number]),

Count({<[Scanned/Tradex]={"E"} >}Distinct [Invoice Number])

/

Count({<[Scanned/Tradex]={"E","P","S","T"} >}Distinct [Invoice Number]))*0.6)

+

(RangeAvg(If(Count(Distinct [Invoice Number]) <=0, '',

If(1-(Sum([Open Amount])

/

Sum([$(=CTName)])) > 1, 1,

If(1-(Sum([Open Amount])

/

Sum([$(=CTName)])) <0, 0,

1-(Sum([Open Amount])

/

Sum([$(=CTName)]))))),

If(Count(Distinct [Invoice Number]) <=0, '',

1-(Count({<[Days Overdue]={'>0'}>}[$(=CName)])

/

Count(Distinct [Invoice Number]))))*0.2))

It doesn't help that as we work from a server, I can't save the app and attach. Also, I can't create variables hence the long expression!

Thanks,

Gareth

[sunny_talwar]

I am still not 100% sure I follow.... in your attached sample, which supplier do you expect to see in the bar chart?

[Anonymous]

So in my example,

I would expect to see SBV VItesse, FC Utrecht, PSV Eindhoven, VVV-Venlo, Feyenoord, PEC Zwolle, Heracles ALmelo, AFC Ajax, AZ Alkmaar and SBV Excelsior on the bar chart because they have they all scored 100% and then they have the 10 biggest spends among all those who scored 100%.

[sunny_talwar]

SBV  Vltesse scored 100%? How do I see this?

10 biggest spends among these? Again where do I see this? Am I missing a sheet? I am still trying to figure out where to see this information?

[Anonymous]

OK,

so using the screenshot you've attached...

It should sort by Weighted Overall Score, then by Spend (if there are still

suppliers that are the same, sort alphabetically).

So, on the chart the following should be on there in this order - H, I, K,

L, M, N, B, C, D, E

[sunny_talwar]

Check out the attachment

[Anonymous]

Hi Sunny

When I look on the example you attached, it works fine.

When I try it in a real life business scenario, I get the following:

Thanks

Gareth