Hello, on google play i stumbled upon this concept and i would like to recreate such an event timeline in KWGT
So far I ended up with this:
But im struggling with some elements, like time for exaple, those 1,2,3,4 etc is supposed to be a full hour, but since the widget returns hours from 0-9 as a single digit i came up with double if formula.
$if((df(hh)+1>23),0,if((df(hh)+1<10),0,CLEAR))$$if((df(hh)+1>23),((df(hh)+1)-24),df(hh)+1)$
But im not sure what to put in CLEAR to not be shown at all since with this extra 0 hours 11 would look like 011 etc. If somebody would like to look, ive uploaded my export, this formula can be found in second text extry in layer folder. I would be grateful for the help.