# Time filter on Markdown text using ES SQL query syntax

**URL:** <https://discuss.elastic.co/t/time-filter-on-markdown-text-using-es-sql-query-syntax/375745>\
**Category:** Kibana\
**Tags:** canvas\
**Created:** [March 11, 2025, 9:55pm UTC](https://discuss.elastic.co/t/time-filter-on-markdown-text-using-es-sql-query-syntax/375745 "2025-03-11T21:55:15Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![ArielC](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/arielc/32/141229_2.png) [@ArielC](https://discuss.elastic.co/u/ArielC)\
**Post date:** [March 11, 2025, 9:55pm UTC](https://discuss.elastic.co/t/time-filter-on-markdown-text-using-es-sql-query-syntax/375745/1 "2025-03-11T21:55:15Z")

</div>

I am using markdown text to display a value inside of a textbox.  
The text displays the following:  
"On average X% of users open all worksets"

However it is not responding to my time filter.

```auto
filters "timefilter"
| essql 
  "
  SELECT
    ROUND(
      (COUNT(*) - SUM(CASE WHEN projectWorksetOpenRatio = 1 THEN 1 ELSE 0 END))
      * 100.0 / COUNT(*)
    ) AS percentage
  FROM \"*revit-event*\"
  "
| markdown 
  content="
On average **{{rows.[0].percentage}}%** of users open all worksets
" 
  font={font align="center" color="#000000" family="'Open Sans', Helvetica, Arial, sans-serif" italic=false size=14 underline=false weight="normal"}
| render

```