Hello!
I am trying to create a report on a dashboard with the following requirement:
Single score
Active cases in my assignment groups where the case has had an update to the comments / worknotes that wasn't made by the person who the the case is assigned to.
Now, I can do most but unsure how to capture the updated by part:
changing the operator to "is different from" doesn't give the option to select assigned to.
Would anyone be able to assist in this?
The previous solution may still not work as The conditions are being applied to user table "Assigned to.Updated by" instead of "Incident.Updated by" so the workaround is to just go to all incident list add filters as below
Then right click on a column and create a bar/pie chart from there and then amend the report as you see fit before saving/sharing.
Basic steps...
1. Navigate to incident.list
2. Apply all the conditions as desired and now for "is different than":
- Updated by is different than "Assigned to.User ID"
3. Click Run
4. Once you fetch the results, right click on any column and select "Bar Chart" --> This will redirect you to report creation page.
5. Save the report
6. Now modify the report as per your business needs and leave the conditions untouched.
