-
1. Re: Stacking dimensions
Shinichiro MurakamiDec 16, 2016 9:48 PM (in response to Francois Houde)
Hi Francois
Two different approaches.
Which is better ? depends on your preference, but considering the risk of triple counts, Dashboard approach should be easier and simpler .
1. Dashboard
Create three different worksheets (Blue in the example), and merge them on the dashboard.
Table is just straight forward.
2. Union (only available on 9.3 or newer version) = Red worksheet
This triples data set and pick up data only for particular category from respective data source.
This means there is a risk of triple countiing in some cases.
Create Union and create two calculated fields based on table name.
[Category]
case [Table Name]
when "Clipboard_20161216T181903.txt" then [Prod.]
when "Clipboard_20161216T181903.txt1" then [Type]
when "Clipboard_20161216T181903.txt2" then [Size]
end
[Top Category]
case [Table Name]
when "Clipboard_20161216T181903.txt" then "Prod"
when "Clipboard_20161216T181903.txt1" then "Type"
when "Clipboard_20161216T181903.txt2" then "Size"
end
Thanks,
Shin
-
Union_Dashboard_SM_9.3.twbx 22.8 KB
-