Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
If I have an "end of life date" column and I want to count Ids where the end of life date is within 2 weeks of today's date but not yet passed, what would the expression look like?
hi
it should be something like this :
count (if(today() - [end of life]<14 and today()>=[end of life],id))
hi
it should be something like this :
count (if(today() - [end of life]<14 and today()>=[end of life],id))
Thanks Lironbaram! I'll give that a try!
Thanks Lironbaram,
What if I want to create a Pie or bar chart hat divides the data into the buckets? What would the expression look like?
1 bucket for past date
1 bucket for 12 months until date
I bucket for 24 months until date.