
Im fairly new to salesforce, so I apologise if this is a duplciate question. Ive been requested by our MD to set up some reports that show day by day breakdown of closed won sales. This is going to be put into a dashboard with other reports and used as on overview for weekly meetings.
I have managed to set up a report that shows the amount won when the 'stage change' is set to TRUE and when the to 'stage change' equals 'closed won' (Im using the report template 'Oppourtunity History')
The problem im having is, if no one makes a sale on a tuesday, the report does not pull in tuesday at all. I need the report to show all days even if a sale was not made. For Example;
What it currently shows (My report displays dates but this is just for reference);
Mon 1
Wed 3
Thurs 4
Fri 5
I need it to look like;
Mon 1
Tues 0
Wed 3
Thurs 4
Fri 5
Any help with this would be greatly appreciated,
1 件の回答
Since reports are based on the records in the report, if there is no record with a specific value, that value "doesn't exist" from the report's point of view.
If the report time span is wide enough to include a week where Tuesday has a value, you'll see a 0 in weeks where there is no record, but if its for a single week, the report doesn't even know about Tuesday.
The only other way around this is to make sure you have at least 1 record with each 'value' you need in the report. For Opportunities, you can create one with 0.00 dollars and 'Omitted' so it doesn't show up in forecasting and pipelines, but your 'count' will be off by 1. If you created one for each day of the week, then your days would be accurate relative to each other, but each day would be +1 from actual.