Enhanced Security Measures in Place:   To ensure a safer experience, we’ve implemented additional, temporary security measures for all users.

Simple QXL Query help needed

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Announcements

Simple QXL Query help needed

L3 Networker

Hi All,

withing query builder i have a very basic query as per below..

 

dataset = metrics_source
| fields _vendor , _product , total_size_bytes

 

which shows me the data sources and the amount of ingested data per source which is fine over a period specified in (24hr/days etc)..

 

what i am trying to achieve is for a period of 24 hours, for it to show how much data being ingested on an hourly basis per device

any idea how to?

thanks in adv

1 REPLY 1

L4 Transporter

Hi PA_nts,

 

You need to use the bin stage for this.

 

dataset = metrics_source
| fields _vendor , _product , total_size_bytes
| bin _time span = 1h
| comp sum(total_size_bytes) as total_size_bytes by _time, _product

  • 628 Views
  • 1 replies
  • 0 Likes
Like what you see?

Show your appreciation!

Click Like if a post is helpful to you or if you just want to show your support.

Click Accept as Solution to acknowledge that the answer to your question has been provided.

The button appears next to the replies on topics you’ve started. The member who gave the solution and all future visitors to this topic will appreciate it!

These simple actions take just seconds of your time, but go a long way in showing appreciation for community members and the LIVEcommunity as a whole!

The LIVEcommunity thanks you for your participation!