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 UserCreationDate on one side, and OrderDate on the other. 

 

How can I use Week field from calendar as the Axis Value in such case? How can UseRelationship be used?

 

Thank you!

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

     

2 Replies

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper 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.