# How do I include filters in charts or dashboards

I am trying to substitute Excel worksheets and e-mail workflows

##### Post Metadata
- Posted at: over 6 years ago
- Author title: Value Analysis Engineer at Randon Implementos S.A. - Certified Master Black Belt
- Net upvotes: 1


## Comments
### Comment 1

Either use multiple fields in group by so you can drill down in a chart OR
create a dynamic slice to filter the data 
eg AND( [Production Date] >= Any(select(Date Select[Start Date], true)), [Resort Date] <= any(select (Date Select[End Date], true)))

##### Comment Metadata
- Posted at: over 6 years ago
- Author title: PeachTree Business Incubation




## Related Product
[AppSheet](https://www.g2.com/products/appsheet/reviews)

## Related Category
[No-Code Development Platforms](https://www.g2.com/categories/no-code-development-platforms)

## Related discussions
- [How well does Trello scale into a larger team?](https://www.g2.com/discussions/1-how-well-does-trello-scale-into-a-larger-team)
  - Posted at: about 13 years ago
  - Comments: 6
- [Can we please add a new section](https://www.g2.com/discussions/2-can-we-please-add-a-new-section)
  - Posted at: about 13 years ago
  - Comments: 0
- [Quantifiable benefits from implementing your CRM](https://www.g2.com/discussions/quantifiable-benefits-from-implementing-your-crm)
  - Posted at: about 13 years ago
  - Comments: 4