Is there a way to select a calculated dimension value by clicking ? I have a staright table which have calculated dimensions with an If statement , and user wants to filter data by selecting a value in the Table , but this is not happening.
If I use the dimension out of table and use in a list box , that can be filtered . I see there is searchable option where they can type the exact value they want and then click enter to filter data ...but other than this option , can we do it by clicking ?
You should be able to make selections in a straight table, even on a calculated dimension.
Can you upload a small sample that demonstrate your issue?
Please note that you can only make selection in fields in your data model, so when clicking on a calculated dimension, you are actually selecting values in the fields that are involved in the calculated dimension.
ok one of my expression is maxstring(Date) ... and i am selecting a date with multiple records but only one record is selected , the one on which i am clicking.
ok i moved one of my calculated dimension into script and brought that column as it is into table as dimension and now selection works , but maxstring(date) is actually an expression .. can selecting a value from expression filter the data?
if i move maxstring(date) to dimension i get error in calculated dimension message.
