Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

USERELATIONSHIP to create shared Calendar Axis

Hi,   I have 3 tables : Orders, Users and Calendar. Tables are related as below.  I need to create a barchart that will reflect weekly #Orders and #Users. Calendar is connected to UserCreati...
Need Help
  • amitchandak's avatar
    amitchandak
    5 years ago

    Anonymous , Make the join between user and date inactive and activate only when you need a report on the user table only. if needed use crossjoin to remove relationship .

    Keep date and order activated. Ideally, you should one to Many between user and orders

    How to user refer : https://www.youtube.com/watch?v=e6Y-l_JtCq4

     

amitchandak's avatar
amitchandak
Super User
5 years ago

Anonymous , Make the join between user and date inactive and activate only when you need a report on the user table only. if needed use crossjoin to remove relationship .

Keep date and order activated. Ideally, you should one to Many between user and orders

How to user refer : https://www.youtube.com/watch?v=e6Y-l_JtCq4

 

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Thanks amitchandak . With a bit of work around it worked.