Forum Discussion
RuthMerchán
Helper I
3 years agoHow to show all dates although data does not exist taking into account a range of dates?
I eneryone! This report is formed by 3 tables (date1 (dimension table of date 1), fact_table and date2 (an independent dimension table of dates)). So that it is shown a table with the last 20 da...
RuthMerchán
Helper I
3 years agoHi everyone!
To get this functionality, I had to create a view with a cross join of the table having available all dates for each route and company and make a coalesce, if the value exists then value, else 0. The problem now is the performance, but it is a question of trying to improve the query to make it more efficient.
Thank you all for your support.