Hey there,
I am not sure if this is the right forum for my question, but I think someone here might have an idea how I could solve the following:
I have a report that gives me the time-difference (time working vs. time on tickets/issues) of each employee to help make sure all the working time is somehow booked on tickets/issues for month-end billing.
Right now, two employees are monitoring these time differences and are contacting each employee individually in order to help him minimize these differences.
I would like to automate this process and was thinking of using metrics/scorecards or alerts in combination with flows (power automate) in order to send an email to the relevant employee(s).
However, I am not quite sure how/if I can accomplish this when my employees don't have access to Power BI and therefor I need to transfer the email adress (which I have in my dataset with all employee data) for each metric/KPI (time difference in % --> checked weekly) from the dataset to the recipients as a placeholder.
does someone have an idea how I could realise this or did someone already implemented something similar?
Looking forward toyour ideas and suggestions
Best wishes from Germany
Vanessa
