I have an issue that I can't seem to wrap my brain around. I have a Table box with an input field "RankField" against another column "CriteriaField." I need to find a way to get a distinct overall count of the items entered into the "Rank" input field, however when I do a Count(Distinct(RankField)) it gives me a count of the number of distinct entries in the "CriteriaField."
CriteriaField RankField
Fast 1
Cheap 2
Light 1
Durable 3
Small 4
My count(distinct(RankField) total shows up as 5, not 4 as I would expect. I have tried playing with the aggr() function but I cannot seem to get what I need. Help please!!!
Unfortunately, do to specific network limitations, I cannot export the application, though I can manually type specific segments of the script to assist.
