Two tables: one shows me my sales by day by store the other shows me sales this week to date by store. I really need this all in one table. Will this be possible to merge the two?
You could do a SQL UNION in the looker view. You could do it at query time or create a PDT (materialized view).
SELECT user_id, sale_date, sales_total
FROM online_sales
UNION
SELECT user_id, sale_date, sales_total
FROM offline_sales
Then create your look on top of that data.
The Merged Results functionality should be able to help you with this.
Reply
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.