LOAD RecNo() as Records,
SubStringCount(lower(trim(Sprint)),'=ybs') as cnt_ybs
(ooxml, embedded labels, table is Sheet2);
// Get the max count of "YBS" words in Sprint field to loop
LOAD max(cnt_ybs) as max_cnt_ybs;
LOAD FieldValue('cnt_ybs',RecNo()) as cnt_ybs
let vMax_cnt_ybs = Peek('max_cnt_ybs',0,'Max_cnt');
DROP Table Max_cnt;
concat('YBS '&YBS_Sprint,',') as YBS_Sprint
Group by Records;
TextBetween(lower(trim(Sprint)),'=ybs',',',IterNo()) as YBS_Sprint
One more doubt, want to create bar chart with dimension is sprints field nd measure is count of user stories.
But x axis should show current sprints..suppose now 12th sprint is active so chart should show only 12th sprint data across measure.in upcoming days sprint becomes to 13 so that time chart should show 13th sprint data alone.