Get the max of a sum filtered by time

[Leoraoliveira]

Hello, 

I am trying to create a radar chart that the values of a seller are relative from the best seller in that category in the period of time that I have filtered in my Dash. So I have created a table to have a weekly sample of my categories:

So, in my dash I want to be able to filter a period as for example 01/jan to 07/jan so the total result of the sellers would be:

With this filter of date, I would like to see if I filter S1 in the Radar chart C1 = 25/25 = 1 and C2= 13/27 = 0.48.

If S2 is filtered then C1 = 22/25 = 0.88 , C2 = 27/27 =1

If S3 is filtered then C1 = 1/25 =  0.04 , C2 = 1/27 = 0.037

But if I filter the period of 01/jan to 14/jan the total results would be now:

Thus, filtering each Seller I want to have in my radar chart:
S1 -> C1 = 40/52 = 0.77 , C2 = 28/46 = 0.61

S2 -> C1 = 52/52 = 1 , C2 = 32/46 = 0.69

S3 -> C1 = 4/52 = 0.08 , C2 = 46/46 = 1

My main problem is that with the table that I have created I can get the sum of the values in a period of time or the max value of the period, but I could not get the Max of the Sum in the filtered time. 

If anyone can help 🙂

[v-zhangti]

Hi, @Leoraoliveira 

Sorry I didn't fully understand. What is the maximum value of the sum of the output you expect as a result? Does it change with the filter? And what is the result of the change? Please also give me an example, thanks.

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.