Hi - I've been trying multiple ways to have my table populate the data properly. In short, my table is counting the number of non-blank numerical or text values in the column.
Each column is broken down by a row that denotes the date associated with the value. Some days do not have any data in said columns thus it is populating blank values. Is there a way I can have the table populate a 0 if there is no data counted in that column for that date?
Right now my formula is simply X:X with aggregation set to Count. If I attempt to make the formula COUNT(X:X) , no data is populated in the table.