I have a Klip where I calculate the average duration between date and time for different types of events. As the screenshot shows, I have start and end dates on columns B and C, and a label that will give me which section the duration refers to. In my Klip, I then show the average duration for each section from 1 to 4. When I ran the calculation for the first time, the label came back with the desired value for all 4 sections. However, after a while, as the data gets refreshed, the label becomes blank, and does not show the value anymore. I have previously fixed this issue by removing the label and readding it with the exact same formula, and if I hit evaluate, then the value gets calculated correctly, but the label is still blank. What could have gone wrong? Thanks!
As you can see above, the value for Section 1 is shown, and the value for Section 2 is blank. The two labels work exactly the same - apart from selecting the right label for the section. Can you please recommend a fix?