Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a table that contains several dates, the fields are named CreatedDate, UpdatedDate and ClosedDate.
I have a chart that uses one of these dates as a measuring point for a graph with an expression like this: Count(If (CreatedDate>CalendarDate, Id, Null()))
I have created an inputbox with a dropdown containing the names of the three date-fields above and what I want is to be able to choose in the inputbox which date to be used in the expression. Is this possible? If so, how?
Solved it!
I created a inputbox connected to a variable, vDateConf, and with a dropdown with three set values: CreatedDate;UpdatedDate;ClosedDate
Then in my expression I did: Count(If ([$(vDateConf)] > CalendarDate, Id, Null()))
Now when I select a different field name in the dropdown the chart containing the expression changes accordingly.
Solved it!
I created a inputbox connected to a variable, vDateConf, and with a dropdown with three set values: CreatedDate;UpdatedDate;ClosedDate
Then in my expression I did: Count(If ([$(vDateConf)] > CalendarDate, Id, Null()))
Now when I select a different field name in the dropdown the chart containing the expression changes accordingly.