Hi , I have a set of incidents data which is ...

(Rajaah Dhananjey) #1

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?

(Suvrutt Gurjar) #2

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.

(Rajaah Dhananjey) #3

That worked like a charm! I had completely forgotten about slices. Thanks for the prompt input!