timeslice on custom date


1 comment

  • Avatar
    Benj Kamm

    I was able to do this eventually by using fillmissing *before* my formatDate, like this:

    (previous steps) | fillmissing timeslice(1d) in _messageTime with "example value" for myGroup | formatDate(_messageTime, "YYYY-MM-dd", "UTC") as utcDate | count by utcDate, myGroup | transpose row utcDate column myGroup

    Comment actions Permalink

Please sign in to leave a comment.