
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎08-16-2022 05:55 AM
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?
Solved! Go to Solution.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎08-16-2022 06:06 AM
Hi,
Can you please try dot walking Assigned to.User ID is different from updated by.
You need to select "Show related fields" for some fields to show.
Mark Correct or Helpful if it helps.
***Mark Correct or Helpful if it helps.***

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎08-16-2022 06:06 AM
Hi,
Can you please try dot walking Assigned to.User ID is different from updated by.
You need to select "Show related fields" for some fields to show.
Mark Correct or Helpful if it helps.
***Mark Correct or Helpful if it helps.***

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎08-16-2022 06:14 AM
Great news! that is spot on, many thanks

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎08-16-2022 04:52 PM
Great.
No Problem glad it was helpful
***Mark Correct or Helpful if it helps.***
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎07-30-2024 08:51 AM
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.