<@U01PBHBUN4F> Hi following up on the Reporting on...
# gooddata-cloud
p
@Michael Ullock Hi following up on the Reporting on records across a date range point, i haven't seen it in the release
m
Hi Pouyan! First of all, apologies that the feature you were asking for isn't available yet, as mentioned, this is a known limitation. With competing priorities across releases, it's still sitting in the backlog. To help push it forward, it would be great to have more context, since you offered, could you share more examples of your specific use case? It would also help to know how critical this is for your reporting and how it's been impacting you. I'll make sure the additional context gets passed along to our Product team to strengthen the feedback item. Thanks for your patience!
p
We have many reports in which we want to get count of records that two (or more) of their date fields fall into the user selected field. in one case we have employment periods. with that we are trying to get number of active employees using the
start
and
end
dates on their employment table. for example given an user has selected March to June, how many employees were active using this formula:
start
before or on March first and the employment
end
date on or after June 1st
m
Thank you for this update, we will ensure to pass your request with the use case to the Product Team.
p
thanks, is there a way to target date filter value set by user in mql? for example user has a range starting march 1st, in mql i want to access it so i can filter by march 1st?
m
Hi Pouyan! Just to make sure I point you in the right directio, are you looking to hardcode a specific date like March 1st directly in the MAQL (e.g.
BETWEEN "2026-03-01" AND THIS(DAY)
), or do you want users to be able to select the date (month? specific day?) dynamically from a dashboard filter and have the metric react to it?
p
looking to access the value of the filter the user has set on date in mql, for example if user has the range in screen shot in mql it would be 5/4/2026
m
Hi Pouyan! Thanks for clarifying. Unfortunately that's not currently possible in MAQL — the dashboard date filter value can't be accessed or referenced as a variable within a metric. This is a known limitation and as we mentioned it is logged as product feedback. Sorry if we don't have a better answer on this one.