What I’m trying to do
I wanna create a dataview for an Encounter/Add box, with multiple FLATTEN instructions:1.1) Results split into multiple columns (slice)
1.2) File name shortened (truncate)
The above is the main challenge. Further specs of this table I wish:
2.1) Showing ‘files’ and ‘days lived’ columns
It’s better if all this can be achieved with native dataview capabilities, rather than custom code.
Things I have tried
I’m a non coder who’s enjoyed a bit of dataview code manipulation. Achieving each of those specs separately has been possible for me with the help of forums, but I’ve failed at combining all of them. Illustration below
Expected result:
I’m able to use a multicolumn callout to get 2 tables instead of 1
Further questions
3.1) What does ‘GROUP BY true’ do?
My thanks to the helpful wizards in this community