Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have to combine all into one chart
You can do it with a new table as below:
tab_a:
load
Category
Category as New_Category
Resident now;
concatenate
load
Category,
'all' as New_Category
Resident now;
In the UI you can use New_Category field as filter/dimension.
I hope it helps.
May be this
Table:
LOAD Sales,
Month,
Year,
Category,
KPI,
Country,
brace
FROM
[..\..\Downloads\Tests.xlsx]
(ooxml, embedded labels, table is Sheet1);
Concatenate (Table)
LOAD Sales,
Month,
Year,
'All' as Category,
KPI,
Country,
brace
Resident Table;
or this
Table:
LOAD Sales,
Month,
Year,
Category,
KPI,
Country,
brace
FROM
[..\..\Downloads\Tests.xlsx]
(ooxml, embedded labels, table is Sheet1);
Concatenate (Table)
LOAD DISTINCT Sales,
Month,
Year,
'All' as Category,
KPI,
Country,
brace
Resident Table;
If you were to create this additional category then there would be no data for it, why do you want to create a third category instead of just selecting two categories simultaneously?
You can do it with a new table as below:
tab_a:
load
Category
Category as New_Category
Resident now;
concatenate
load
Category,
'all' as New_Category
Resident now;
In the UI you can use New_Category field as filter/dimension.
I hope it helps.