Toggle a filter on a table to show all records or just the first one of a group

[Russ]

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!

[andoryuu]

Can you post your app (or an obfuscated version) so that we can see what you mean by toggling the table? Or at least some screenshots? Sounds like a job for a pivot table or the addition of filtering panes on top, but you may be describing a more complicated use case than that. This is a little light on the details so it's hard to know until there is some more descriptive information here.

[Russ]

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!