I am currently testing a functionality for my dashboard. The goal is to let the user choose columns that the user wants to see in a table. A very basic demand but still I struggle.
I show available columns with a Filter Pane with $Field as dimension.
And then I have a table where I use the Show condition with this formula < if(GetFieldSelections($Field) like '*Car*',1,0) >.
Now I have a lot of columns and want to make the part < like '*Car*' > not static but dynamic.
Any ideas how to achieve that? Looking forward to your ideas 🙂
but this is show column if condition for a already known dimension... what difference would it make if you change the condition from static car to something dynamic?
You want to use a single formula for all three dimensions? But this same formula will be repeated three times for each of the three expressions, right? I don't think you can create a single formula which can be copy pasted for each expression... something will need to tell it that if it is cost or car or type dimension
I really thought it would be possible to have one formula for all columns. I thought about using some kind of identifier for the column "ColumnNo()" based on the "RowNo()" the same field has in the "$Field" Table. But I dont know if that approach works.
You might be able to employ GetObjectField , but even with that, you will need to specify which field you want to look into? like for first dimension it would be
$(='[' & GetObjectField(0) & ']')
and for second dimension it would be
$(='[' & GetObjectField(1) & ']')
So, even with this solution you cannot just blindly copy paste the expression across your dimensions.
