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.
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.
@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.
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.
+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!
User | Count |
---|---|
43 | |
29 | |
24 | |
21 | |
13 |