I have a derived table in the universe and I am building a info chart in design studio based on this.The query of derive table is something like below:-
select month(deploy date) as col1,col2,col3 from table1.
But there is no data for few months but the user wants to see the info chart with bar showing 0 for that month? How can I achieve this. Any ideas??