Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Reports aren't using relative dates for Meta Store #4691

Open
stroomdev10 opened this issue Jan 8, 2025 · 0 comments
Open

Reports aren't using relative dates for Meta Store #4691

stroomdev10 opened this issue Jan 8, 2025 · 0 comments
Assignees
Labels
bug f:dash / query Issues relating to dashboards, queries, visualisations, etc.
Milestone

Comments

@stroomdev10
Copy link
Member

Tried using Top Level Time filter and also ${Create Time} in the query, but it is always using now()

from "Meta Store"

where Type = 'Events' 
and ${Create Time} between hour()-1h and hour()

eval Period = floorHour(${Create Time})
eval Read = sum(${Read Count})
eval Write = sum(${Write Count})
eval Info = sum(${Info Count})
eval Warning = sum(${Warning Count})
eval Error = sum(${Error Count})
eval Fatal = sum(${Fatal Error Count})

group by Period, Feed

select Period, Feed, Read, Write, Info, Warning, Error, Fatal
@stroomdev10 stroomdev10 added the bug label Jan 8, 2025
@stroomdev10 stroomdev10 added this to the 7.8 milestone Jan 8, 2025
@stroomdev10 stroomdev10 added the f:dash / query Issues relating to dashboards, queries, visualisations, etc. label Jan 9, 2025
@stroomdev66 stroomdev66 self-assigned this Jan 20, 2025
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug f:dash / query Issues relating to dashboards, queries, visualisations, etc.
Projects
None yet
Development

No branches or pull requests

2 participants