Metric Definition - Can I somehow create a reference table column
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-29-2024 06:46 AM
Hello,
I have the following requirement: click on ‘Pending Approvals’ tile , list out those cases where PT member approval required and there should be additional column ‘Number of days pending’- which means today's date - BM Approved date or Submitted/Resubmitted date:
So as per the screen shots below, showing the tile with the current table columns and then a metric definition, is there any way outside of Performance Analytics to accomplish the task above. I do not believe you can add a table column to our main table that would somehow reference this metric definition which is why I am asking in case I may be missing something or there is a way that someone here can share please and thank you.
This tile on the dashboard when clicked displays the table values shown below:
Metric Definition that has been already created:
Thank you,
Annette
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-29-2024 11:34 AM
I believe I may have figured this one out by utilizing the Updated column from our table instead which shows the date and time of the last update to the case.