Im hoping one of the many EDNA community PBI experts can help me on this one, I really wanted to try and work this out on my own but I’m on a deadline so need some help please
Here is the scenario. I have a report that provides insights into the Companies Health and Safety Management systems. The date the event is reported in the system is important to the company and the requirement KPI is that the event is reported in the system within 24 hours of the event occurring.
The Health and Safety management system records the date an event is recorded in the system “Created On” Date and the Date the Event Occurred - the “Occurred Date”.
To further complicate the scenario, the Company wants to alert the Health and Safety Team where an event is reported in the month following the event occurred and by how many days.
An example of what I am trying to achieve is in a table using conditional formatting highlighting two results, highlight in Orange where the “Created On” date is greater than the Occurred Date by more than 2 days and the second condition is Red when the Created On date is greater than the Occurred Date and the Created On date falls into the month following the “Occurred Date”
Any help to get me started on solving this problem would be much appreciated.