Running Sum based on dates in Alteryx

[ganesh11k]

Hi All,

I want to add the vin count based on specific date range by branch wise, kindly support. For Example, on today i need sum of 19th July'23 to next 2 days and date range will be new everyday, thanks

Regards,

Ganesh Kumar

[jdminton]

You can do this using the summarize tool. Select group by on the branch, region, and any other fields you want to see in the result (your image 2) except for the count field and "sum" on the count field.

 

 

[ganesh11k]

Hi,

Date range selection is missing.

Regards,

Ganesh Kumar

[jdminton]

Your output did not show a date range. Are you trying to select certain dates to sum?

 

[Prometheus]

If you're going to change the range every time, you should turn your workflow into an analytic app. You can use a filter tool to filter down to two dates then use the Date tool and associated Action tools to replace the dates you choose. Any time I create an app that has a date range, I use a generic start date of '2001-01-01' and a generic end date of '2001-01-02' and configure the Action tools to replace those dates in the filter to whatever dates I choose using the Date interface tools. I also used the summarize tool to group by Arrival Date and sum "CountDistinct_Vehicle ID No.". I finished it off using the Running Total tool, because you want a running sum, correct?