Skip to main content
In dynamic tables with a dropdown list, the column's title doesn't update to the changed dimension unless you type <%=YourDimension%> in the dimension's name too. However, it returns the PQL statement defined for the variable instead of 'readable' text?

You need to use two different variables.

e.g <%=YourDimension%> and <%=YourDimension_Text%>

 

When clicking on the dropdown list you must add both variables. The <%=YourDimension%> containing the PQL statement and the <%=YourDimension_Text%> containing the description you want to show in the Column title.

 

Then you need to add <%=YourDimension_Text%> to the column title description.

 

BR

Dennis

You need to use two different variables.

e.g <%=YourDimension%> and <%=YourDimension_Text%>

 

When clicking on the dropdown list you must add both variables. The <%=YourDimension%> containing the PQL statement and the <%=YourDimension_Text%> containing the description you want to show in the Column title.

 

Then you need to add <%=YourDimension_Text%> to the column title description.

 

BR

Dennis

Indeed, it is a standard trick. I use it so often I am about to ask Celonis for a feature to simplify that....

 

great workaround.

Reply


Community Code of Conduct