I have document table (Doc) which does allow the same doc_name to be used as a document can have an updated revision. I want to create a slice of this table to show only the duplicate doc_names so the user can check that past revisions have been marked as Superceded.
Any ideas?
You could use MAXROW expression to find your latest version from that same Doc_Name.
Perhaps, instead of a slice, an action of type App: go to another view within this app, with a target expression using LINKTOFILTEREDVIEW(), a prominence of Display inline for the doc_name column, shown only if multiple copies with the same name exist?
For this same purpose I've used @Steve avoid duplicates expression but reversed:
to avoid duplicates the expression is:
ISBLANK(
FILTER(
"Table",
([_THIS] = [Column])
)
- LIST([_THISROW])
)
So the Slice expression to show ONLY DUPLICATES would be:
ISNOTBLANK(
FILTER(
"Table",
([Column] = [_THISROW].[Column])
)
- LIST([_THISROW])
)
User | Count |
---|---|
36 | |
33 | |
27 | |
23 | |
18 |