Your OQL is now failing because of the second count.
Untested, but this should do it:
FROM MyFirstModule.SourceData sd
SELECT
sd/City AS City,
Count (*) AS DN,
(SUM(CASE WHEN sd/Comparing_Result ='blank' THEN 1 ELSE 0 END) AS blank
GROUP BY sd/City
And to get the percentage, make the return-entity of executeOQL-activity have an attribute that is not ‘stored’ but ‘calculated’ and make the microflow calculate that percentage.
Dear Tim,
I just wonder why I cannot find blankpercentage in member of change object. Then I cannot do the calculation.
Entity screenshot:
microflow screenshot: