Calculate the no. of. days

[Ronal_bal]

calculate the no. of. days when production status = 1 .

Below example, need to count date  between '2023-04-21' to '2023-05-15' as production status =1 . 

I need to calculate the same for different groups.

[Luke_C]

Hi @Ronal_bal 

There are two different approaches as you mentioned two different sets of logic:

1. 'calculate the no. of. days when production status = 1'
   1. Add a filter tool for Production Status = 1
   2. Use a summarize tool to Group By 'Group' and count the shift dates
2. count date  between '2023-04-21' to '2023-05-15' as production status =1
   1. Probably requires a more robust set of logic in case there's 0s in the middle of the dataset, but could leverage multi-row tools, date time functions, etc. 

Attaching data (not a screenshot) and expected results would help determine the best approach. 

[Ronal_bal]

Thanks for your reply, I'll try that. Attached the example as excel file

[Ronal_bal]

@Luke_C 

[Ronal_bal]

@Luke_C 

could you help me with multi-row formula?

[binuacs]

@Ronal_bal One way of doing this

[RobertOdera · Accepted solution]

Hi, @Ronal_bal 

Kindly consider the options below.

I hope you find them helpful - Cheers!

[RobertOdera]

You're most welcome @Ronal_bal!