Time filter on Markdown text using ES SQL query syntax

Elastic Stack Kibana
1

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.

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