Does anybody know how to trigger workflows or...

(James Bowker) #1

Does anybody know how to trigger workflows or even format rules when the group aggregate (COUNT) reaches a certain value?

Basically I have a group aggregate of [Arrival Date] which counts the number of arrivals on each day, I am looking to either set up a format rule or workflow email when this COUNT exceeds a certain value, any help would be much appreciated.

(Aleksi Alkio) #2

You could send the email with the scheduled report. If you set it as once a day, it will trigger that email if your count limit is over.

(James Bowker) #3

@Aleksi_Alkio thanks but I cannot reference the COUNT value as it is not an actual column in the spreadsheet, it is automatically generated in the UX section. I have grouped by arrival date then set up the aggregate as COUNT.

(Steven Coile) #4

You’d need an expression that performs the count. For instance:

COUNT(SELECT(MyTable[_RowNumber], ([SomeColumn] = “Desired Value”)))

replacing MyTable, SomeColumn, and Desired Value as appropriate.

Then compare that value to your threshold:

COUNT(…) > 25

replacing 25 as appropriate.

(James Bowker) #5

+Steve Coile thanks, that seems to have worked! I knew about the SELECT function but was struggling to get it working, I was missing out the _RowNumber so that seems to be why! Thanks again!