Skip to main content
Announcements
Customer Spotlight: Discover what’s possible with embedded analytics Oct. 16 at 10:00 AM ET: REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Two similar fields with different selections for one single chart

//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

10 Replies
swuehl
MVP
MVP

Open the background color attribute of the first expression, it looks like

=If(Count({AS} Customer), Lightgreen(), LightBlue() )