Forum Discussion
Resolver IHandle two Queries in the same Dashboard
You should create one or more new tables in your model containing the fields on which you want to slice. Each table should contain a column with unique values, that can be used to connect your original queries/tables. Like, if you have customer information in both tables, you will have a lot of duplicate data about these customers. Instead, create a separate customer data identified by customer number (in hope you have that, or something else that is unique - how else would you distinguish between customers?)
You can create these tables from your original queries by referencing them, keeping only the columns relevant to the new table, and remove duplicate rows (be sure to select all columns before adding that step).
Resolver IIIYou should create one or more new tables in your model containing the fields on which you want to slice. Each table should contain a column with unique values, that can be used to connect your original queries/tables. Like, if you have customer information in both tables, you will have a lot of duplicate data about these customers. Instead, create a separate customer data identified by customer number (in hope you have that, or something else that is unique - how else would you distinguish between customers?)
You can create these tables from your original queries by referencing them, keeping only the columns relevant to the new table, and remove duplicate rows (be sure to select all columns before adding that step).