I've been trying to search how to do this, but I can't find anything.
I have two date fields: created date and closed date. I also have two expressions in count of all orders, and count of orders closed if status=closed.
Essentially I want a grouped bar chart that counts orders created during a week, or closed during that week. However, adding the two date fields as dimensions doesn't work, and I'm not sure how to achieve this.
This is excellent!!! Thank you soo much! Conceptually I had an idea how to do it, but didn't know how to execute it. This is perfect, thanks for all the help!
