Joined: 03 Oct 2010
Location: United Kingdom
Online Status: Offline
Posts: 76
Topic: Graph with all dates in range Posted: 03 Mar 2017 at 1:55am
Hi
I wonder if somebody can help please. I have created a report, including a graph showing our sales order book for a chosen month. Dates across the Bottom (x axis) and quantity on the vertical (y axis). It works fine showing all the correct values. However I also need to see the dates on the graph with no orders - so we can see any gaps within the month - is this possible please?
Thanks for any help.
Ed
Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Posted: 03 Mar 2017 at 2:29am
you generally need a source for the missing dates. This is usually done via a Calendar or Dates table that you outer join your other source (Sales) to. Then point your graph to use the Calendar table date field rather than your Sales table date field.
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum
IP Logged
