topic Re: Create a for loop to sort the months and get the middle/median value (URGENT) in App Development

Create a for loop to sort the months and get the middle/median value (URGENT)

sandp707 — Tue, 05 Jul 2022 17:12:10 GMT

Hello everyone,

Could someone please help with a script as this is very urgent.

I want to create a for loop to sort on basis of 3 Months and get the middle values from measure.

Data granularity - Under market there are products, and we can same product name under multiple markets

Column E -

This is the sample data screenshot, here I want to create a for loop with a counter which will sort the Count (column D) for every 3 months (column A) and bring the middle/median of the Count column and place it in Column E (highlighted).

Column F -

This column is difference between the median derived from above for loop and the current month

Column G -

This is again the median from Column F (difference) and this should also be from a for loop.

I want this using for loop as because the number of months to derive the median can be 3,4,5... as per the client request.

Thanks,

Sandeep

Re: Create a for loop to sort the months and get the middle/median value (URGENT)

MarcoWedel — Tue, 05 Jul 2022 22:10:23 GMT

are you looking for a script solution or a chart expression?

Re: Create a for loop to sort the months and get the middle/median value (URGENT)

sandp707 — Wed, 06 Jul 2022 01:35:10 GMT

Hello Marco,

I am trying to achieve from script. If you can help with chart expressions is also great.

Thank you

Re: Create a for loop to sort the months and get the middle/median value (URGENT)

sandp707 — Thu, 07 Jul 2022 03:26:16 GMT

Hello everyone,

I need to see the median of the previous 3 records.

Where, prev 3dlvry = median of previous 3 records

actual deviation = difference between current count and the median of prev 3dlvry

typical deviation = total median of actual deviation