Expressions based on different dimensions.

[#1]

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.

Any ideas?

[#2]

Anyone have any info on this? Or is my question confusing?

[maxgro · Accepted solution]

PFA, hope to understand

[#4]

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!