Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Link Calendar

Hi all,   I want to link 2 calendars to the same filter. I have a table invoice. Containing all the invoices and it has an invoice date. It also contains a shipment date And it contains an amo...
  • gooranga1's avatar
    gooranga1
    8 years ago

    Hi Anonymous,

     

    I would generate 2 tables one called Invoice the other called shipment.  I would just copy your Invoice table that you have and call ti shipments. Then join those 2 tables to 1 date dimension on invoice date and shipment date respectively.

     

    You can then generate the graph you want useing the date dimension.

     

     

  • jthomson's avatar
    jthomson
    8 years ago

    You can connect multiple date fields to a date table, you just need to make sure that you use USERELATIONSHIP in the measures etc that involve whichever date field(s) are inactive

gooranga1's avatar
gooranga1
Icon for Power Participant rankPower Participant
8 years ago

Hi Anonymous,

 

I would generate 2 tables one called Invoice the other called shipment.  I would just copy your Invoice table that you have and call ti shipments. Then join those 2 tables to 1 date dimension on invoice date and shipment date respectively.

 

You can then generate the graph you want useing the date dimension.