Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Add a measure to Column in Matrix visual

I have a measure that I want to displya as columns in Matrix visual. I am not able to place the meaure in columns section . My measure is: 

 

NewAgeCategory = IF(AND([DaysDifference]>=0,[DaysDifference]<=15),"0D to 15D",IF(AND([DaysDifference]>=16,[DaysDifference]<=30),"16D to 30D",IF(AND([DaysDifference]>=31,[DaysDifference]<=45),"31D to 45D","46D And More" )))
 
 
 

Need Help
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    7 years ago

    Anonymous - If you want the measure to show up as column headers, you could create one measure for each category, and then include all of the measures in the Matrix (or Table).

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Anonymous - 

    Instead of creating a Measure, create a Calculated Column.

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      thank you Anonymous  for your reply. The reason I chose measure over calculated column is that I have a date filter based on which I will calculate days difference between (max date of the date filter ) and Claim Receive Date.

      I do not think calculated columns supports that do they?

       

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago

        Anonymous - If you want the measure to show up as column headers, you could create one measure for each category, and then include all of the measures in the Matrix (or Table).