Use views to count distinct values of a field with multiple values
There is a user input field where multiple values can be inputted (comma separated).
Multiple users can write different results-
user 1 –> Field_colors: Blue,Green
user 2 –> Field_colors:Black, Blue, Grey
user 3–> Field_colors:Blue
Number of colors:- 4
I used aggregation-distinct count but I am not getting right results probably because the text field has multiple values.
This article was republished from its original source.
Pixeldust is a 20-year-old web development agency specializing in Drupal and WordPress and working with clients all over the country. With our best in class capabilities, we work with small businesses and fortune 500 companies alike. Give us a call at 1(800)730-2416 and let’s talk about your project.