Forum Discussion

CoboleiroBr's avatar
CoboleiroBr
Icon for Helper I rankHelper I
9 years ago
Solved

Help using multiple date relationships

Hello guys!   I have a Calendar table and a Tickets Table.    The most important columns in Tickets Table are: - Ticket Number - Open Date - Response Date - Close Date   They are related wi...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    9 years ago

    In some cases, you will want to create another duplicate calendar table that you relate to your other date. The other option is to use the USERELATIONSHIP with measures but that may not work in your specific case.

Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
9 years ago

In some cases, you will want to create another duplicate calendar table that you relate to your other date. The other option is to use the USERELATIONSHIP with measures but that may not work in your specific case.

CoboleiroBr's avatar
CoboleiroBr
Icon for Helper I rankHelper I
9 years ago

Hi Greg_Deckler !

 

I'm already using USERELATIONSHIP in measures, but I didn't find a solution in this case besides creating other Calendar Table...

 

Thanks!

  • Greg_Deckler's avatar
    Greg_Deckler
    Icon for Community Champion rankCommunity Champion
    9 years ago

    Once I toyed around with creating a third calendar table related to my two calendar tables and using that as my central calendar table but I am pretty sure that ran into issues. I'd have t revisit.