Filters Linked Visual Data Display only if number of records are 5 or more

Question & Answer
1

Experts,

I have an analysis with 5 filter controls. User can choose any combination of the filters. However, when a combination or a single filter returns less than 10 records, the data should not be displayed. Either we can hide the visuals or a message on the visual/chart like “Data Not Available”. Even the standard QS standard message will also work. The key here is data not be shown unless it returns more than 10 records.

Any thoughts on the possible solution?

2

Hi @kumarm22

Can you add a calculated field that counts all the records and filter that to make sure it’s greater than 10?

countOver({id},[],PRE_AGG)

image