Add a field for "today's date" to calculated metrics. This would allow us to perform arithmetic on certain date fields without needing additional fields added to the dataset.
Example 1: If I wanted a gauge to tell a technician how long they have to complete a task, I could create the following calculated metric: [Due Date] - [Today's Date] = "Days Until Deadline"
Example 2: If I wanted a gauge to tell a project manager if any assigned tickets are past due, I could create the following calculated metric: [Today's Date] - [Due Date] = "Ticket Past Due"
Comments
0 comments