# Canvas Filters (filterrows)

**URL:** <https://discuss.elastic.co/t/canvas-filters-filterrows/321075>\
**Category:** Kibana\
**Tags:** canvas\
**Created:** [December 12, 2022, 11:46pm UTC](https://discuss.elastic.co/t/canvas-filters-filterrows/321075 "2022-12-12T23:46:42Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Mark\_Rodman](https://avatars.discourse-cdn.com/v4/letter/m/57b2e6/32.png) [@Mark\_Rodman](https://discuss.elastic.co/u/Mark_Rodman)\
**Post date:** [December 12, 2022, 11:46pm UTC](https://discuss.elastic.co/t/canvas-filters-filterrows/321075/1 "2022-12-12T23:46:42Z")

</div>

Hi,  
I'm starting to learn Canvas but struggling with a few concepts in the expression editor. I hope someone can point me in the correct direction.

I'm trying to filter a table, using the current date. My table contains a column called iso\_date which I want to filter on. I'm using mapColumn to simplify the column, ensuring it contains only "YYYY-MM-DD" as I don't want the time included in the source data.

Afterwards I'm trying to use `filterrows` to match the current date within the table.  
The below example works if I hard code a date string, ie 2022-12-14

```auto
filters
| esdocs index="team_shift*"
fields="iso_date, shift_pattern.early_analyst"
| mapColumn "iso_date" fn={getCell "iso_date" | formatdate "YYYY-MM-DD"}
|filterrows {getCell "iso_date" | any {eq "2022-12-14" }}
| render

```

However if I'm failing if I try and do this dynamically for example;

```auto
filters
| esdocs index="soc_shift*"
fields="iso_date, shift_pattern.early_analyst"
| mapColumn "iso_date" fn={getCell "iso_date" | formatdate "YYYY-MM-DD"}
|filterrows {getCell "iso_date" | any {eq date | formatdate "YYYY-MM-DD" }}
| render

```

Any advice on how to achieve this would be appreciated, I feel I'm close but not quite there.  
Thanks

---

<div class="post-metadata">

**Author:** ![Mark\_Rodman](https://avatars.discourse-cdn.com/v4/letter/m/57b2e6/32.png) [@Mark\_Rodman](https://discuss.elastic.co/u/Mark_Rodman)\
**Post date:** [December 12, 2022, 11:55pm UTC](https://discuss.elastic.co/t/canvas-filters-filterrows/321075/2 "2022-12-12T23:55:29Z")

</div>

sorted

```auto
filters
| esdocs index="team_shift*"
fields="iso_date, shift_pattern.early_analyst"
| mapColumn "iso_date" fn={getCell "iso_date" | formatdate "YYYY-MM-DD"}
|filterrows {getCell "iso_date" | any {eq {date|formatdate "YYYY-MM-DD"} }}
| render

```

---

<div class="post-metadata">

**Author:** ![hendry.lim](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/hendry.lim/32/71328_2.png) [@hendry.lim](https://discuss.elastic.co/u/hendry.lim)\
**Post date:** [December 13, 2022, 1:21am UTC](https://discuss.elastic.co/t/canvas-filters-filterrows/321075/3 "2022-12-13T01:21:00Z")

</div>

You should add a date filter bar to your Canvas instead.

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\
**Post date:** [January 9, 2023, 11:32pm UTC](https://discuss.elastic.co/t/canvas-filters-filterrows/321075/4 "2023-01-09T23:32:02Z")

</div>



---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\
**Post date:** [February 6, 2023, 11:32pm UTC](https://discuss.elastic.co/t/canvas-filters-filterrows/321075/5 "2023-02-06T23:32:32Z")

</div>

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.