Forum Discussion

SterlingLong1's avatar
SterlingLong1
Qrew Trainee
6 years ago

Create a chart with the last 30 days as the X axis, and a count of different date fields as the Y axis

Hey guys!

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!

  • You will need to have a child table driven by Automations to log all the status changes and then chart those.

    The only way to get every single day to list would be to have a dummy record for each date preloaded via Excel.  One trick is to load those with a "value" field of zero, but have the real ones load with a value of 1.

    Then,  instead of counting the # of Statuses for that day on the chart count their "Value".  The dummy ones have no value and will be flat lined on the x axis.  :)