Forum Discussion

Sam-L's avatar
Sam-L
Frequent Visitor
5 years ago
Solved

Create a slicer based on multiple fields of data

Hello,   I'm currently working with some medical intervention data and I'm looking to create a new slicer filter which allows the selection of a medical intervention.   Currently, my data has a d...
Need Help
Show and Tell
Tips and Tricks
  • Sam-L's avatar
    Sam-L
    5 years ago

    Thanks for your help v-jingzhang amitchandak. I have found a different way around this by creating a conditional column based on if a time exists or not. If a time exists, it stores 'yes', if it's null, it stores 'no'. I've done this for each of my interventions and created a card for each intervention.

     

v-jingzhang's avatar
v-jingzhang
Community Support
5 years ago

Hi Sam-L 

 

You could use below codes to create calculated columns. Is this what you want to get?

Column = [A_Time]&"|"&[B_Time]&"|"&[C_Time]
Column 2 = IF(ISBLANK([A_Time]),"No","Yes")&"|"&IF(ISBLANK([B_Time]),"No","Yes")&"|"&IF(ISBLANK([C_Time]),"No","Yes")
Column 3 = IF(ISBLANK([A_Time]),"No",[A_Time])&"|"&IF(ISBLANK([B_Time]),"No",[B_Time])&"|"&IF(ISBLANK([C_Time]),"No",[C_Time])

Regards,
Community Support Team _ Jing
If this post helps, please Accept it as the solution to help other members find it.