I want to know if anybody has an idea of how to access column of a calculated column. If it is part of the loaded table, its not an issue. I tried accessing it using various syntax's given online. Can i use the label of the calculated column. Example, if the calculated column label is "total", how to access it. Thank you in advance!!
Hi. Thanks for your reply. There is an expression/new column (say Column1) in my chart object like [ if(x>0 and y<0 and z=1, 1,0). So i have a new column with values of 1 or 0 based on condition. Now outside this chart, i need a method to filter data, for example some way i can filter and show only those data for which i have assigned 1 in the chart. This should be done , if a user selects a yes/no in a dropdown for filter Column1 data . If he selects yes, i need to display only those values in column1 that have "1" in them
Can i reference the value in a calculated column within that table. If so, how ? How do i access the values of the calculated column in each row. Can we access it using the column name(calculated column name)?
Why cant you simply clone the chart and make it as a Straight table with only the column you want to filter . Hide all other columns you don't want to display something like the below and use this calculation in a variable to refer it in other charts
I placed the calculation in a calculated list box and I am facing an issue in that. I am placing two conditions with an YES/NO. The data is filtered correctly according to my selection. But the selection i make (ie. YES/NO) is disappearing when i click it( it does not stay highlighted). The user will not know if YES/ NO is selected. It is working like a trigger. Once I click yes, data s filtered but the yes does not stay highlighted. Why does this happen?