Hello. I need assistance with a scenario. One of the bubbles contains an array of data. I need to analyse the array and extract specific data. From the laps data array, I need to extract data for each lap: average speed, total elevation gain, and average heart rate. This data should then be sent to a Telegram bot. The number of laps should change dynamically depending on their availability. To extract the data, I use Iterator and then transfer the data from it to Text aggregator. ChatGPT suggested a formula, but it cannot suggest how to make the text clean. What it suggests does not work. Who can help me figure out what the mistake is?
concat(
"Круг ",
ifempty(<Iterator[6]: Lap Index>; ifempty(<Iterator[6]: Split>; <Iterator[6]: Bundle order position>)),
" — темп ",
if(
greater(<Iterator[6]: Average Speed>; 0);
formatDate(
addSeconds(“1970-01-01T00:00:00Z”; round(div(1000; <Iterator[6]: Average Speed>); 0));
“m:ss”
);
“—”
),
" /км; набор ",
formatNumber(round(<Iterator[6]: Total Elevation Gain>; 0); 0),
" м; пульс “,
ifempty(formatNumber(round(<Iterator[6]: average_heartrate>; 0); 0); “—”),
" bpm”
)
