How to show the day wise sales for all days even when there is no sale on a particular day

[Anonymous]

I'am trying to show the trend of sales for distributors

My intention is to capture the distributors who have made the least sales. For this I need the weekly or monthly trend of sales for them.

For eg: Distributor A has made sales only on 2 days in the last week of 7 days. When I see the trend of the last week for this customer I'am not able to see the dates when there was no sale made. Whereas I would like to see all dates for the last week,irrespective of the sales. The user should be very clear about the dates on which no sales were made.

How can I capture this?

[sharath_babu90]

I have the same query as well. Could someone plz help me out?

[Anonymous]

@Anonymous,

Do you  have a calendar table? Create relationship between your calendar table and your original table using date field, then drag date field of calendar table to x-axis of your chart.

Regards,
Lydia