NIKKI Member

Comments

  • Thank you GrantSmith. CASE WHEN COUNT(CASE WHEN `Event Type` IN ('Hearing', 'Vision', 'ASQ3') THEN `ChildPlusID` END) = COUNT( CASE WHEN `Event Type` IN ('Hearing', 'Vision', 'ASQ3') This part is giving syntax error
    in Beastformula Comment by NIKKI May 2023
  • COUNT(DISTINCT (CASE WHEN(Enrolled/Dropped in ('enrolled')) THEN ChildPlus ID END)) I am having trouble with just the *enrolled beast mode column*
    in Table Chart and data validation Comment by NIKKI April 2023
  • Thank you, I was able to figure the issue.
    in Beast mode formula Comment by NIKKI April 2023
  • Thank you @MichelleH
    in Charts/Graph by Comment by NIKKI April 2023
  • this is what the raw data looks like. The first column is the indicator text and the 2nd column is the result with categories. this is what the output looks like
    in beastmode Comment by NIKKI April 2023
  • Yes, I even use wildcard, LIKE %
    in beastmode Comment by NIKKI April 2023
  • What I plan on having is the percentange of non-compliant category in result column by the distinct text in indicator text column
    in beastmode Comment by NIKKI April 2023
  • Thank you Michelle, I tried this COUNT(CASE WHEN Result = 'Non-Compliant-Urgent' THEN IndicatorText END) / COUNT(IndicatorText). but I am still getting zero's populating on my tabel
    in beastmode Comment by NIKKI April 2023
Default Avatar