SOLVED
Calculate the no. of. days
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
Ronal_bal
8 - Asteroid
‎04-21-2023
09:14 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
Solved! Go to Solution.
Labels:
- Labels:
- Datasets
7 REPLIES 7
17 - Castor
‎04-21-2023
09:25 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @Ronal_bal
There are two different approaches as you mentioned two different sets of logic:
- 'calculate the no. of. days when production status = 1'
- Add a filter tool for Production Status = 1
- Use a summarize tool to Group By 'Group' and count the shift dates
- count date between '2023-04-21' to '2023-05-15' as production status =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.
‎04-21-2023
10:16 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thanks for your reply, I'll try that. Attached the example as excel file
‎04-21-2023
10:17 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
‎04-21-2023
11:26 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
binuacs
21 - Polaris
‎04-21-2023
12:16 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
RobertOdera
13 - Pulsar
‎04-21-2023
02:46 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
RobertOdera
13 - Pulsar
‎04-24-2023
08:22 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
You're most welcome @Ronal_bal!
![](/skins/images/18F3BF3EB54AD3C2739B5AA9B77A7F97/responsive_peak/images/icon_anonymous_message.png)