We’re using datepickers that are linked to a variable <%=date%> , which at the same time is being defined by different formulas.
When looking at the title for the date picker, we have chose the text related to the variable <%=date%>
The problem is that when the variable is being defined by a formula, and not a field in a table.
this is also the case when we have graphs associated to the dates, in this case, the whole formula is displayed when the users “hover” over the graph…
we have tried to save the formula as a KPI, at least just to have the KPI name displayed, but in this case the variable will not be set, and the date picker will not work.
Is there any way to avoid showing the whole formula as the title for these cases?
Thank you for your help!