Forum Discussion

Leif_Eriks0n's avatar
Leif_Eriks0n
Regular Visitor
3 years ago
Solved

Trouble Linking Tables for Matrix

I am trying to link two separate tables for one matrix.   Table 1 has the following columns: Order Date, Time Interval (15 minutes), Venue Name, Service Type, Payment Method, Sales Amount Table 2 ...
Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi Leif_Eriks0n ,

     

    I suggest you to create dim tables like DimVenue and DimDate, then create relationships between them and Table1/Table2.

    Result in my sample is as below.

    By Default：

    In January:

    In February:

     

    Best Regards,
    Rico Zhou

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Leif_Eriks0n's avatar
Leif_Eriks0n
Regular Visitor
3 years ago

Thanks, this worked.  I had to create a new/duplicate table for everything I wanted to filter on, including Payment Method, Service Type, and Time Interval.