Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

2 Datasets - 1 Date Slicer - Relationship needed?

I have 2 datasets in my report 1)ChurnSignupsByDate and 2)ChurnDetails.  Both datasets have a field call SVC_END_DATE.  'ChurnSignupsByDate' has a single record for each SVC_END_DATE 'Churn' has all...
Need Help
  • MFelix's avatar
    MFelix
    6 years ago

    Be aware that when making this type of relationship you must always use on your visualization the column of the one side to get your results, further more when working with dates as a best practice the use of a date table is better because of the continuous dates.

     

     

    Do you have a calendar table? 

MFelix's avatar
MFelix
Icon for Super User rankSuper User
6 years ago

Hi Anonymous,

 

If your common value is a date you need to relate both tables based on a calendar table and then make a relationship between that table and the other two. However depending on how your model is setup you may need to create some additional dimension table to relate the tables in order to show the correct results. 

 

Can you share a sample data and expected result?