Forum Discussion

Krcmajster's avatar
Krcmajster
Icon for Helper IV rankHelper IV
7 years ago
Solved

Dynamic column changing

I am not sure this is possible but better to ask.   So I have a column with clasiffication by size SQM:   Example: SQM Class <1000 1000-5000 5000-10000 >10000   Next to it I have a similar...
Need Help
  • tex628's avatar
    tex628
    7 years ago

    To do it you will need to change the datamodel. Instead of having SQM and SQFT in two seperate columns you would need to have the values in the same one:

    SizeClass
    < 1000SQM
    > 5000SQM
    < 10000SQFT
    > 20000SQM
    < 1000SQFT
    > 5000SQM
    < 10000SQFT
    > 20000SQFT


    With this you can create a slicer on the class column which should give you the result ur aiming for.

    Br,
    Johannes

tex628's avatar
tex628
Icon for Community Champion rankCommunity Champion
7 years ago

To do it you will need to change the datamodel. Instead of having SQM and SQFT in two seperate columns you would need to have the values in the same one:

SizeClass
< 1000SQM
> 5000SQM
< 10000SQFT
> 20000SQM
< 1000SQFT
> 5000SQM
< 10000SQFT
> 20000SQFT


With this you can create a slicer on the class column which should give you the result ur aiming for.

Br,
Johannes