desktop

[kenblack]

I have 2 columns start and stop I want to count the number of start stop events according to the following rules 

counting starts when first discharge occurs

• any start in the first 12 hour block is counted as 1 event

• any new start in the next and subsequent 24 hour blocks are each counted as 1 additional event

• this counting continues until there is a 24 hour block with no event.

• for the next event after 24 hour block with no event, the sequence begins again

Could anyone help me please

Thank you in advance

[v-juanli-msft]

Hi @kenblack 

Besides, i will give an example, please help me to understand your requirements:

Please correct me if i misunderstand something.

Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@kenblack , You can get diff with min date time of block and use that to get id

diff with min date time block

new col= datediff( minx(filter(Table, [block] =earlier([block]) ),[date time]),[date time],hours)

[Pragati11]

Hi @kenblack ,

Can you please share some sample data to suggest a solutions for your query?

Thanks,

Pragati

[kenblack]

This should now work Pragatti11

https://onedrive.live.com/edit.aspx?cid=35fcf50beb555c0c&page=view&resid=35FCF50BEB555C0C!2223&parId...

[kenblack]

Thanks Pragati - here is my data

https://nwgcloud-my.sharepoint.com/:x:/r/personal/ken_black_nwl_co_uk/Documents/Discharge%20example%...

[v-juanli-msft]

Hi @kenblack 

My account has no aceess yo your file.

It is not recommended to share personal files/data into one drive personal.

If your file contains important and privacy data, please remove it.

Best Regards

Maggie

[kenblack]

does this work

https://onedrive.live.com/edit.aspx?cid=35fcf50beb555c0c&page=view&resid=35FCF50BEB555C0C!2223&parId...

[kenblack]

Hello Pragati 11 sorry to be a pain but i have tried to see how I can share a sample with you would you mind guiding me through that as well

Really sorry but thank you

[v-juanli-msft]

Hi @kenblack 

You could upload a excel file to one drive for bussiness, then share the url with us.

It is better to make the a small sample with expected result.

Best Regards

Maggie

[parry2k]

@kenblack you can share using one drive/google drive.

[kenblack]

Thanks Parry here is my data

https://nwgcloud-my.sharepoint.com/:x:/r/personal/ken_black_nwl_co_uk/Documents/Discharge%20example%...