Hi,
In my data there are 2 numeric columns, each with some measurement. For example for several different tables I have a measurement of the length and width of the table.
I want to put the width of the table on the X axis and the width on the Y axis and then select a specific table (by ID) and highlight it without aggregating the other tables.
I tried to create a Table_id parameter and a calculated field ifelse(${Table_id}=Table_id,“selected”,“others”) and put the variable as Group/Color but then all the values of the tables that are not selected are summed up (both on the X axis and the Y axis).
How can I solve it?
Thanks!