How to get Score in Text Object overall month wise Score

[ravikumar_iyana]

Hi,

I need to show the top 3 store ID based on the score over the month.

This is i can able to see in the 'straight table' but i could not able show in the 'text object'.

My score expression is (Sum(A+B+C)/Sales)*1000 , Here I need to categorize in to 3 groups.

1)   Score which is <= 20 , I need to show the store name whose score start from "0". and their sales.

2)  Score >20 and <=50,  Here i need to show top 3 score store names and their score as well

3) Score  >50, Here also  i need to show top 3  score store names and their score as well.

Date	Store Name	A	B	C	Sales	Score
01-01-2018	ABC	25	10	5	40	3.4568
02-01-2018	DEF	2	9	10	21	3.4863
03-01-2018	LMN	62	56	5	123	5.896
04-01-2018	PQR	20	5	3	28	45.5689
01-02-2018	ABC	5	9	12	26	6.852
02-02-2018	DEF	35	16	8	59	64.852
03-02-2018	LMN	5	9	15	29	2.6541
04-02-2018	PQR	5	2	3	10	3.2598
01-03-2018	ABC	6	140	85	231	80.258
02-03-2018	LMN	52	46	75	173	77.264
03-03-2018	DEF	49	52	25	126	4.258
04-03-2018	PQR	2	2	3	7	0.451

More Information Please refer below Excel.

Thanks,

Ravi.

[ravikumar_iyana]

Thanks for your Quick response.

My Time Zone belongs to IST (INDIA)

[vishsaggi]

Hey Ravi,

Not sure if this is what you are looking for. Please check attached. And let me know if this is wrong, coz i need to know more information using atleast one example. Like if you select a carrier code who are the top 5 drivers should be coming in the text object, you have to let me know. We can have a call if you are ok and still have issues.

Check attached. .

[ravikumar_iyana]

Thanks Viswarath,

That's great. This what i want. There is a small changes for Yellow and Red.  That Drivername should be displayed based on their  high score, not with kmstravelled.

Sure. We can have a call. +91-8121513181 for more discussion.

[vishsaggi]

Check attached.