Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I need to make a difference between 2 dates fields "StartDate" and "EndDate" but the formula "EndDate - StartDate" doesn't work.
I need also to group my result, the result of the difference will be between 0 and 2000 and i would like an easy to read bar chart. For exemple an absciss with [0-30] [30-60] [60-90] days .... Is it possible to do that ?
Thank you !
EndDate - StartDate should work (assuming they're both dates).
You can use the Class() function or nested if() statements to generate groupings.
thank you I've calculated the difference of dates
But but for value groups I've managed to group by value, for example '0-50' '50-100' and '100+' with nested if
However, I'd like to have a real hierarchy, for example I click on '0-50' and I get a filter on field values between 0 and 50. Is this possible?
up