Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Everyone!
Is it possible to have a column data profiling on one chart? What I am trying to do is give a summary on the columns data showing :
1- Count of DISTINCT values
2- Count of Duplicated Values
3- Count of NULL values
For example, say I have a column "DateofBirth", I'd like to have a bar chart (or pie chart) showing the above measures. Now I have applied the above measures but when it comes to selecting a dimension (since I have to select) it messes what I am trying to accomplish
Thanks & your feedback is really appreciated.
Having all values of a dimension the count of duplicates can be:
Sum(Aggr(Count(AGE),AGE))
But I don't get how the nulls it should be counted having dimension values, or why count distinct.
Or this attachment?
There are many options if I start to imagine what you want, and english is not my native language... a sample, or at least a screenshot of what behaviour you search will be nice.