Hi , I have a set of incidents data which is entered into the app whenever the incident happens. I know how to set up a workflow to send a mail for that specific incident when a new row is added.
I want to set up a weekly reports system which will send a list of all the incidents happened in that week. How to split up the data for the report on week basis?
Hi @Rajaah_Dhananjey, You may wish to create a slice on the said table with a filter condition such as
[Date]>=(Today())-7
You can then schedule a weekly report based on that slice.
That worked like a charm! I had completely forgotten about slices. Thanks for the prompt input!
User | Count |
---|---|
18 | |
10 | |
8 | |
6 | |
5 |