I have an issue where I need to graph issuedLeads by month.
My leads come in with a rawDate and issueDate
The problem is that the issueDate often falls into the next month or even the month after.
If a rawLead comes in January (having a rawDate of 1/1) and has an issueDate of February 28, I need it to still count as an issuedLead for January.
Is there a way that this can be accomplished?
What is your time grain at the top set to?
Cant you use your RawDate field? if not, you'll probably have to create another date field in your dataset that shows the data you want to cound the leads in.
The date grains I have available are rawDate and issuedDate.
If I use rawDate then I can only plot on dates when leads were created. If I use issueDate then I can only plot on dates where leads were issued. Should I set up some kind of universal date?