Forum Discussion
saracaballero
7 years agoFrequent Visitor
Relation between two columns is not woking
Dear all, I am currently developing a pipeline for the sales team. I want to analyse number of leads, opportunities and sales orders for a point in time. Leads and opportunities are in the sa...
Anonymous
7 years agoNot applicable
I will have a look but... your thinking is completely wrong. The very first thing to do when building a model is create a proper Date table. This is THE VERY FIRST thing to do, not the last one.
Best
Darek
Best
Darek
saracaballero
7 years agoFrequent Visitor
Hi Anonymous ,
Ok, thanks!
The thing is I want to create a calendar and connect all the dates that I am interested in filtering. However, for crm_lead, I want to columns of dates to be attached to the same Date table, which I think it is not possible. For this reason, I am waiting to see if this works to take the next step.
I am a Junior who just graduated, and this is the first time I am working with these types of programs, so I apologise if my procedure is not the correct one, because I am not an expert. Nevertheless, I am very willing to learn.
Best regards,
Sara.