on 01-10-2018 10:52 PM
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??
Thanks
I can think of having a time dimension table in universe joined with transaction table. Hence you can get a continuous time axis from the time dimension table.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
24 | |
11 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.