Time slices into monthly values

Question
1

Good afternoon, suppose a list like this:

Period Label
From To Product 363
06/12/2022 04/01/2023 63.31

I want EDT to transform it into monthly values:

06/12/2022 → 31/12/2022: value XXX (63.31 spread over 26 days)
01/01/2023 → 04/01/2023: value YYY (63.31 spread over 04 days)

What would be the best way to do it please? Thanks, Oliver

Attachment - data example
Product 363.csv (438 Bytes)

2

@oliv_reg

Is this what you wanted?

image
image929×461 57.2 KB

Transform File.
TimeSlickesintoMontlyValues.transform (2.4 KB)

1 Like
3

Hello and thanks for being so swift :slight_smile:

This is what I am looking for:

image
image253×719 4.45 KB

4

@oliv_reg

Is this it?

image
image750×475 62.9 KB

Transform File.
TimeSlickesintoMontlyValues2.transform (3.9 KB)

1 Like
5

@oliv_reg

I think this is it.

image
image807×509 68 KB

Transform File.
TimeSlickesintoMontlyValues3.transform (5.0 KB)

2 Likes
6

Almost Sir, in the top post I specified that the 113.029 are spread (divided) over 29 days (because there are 29 days between between Dec 6th and Jan 4th) so 113.029 / 29 days = 3.89 per day as in my screenshot above (for this time slice only, next time slices are different). Otherwise the quantity is multiplied by 29 (days) which is irrelevant. What is the (clean) quantity per (clean) month? Regards, Oliver

image

7

@oliv_reg

Kindly check my post before your reply, does it solve your problem?

1 Like
8

Is exactly that Sir, bravo! :clap:

Note: EDT doubles some dates while only one Jan 4th here is okay:
image

This is enough:
image

9

@oliv_reg

It is not EDT, the data is over lapping.

image

1 Like
10

Indeed I have to amend this otherwise it is not okay, thank you for your valuable help sir!