I am not sure if this is the correct Forum, but I will start here.
I am trying to do something that I thought would be easy, but has proven to trip me up. I am wanting to create a single score report using distinct count of a column in my table. However, the column contains blank and I want to count those as 1 distinct entry. From what I read, the best approach was to create a Function Field defined as follows: glidefunction:coalesce(column_name,"None"), where column_name is the name of the column I am attempting to perform the distinct count. I am able to define the Function Field, BUT when I look at the list of available fields to aggregate via Count Distinct, the newly defined Function Field does not appear. I have tried refreshing my browser, clearing cache, etc. Also, the newly defined Function Field does appear in the list of selectable columns if, for example, I want to add it to a List report.
Does anyone have ANY idea why the newly created Function Field (of type string, 255 max) does not appear as one of the available items when trying to aggregate via Count Distinct?
