Forum Discussion

GON76's avatar
GON76
Icon for Helper III rankHelper III
1 year ago
Solved

Counting Blank Fields on a Column that's Counting Values

A little background:   I'm trying to count blank fields for a column which is displaying a count of values, the valued that I'm seeing on the card is (blank).   I'm working in a learning environm...
Need Help
  • AmiraBedh's avatar
    AmiraBedh
    1 year ago

    You are right ! I forgot the FILTER it should be like below :

    No Enrollments :=
CALCULATE(
    COUNTROWS(V_SECTIONCUSTOMFIELDS),
    FILTER(
        V_SECTIONCUSTOMFIELDS,
        ISBLANK(
            CALCULATE(COUNTROWS(V_ENROLLMENTS))
        )
    )
)
GON76's avatar
GON76
Icon for Helper III rankHelper III
1 year ago

Sorry, I gave the wrong table name... it's actually V_ENROLLMENTS and it captures all students who are enrolled within a courses via the STUDENTINDEX variable.  Here are a few screenshots.  FYI, I renamed V_ENROLLMENTS[STUDENTINDEX] to just "Enrollments" on my table visual.

Thanks so much for your help!

AmiraBedh's avatar
AmiraBedh
Icon for Super User rankSuper User
1 year ago

Try the following :

Sections With No Enrollments =
CALCULATE(
    COUNTROWS(V_SECTIONCUSTOMFIELDS),
    ISBLANK(CALCULATE(COUNTROWS(V_ENROLLMENTS)))
)
  • GON76's avatar
    GON76
    Icon for Helper III rankHelper III
    1 year ago

    That gave me an error:

     

    • AmiraBedh's avatar
      AmiraBedh
      Icon for Super User rankSuper User
      1 year ago

      You are right ! I forgot the FILTER it should be like below :

      No Enrollments :=
CALCULATE(
    COUNTROWS(V_SECTIONCUSTOMFIELDS),
    FILTER(
        V_SECTIONCUSTOMFIELDS,
        ISBLANK(
            CALCULATE(COUNTROWS(V_ENROLLMENTS))
        )
    )
)
      • GON76's avatar
        GON76
        Icon for Helper III rankHelper III
        1 year ago

        Getting closer!  Now instead of showing Blank the card is showing "1".  Out of curiosity, why did you decide to use "V_SECTIONCUSTOMFIELDS"?  This table houses the custom fields that we created in our learning management system.  They way I'm displaying my visual is to count the STUDENTINDEXs enrolled in each course or in LMS-speak, Section.  Thanks!