Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a table that shows support cases logged against an incident (may be '1 to 1' or '1 to many'). Each case may be a different customer for each case and potentially the case may be logged on different dates.
Example
Case# | Incident# | Customer | Date |
1 | 1 | A | 1/1/19 |
2 | 1 | B | 1/1/19 |
3 | 1 | C | 1/2/19 |
4 | 2 | D | 2/2/19 |
5 | 2 | A | 2/2/19 |
6 | 3 | E | 3/1/19 |
7 | 3 | F | 3/1/19 |
8 | 4 | A | 4/1/19 |
If I toggle the table to show all cases, then it would show all 8 rows. If I toggle it for Incident view, I would only see 1 row per unique incident so would show 4 rows. This works fine when there are no other filters applied.
How do I apply the same toggle above, but just filtered on customer A?
Thanks!
Thanks Andoryuu!
Think I figured out a way around it:
- for charts, set analysis works fine
- for tables of data, just toggled visibility on the case field, so when shown can see all 8 rows, when hidden shows 4 rows. When a filter is applied just uses the natural functionality of the table chart to only show unique rows.
Works for now!
Thank you!