Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Is it possible to build this table? (matrix/table with multiple dates)

Hi, I was wondering if anyone could advise me how to achieve the below.. or if it's even possible at all! I have 2 tables, a Sales table and a Payment table structured like the below.  ...
Need Help
Show and Tell
  • tackytechtom's avatar
    tackytechtom
    4 years ago

    Hi Anonymous ,

     

    Maybe something like this?

     

     

    You need two different date dimensions, one for payments and the other one for sales. After that you can drag the YearMonth attribute (or any other attribute that your date dimension has) of both of them into a matrix visual like this:

     

    Depending on your requirements, you can then play around with different totals and whether you would like to "show items without data" etc.

     

    /Tom
    https://www.tackytech.blog/
    https://www.instagram.com/tackytechtom/

     

     

     

tackytechtom's avatar
tackytechtom
Icon for Most Valuable Professional rankMost Valuable Professional
4 years ago

Hi Anonymous ,

 

Maybe something like this?

 

 

You need two different date dimensions, one for payments and the other one for sales. After that you can drag the YearMonth attribute (or any other attribute that your date dimension has) of both of them into a matrix visual like this:

 

Depending on your requirements, you can then play around with different totals and whether you would like to "show items without data" etc.

 

/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/