Forum Discussion

sdhn's avatar
sdhn
Responsive Resident
4 years ago
Solved

Condition & Counts

Hi All,   Here are the two columns from my source table "Table A"       1) If Column F = Not Assessed or Blank = Not Assessed If Column F = Yes or No = Assessed   2) I need total co...
Help appreciated
VahidDM's avatar
VahidDM
Super User
4 years ago

sdhn 

 

Try this:

Column =
SWITCH(
    TRUE(),
    [Column F] = "NOT ASSESSED"
        || [Column F] = BLANK(), "NOT ASSESSED",
    [Column F] = "YES"
        || [Column F] = "NO", "ASSESSED"
)

 

Output:

 

 

 

 

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
LinkedIn: www.linkedin.com/in/vahid-dm/

 

 

sdhn's avatar
sdhn
Responsive Resident
4 years ago

I need to dispaly in the graph.

Table is exsited.  Thanks