Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
//topic edited - see fourth post
Hello everyone,
I have two listboxes with identical fields. The first field is the original imported coloumn out of the excel file. The second one is defined in the loadscript as:
LOAD employee as employee2
FROM
excelfile.xlsx
(ooxml, embedded labels, table is ALL);
In the first listbox you can select the employee that you want to compare to the others. Only one selection is possible and the field is "employee2".
In the second listbox one can select multiple employees that are in the reference group. The field is the original employee coloum.
If I now select "employee" as the dimension of the scatter table, everything is well illustrated except the value selected in my first listbox.
Same vice versa... only the employee is visible but no longer the reference group.
I have tried to use both fields as dimensions, but only the second listbox is illustrated then or all points are named equally.
All your support is much appreciated! Please let me know if you need further details.
Regards
Open the background color attribute of the first expression, it looks like
=If(Count({AS} Customer), Lightgreen(), LightBlue() )