hello. I have a question but, I am not good at English. So the sentence can be awkward because you are using a translator. I want to compare two periods in one graph . A parameter was used so that the dashboard viewer could freely set the period. At first, I tried to express it as a simple line gra…

Hello @orangchan ! To achieve the above you could do the following: sum(ifelse({date} >= 'start-target - date-range1' AND {date} <= 'end-target - date-range1', {value}, NULL)) - sum(ifelse({date} >= 'start-target - date-range2' AND {date} <= 'end-target - date-range2', {value}, NULL))

How can loop in calculated field?

Question & Answer

Max August 17, 2023, 12:50pm 2

please take a look at this article. It should have what you are looking for.