Forum Discussion

Duong's avatar
Duong
New Member
2 years ago

Measure to rows header

Hi all,

I'm looking to create a matrix chart that displays the frequency of repeating orders.


I have created a measure below. This measure is used for the values in the matrix. I intend to use the column [No_repetitions]

of the 'table_groupby' for the rows header.

 

This is the results as I want.

 

 

However, I believe it's better to use [No_repetitions] as the measure. This way, when filtering by datetime, [No_repetitions] changes accordingly.

 

For example:
OR********* has repeated 5times in my list, so the result of No_repetitions shoulde be 5.

But when I filter datetime from 13-Feb to 20-Feb, the result of No_repetitions shoulde be 3.

Kindly tell me how I would be able to display the result of measure in form of rows header.

 

 

Need Help

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi Duong ,

     

     

    Sorry, I don't fully understand your needs yet. But I can make the following points clear:

    1.Measures cannot be placed in rows or columns of a matrix, only Values can.

    2.The row header refers to the field name in the matrix, right? And it cannot be returned in the row header as a measure.

    3.Your [No_repetitions] is a column, but because of the relationship between tables, it can also be filtered by filters, provided that there are no formulas in your matrix that ignore filters.

     

     

     

    Best Regards,

    Stephen Tao

     

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