Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I want to make some kind of favorite table..
there is an original table chart that has all values.
table_A:
LOAD * INLINE [
all
a,
b,
c,
d,
e,
f,
g
];
and another table chart that has only favorite values.(I load this table with hard coding)
table_Favorite:
LOAD * INLINE [
favorite
a,
d,
g
];
and made 2 table chart for those two tables and one bar chart to show information about selected alphabet on the sheet.
and apply selection to the bar chart from both [table_A] and [table_Favorite].(only one selection is available from one of those tables, with table_As' field name as a selection field)
I put below expression inside Add-ons>Data handlig>Calculation condition.
GetSelectedCount([all])=1
But don't know which data to put in the table chart for favorite list(values that only exist in table_Favorite).
Load like below
table_A:
LOAD * INLINE [
all,Favorite
a,a
b,
c,
d,d
e,
f,
g,g
];
If you maintaining a list separately then , load your Table_A and then Left Join Hard coded list and keep a single table
table_A:
LOAD * INLINE [
all
a
b,
c,
d
e,
f,
g
];
Left Join(table_A)
Fav:
Load * inline [
all,Fav
a,a
d,d
g,g
];
If I merge, can I make table of 'all' that has 'Fav' value?