Create a chart with the last 30 days as the X axis, and a count of different date fields as the Y axis
Let's explain the situation.
I have a table that our business uses to track the completion date of several, a potentially unlimited number of steps in a process. Let's use the step "Approved" as an example. Currently, it is very simple to create a chart that shows how many items were approved on each day between now and a certain date using filters. However, there are a few problems:
1. It doesn't show every day, it will only show the dates that have been filled in in the Approval Date field
2. This does not allow us to add more date fields to the chart to track.
I would like to create a line chart that shows the last 30 days, and the count of each step that happened on that specific day.
I have thought of a way to do this using another table and automations for each date field, but this seems overkill. I am wondering if there is a built in way to do this using formulas or other.
Thank you very much for any response!
- Sterling Long!