Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I'm running into an issue with how my data is displayed in a table, which may need be solved on the data prep side rather than in the app development, but I'm open to suggestions either way.
A simplified version of my data looks like:
Load * Inline [
ID, Letter
1, A
1, B
1, C
1, D
];
In the table, I have the letter column concatenated (=concat(distinct [Letter], ', ')) using a comma so that it appears like:
ID | Letter
1 A, B, C, D
However, when a letter selection is made, the remaining letters disappear since the underlying data is filtered. Would it be possible to have the letters be preserved under filters? My first thought was to make a table that each of the letters map to that contain all letters so the display is static under selection (other than rows being removed if not part of the selection).
Thank you very much for your help!
Hi, try this.
=Concat({1} DISTINCT [Letter], ', ')
That worked perfectly! Thank you so much BrunPierre!