Forum Discussion
How to create merged column headers in Matrix visual?
Do those tables share the same structure? If they do, it would be better to combine them into a single table with an additional column to indicate the vehicle type. You can use the append feature in the query editor.
ERing In a matrix visual, whatever the column stores the value "Car/Truck/SUV" will be on the column, in the value section, you will use measures (actual/baseline/data) and the rows will have the location column.
My data for each category (cars, trucks, & suv's) are in different tables. So I have a "cars" table, a "trucks" table, and an "suv" table.
I don't have a column that stores "car, truck, suv" values.
Do those tables share the same structure? If they do, it would be better to combine them into a single table with an additional column to indicate the vehicle type. You can use the append feature in the query editor.