Forum Discussion
sean_cochran
Resolver I
Resolver IConditional Distinct Count of Values
In a working Deneb visual that displays survey data, I have a relatively flat dataset structured this way: When aggregating this data, I want a count of distinct values for "person" - ONLY ...
I found a simple solution. I used a "missing" op in my aggregation step to detect when null values were present in the data, and then subtracted 1 from the value of a "distinct" aggregation in a later calculate step whenever a null value was present in the series. Sample chart and dataset available at this link in the Vega editor.
Chart below:
lbendlin
Super User
Super UserCan you share the sample dataset?
sean_cochranResolver I
Resolver ILink to pbix file with sample dataset and chart here.