Change awareness dashboard

[CHH]

Hi all

I'm trying to make a dashboard that covers the following in 4 separate tiles

• Upcoming changes due to start in the next 24 hours that still require my groups approval
• Upcoming changes due to start in the next 7 days that still requires my groups approval
• Changes I've approved that are due to start in the next 24 hours
• Changes I've approved that have been marked as complete in the past 24 hours

Does anyone know how I'd go about doing this?

Many thanks

[SANDEEP DUTTA]

Hi @CHH ,

Can you share what you have done so far? where are you facing the challenge?

[CHH]

Hi. I'm struggling to find which filters I should be applying. Is there a template for this that I can apply and then edit as necessary? 

[Dr Atul G- LNG]

Hi @CHH 

To create all these reports, it's not possible using only the Change table.
You’ll need to create a Database View that includes the sys_approval table and the Change table. Once the view is set up, you can then create reports based on appropriate filters.

If you just want to know how many changes are scheduled in the next 24 hours or 7 days, that can still be done using filters directly on the Change table.
But for anything that involves related approval data, a Database View is necessary—there's no other way around it.