Forum Discussion
Solved
Show all scale division marks in graph
Hi, everyone! I am trying to show average count of ‘orders’ through ‘hours’ axis, which has all 24 hours at one graph. However, some of the ‘hours’ is not exist, so, graph does not show all 24 hours...
yes it can be achieved, you need following:
- an hour dimension table with field hour with 24 records for each hour and connect to your data table on hour
- drop hour from your hour dimension on x axixs and with down arrow on next to hour field on x axis, choose show with no data.
i guess this will do it.
parry2k
Super User
Super Useryes it can be achieved, you need following:
- an hour dimension table with field hour with 24 records for each hour and connect to your data table on hour
- drop hour from your hour dimension on x axixs and with down arrow on next to hour field on x axis, choose show with no data.
i guess this will do it.
Thanks a lot! Did not think about making key table, will use further
