Here's an option:
- I would start by bringing in the DateTimeNow input tool (In/Out category). This will update the date you're using to compare to today's date whenever the workflow is run. (Make sure you change the format to the standard yyyy-mm-dd format for ease of use later in the workflow.)
- Append the date to your data (before or after filtering for Status = ACTIVE) using the Append Tool
- Convert [asset_changeddate] to the proper date format (I did this in a formula, but you could also use the DateTime tool in the Parse category of tools)
- Calculate the difference between today's date & asset_changeddate using this formula: DateTimeDiff([DateTimeNow],[asset_changedate],"months")
- Use the Summarize Tool to Group By DateDifference (i.e. number of months in the past) and then Count the same field to see the total # of Active assets for each "Months Ago" group
In this example, "0" months will be assets that changed in the last month, then "1" will be from the month prior, etc. Month difference should be calculating based on the same day in the comparison month, so if you wanted to use a standard 28 days or something, you'd need to change from "months" to "days" and divide by your standard day count, etc.
Take a look at the attached workflow - I added a few more dates to check that it was working, seems to get the results you're looking for! Let us know if that works. Otherwise might help to see a sample of what you expect the output to look like? Thanks!
NJ
