Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Distinct count -sum

Hello

 

i have couple of questions.

 

can we group column based on measure  show in pic.

can column labels change dynamically when month changes in last 3 months for measure a ^& measure ?B

3 Replies

  • edhans's avatar
    edhans
    Community Champion

    No. Column lables cannot dynamically change. You can have dynamic text in a Card using normal text formulas, but column and row labels are based on the database you have loaded. You can conditionally format the data using measures to determine if it was changed in last 3 months, but that changes the format of the values, not the column info.

  • camargos88's avatar
    camargos88
    Community Champion

     Anonymous ,

     

    Have you thought about using matrix instead of table ?

    You can use a column value as header, it will give you a dinamic header based on your column values.

     

    Ricardo

  • Anonymous's avatar
    Anonymous
    Not applicable

    Anonymous 

    It is recommended to create measures based on the existing columns to make visuals dynamically change.

    Best regards
    Paul Zheng