Attaining future leads in current month

Reply
Green Belt

Attaining future leads in current month

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?

 

Thanks.

Major Brown Belt

Re: Attaining future leads in current month

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.

Domo Arigato!

**Say 'Thanks' by clicking the thumbs up in the post that helped you.
**Please mark the post that solves your problem as 'Accepted Solution'
Green Belt

Re: Attaining future leads in current month

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?

Moderator

Re: Attaining future leads in current month

@Godzilla, could you help czmudzinski with their follow-up question? 

Announcements
Check out these great solution videos! The new iSolveditWithDomoboard is live, share yours and earn higher rankings in Dojo click here!