Hello, All.
I have two evaluations that produce a result. The first result is the number of submitted requests. The second result is the number of closed requests. What I would like to do is subtract the closed requests from the submitted requests so I can add that result to a line chart. I have tried a couple of different ways, but without much luck. Here are the two evaluations:
This calculates number of submitted requests
/* START QUERY BUILDER */
EVALUATE
CALCULATETABLE(
ROW(
"CR Count (Status Detail)", [CR Count (Status Detail)]
),
KEEPFILTERS(FILTER(ALL('Workflow Status'[Status]), SEARCH("submitted", 'Workflow Status'[Status], 1, 0) >= 1))
)
/* END QUERY BUILDER */
The below formula calculates number of closed requests -
/* START QUERY BUILDER */
EVALUATE
CALCULATETABLE(
ROW(
"CR Count (Status Detail)", [CR Count (Status Detail)]
),
KEEPFILTERS(FILTER(ALL('Workflow Status'[Status]), SEARCH("closed", 'Workflow Status'[Status], 1, 0) >= 1))
)
/* END QUERY BUILDER */
