Hi, I’m hoping that there is a way to create a bulleted list of something that can be done easily in SQL:
select name, max(delay_days) max_delay_days from view group by name having max_delay_days > 14 order by name
And have this rendered as a bulleted list.
The raw data is here:
(Edited: Jun 7, 2020)
Project Change Log
|1||Foo||5/5/2020 1:00 PM||6/7/2020 7:53:08 AM||24|
|2||Bar||5/19/2020 1:00 PM||6/6/2020 1:04:25 PM||14|
|3||Biz||5/29/2020 1:00 PM||6/6/2020 1:04:27 PM||6|
|5||Bar||5/19/2020 1:00 PM||6/7/2020 7:52:20 PM||15|
This is what I can do today but I’m hoping there is a more powerful way to use table views and lists:
=[Project Change Log].Sort(true,[Project Change Log].Name).FormulaMap(Concatenate(Name, " delayed by ", DelayInDays, " days")).BulletedList()
* Bar delayed by 14 days * Bar delayed by 15 days * Biz delayed by 6 days * Foo delayed by 24 days
You see Bar appears twice here with 14 and 15 days. I wanted to be able to show only the
max for each
name which would’ve been Bar: 15.