Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Matrix like visual - Advise on visuals

Hey ALL, I have a table with 3 (will be more) calculated columns. Each column gives me values of -1,0,1 according to some dates logic. I use these values to filter a measure that is shown on cards,...
Need Help
adityavighne's avatar
adityavighne
Icon for Continued Contributor rankContinued Contributor
7 years ago

Anonymous 

you can use a table for this with filtered columns.

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi adityavighne 

Can you elaborate?
Not sure how to achieve this.

Cheers!
A

  • adityavighne's avatar
    adityavighne
    Icon for Continued Contributor rankContinued Contributor
    7 years ago

     

    Add a column in the table and create filtered measure as per the category.

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Hey,

      Thanx for the advise. I dont see how it helps me, though.

      1. I did not want to creatre more/other measures.

      2. The result will come in a row, while I want it in a column.

      Unless I am missing something?!

       

      I would like to create a table with 1 measure and in each row/column (aka cell) I will use different filters.

      For example:

      Column 1

      51 --> Measure X1 with filter with columnA (value 1) applied.

      434 --> Measure X1 with filter with columnA (value 2) applied.

      742 --> Measure X1 with filter with columnA (value 3) applied.

      Column 2

      129 --> Measure X1 with filter with columnB (value 1) applied.

      259 --> Measure X1 with filter with columnB (value 2) applied.

      etc. etc.


      Cheers!
      A