How to Plot fill rate% over different months

[Anonymous]

I have to plot Fill rate% (should be calculated) over different months on a line chart. For this I have Order Execution Status(Closed, Cancelled, Open), Quantity Ordered and Date in my data.

Fill Rate% =Sum of Quantity(When Order Execution Status="Closed")/Total Quantity (for that Month)

How do I perfrom this calculation?

[danb]

@Anonymous - can you provide a sample of the data you are working with / tables?

[Anonymous]

@danb

[danb · Accepted solution]

@Anonymous

Here is what i would recommend. Create a few different calculated columns:

Month

Closed Quantity

In addition create one Measure:

Fill Rate %

You will then have the ability to plot your fill rate by month in whatever format you like. Here is a matrix view. 

[Anonymous]

Thanks @danb It did work