Hi, I have a table like this. BatchStudentA1A1B2B2C2C2C2I want to show a score card showing 'Sum of students across all distinct batches', i.e. 1 + 2 + 2 = 5. The normal sum function gives me 12. I want to sum only for distinct batches, i.e. A -> 1, ...

A noob query: I have four columns in my data, say, A, B, C, D. I want to count distinct non-null values in each column and display as a bar chart with custom X-labels. I can get the distinct counts for each column. How do I get custom labels, say, P,...