Forum Discussion

haoshuai69's avatar
haoshuai69
New Member
6 years ago

Backlog (based on received date vs. processed date) bar chart

Hello,

 

In my dataset I have a row for every field on each form. Note that the number of fields (and thus rows) differs from form to form.

I have two columns that I would like to compare; each of these columns have date as format:

1. form_received_date

2. form_processed_date

 

I would like to make a bar chart that shows the number of backlogged orders over a range of dates. For instance, if a form is received on May 15 and processed May 17, the form should be counted in the backlog for May 15 and May 16. Backlog should be count_distinct on the form ID. Any guidance is appreciated and let me know for further clarification!

2 Replies