Forum Discussion
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 on X-axe. I tried make ‘Continuous’ type of X-axe, but result is (screenshot 1). I am trying to catch (screenshot 2) with one addition, that I want see all 24 hours on scale division. Any solutions? Also, I am attaching screenshot 3 with dataset, may be that will help
Screen 1Screen 2Screen 3
Thank you,
Regards.
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.
2 Replies
- parry2k
Super User
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.
Thanks a lot! Did not think about making key table, will use further
