Days difference

[ivoiculescu2020]

Hello team,

I need your help again to figure out how to get the amount of days between 2 approval dates: a label is generated and needs to be approved in 2 parts: internal approval and country/language approval. The report I try to compile will need to show the amount of days it took the country approvers to sign off on the label since the internal approver put in their approval (excluding the weekends!)

I attached a sample of my report. The column in yellow shows how the data should look like.

I tried to group by Job, Max_internal approval date and group by country approval date but it does not show me ANY results

I tried to group by Job, Max_internal approval date and MAX_country approval date but it does not show me the right data because the country approvers don't approve the same day so this way would exclude data.

Thank you for your help!

[ivoiculescu2020]

@GrowthNatives 

Hello again,

I configured the Generate rows exactly as you indicated, I excluded Saturdays and Sundays (and this works!), however it still does not work.

I attached a screenshot of how the generate rows tool is configured in my workflow.

thanks,

[GrowthNatives · Accepted solution]

Hi @ivoiculescu2020,

Thanks for sharing the screenshot — your Generate Rows tool is set up correctly, and it's great that weekend filtering is working! 

If you're still getting incorrect day counts, especially values like 15 days between 14-Mar and 18-Mar, the issue is most likely caused by duplicate rows entering the Summarize step.

Here’s what to check:

1. After filtering out weekends, add a Unique Tool or Summarize using Group By: Job, Country Approver, Dates to ensure there are no duplicate daily records before counting.
2. In the Summarize Tool:
   • Group by Job, Country Approver, or whatever your unique identifiers are.
   • Count the number of distinct Dates only (not rows!).
3. If you joined anything back to the main data before counting days, make sure that the Join didn’t cause duplicates.

You can also use a Browse Tool after filtering weekends to visually confirm that each date between internal and country approval is only listed once per job approver.

Let me know if you'd like help reviewing the full logic or want to share a snapshot of your Summarize configuration! Happy to help you get it 100% accurate.

⭐Hope this solution helps you make the most of Alteryx! If it did, click 'Mark as Solution' to help others find the right answers.

💡Found it helpful? Show some love with kudos 👍 as your support keeps our community thriving!

🚀Let’s keep building smarter, data-driven solutions together! 🚀