Use Text Tool to Describe Data Output

[do55]

I have built a workflow that combines several datasources and performs several "tests". Each test is recorded as its own column, {Test A: "Pass"/"Fail"} {Test B: "Pass"/"Fail) .....

Is there a clever way of analysing the outcome of these tests? I would like to finish the workflow with an email that says in the body:

XXXX records inspected with the following tests performed:

Test A: XXX records passed, XXX failed. (X%)
Test B: XXX records passed, XXX failed. (X%)

Test C: XXX records passed, XXX failed. (X%)

See attachment for detail of exceptions. 

The only way I can see to make this work is to add a filter, count and join for each XXX above which seems needlessly messy. Is there an easier option? 

[grossal]

Hi @do55,

I think I got something for you:

The result looks like this:

I'll attach the workflow for you. Let me know what you think.

Best

Alex

[zajaccount · Accepted solution]

Hi,

I first used the multi field formula to convert all the "passes" and "fails" to numbers (1 for passed 0 for failed).

Then I used the summarize tool to count the sum of the results columns and the counts, and then a formula tool to calculate the percentages and failed tests.

After this, these fields can be used in a text report:

Please see the attached workflow and let me know if it works for you.

[do55]

Great solution thanks!
I was previously going down a Python route, nice to use the native features.