Skip to main content
Question

Filtering based on the count of a particular field

  • July 10, 2023
  • 0 replies
  • 53 views

I'm trying to filter a pie chart to only show where there is more than one instance. The pie chart shows the number of articles that appear in each journal, but I want to exclude journals where # of articles is 1 (or less than 2)

Journal is a field

Article is a field 

The pie chart is using # of articles for data values. 



------------------------------
Michael Buller
------------------------------
This topic has been closed for replies.

  • Registered
  • July 10, 2023

You should be able to add a filter in the report settings for "where Articles is less than 2".

If Articles are a child of the Journal record, then you first need to make a summary field for # of Articles, and then add the filter using this field.

This will filter all of the data going into the delicious pie chart.



------------------------------
gary
------------------------------