Exclude days with no data from box plot

Comments

3 comments

  • Avatar
    Ulf Andreasson

    Marc,

    How does your query look like? I am pretty sure that if you can remove the null values in the query itself (min value) so that they won't show up in the table at all ....

  • Avatar
    Marc Powell

    _sourceCategory=production/web/* 
    | formatDate(_messagetime, "EEE") as day
    | where !(day="Sat" or day="Sun")
    | timeslice 24h
    | min(timetaken), pct(timetaken,25), pct(timetaken,50), pct(timetaken, 99) as _pct_75, max(timetaken) by _timeslice
    | sort by _timeslice asc

     

    Here's the query I'm using. We exclude Sat and Sun, which does exclude all results from these days, but the Box Plot still shows them on the chart. There doesn't appear to be any way to remove it from the box plot completely

  • Avatar
    Marc Powell

    So I appear to have inadvertently fixed this by myself by formatting the timeslice:


    | formatDate(_timeslice, "dd MMM yyyy") as Date
    | min(timetaken), pct(timetaken,25), pct(timetaken,50), pct(timetaken, 99) as _pct_75, max(timetaken) by Date
    | sort by Date asc

Please sign in to leave a comment.