Workbook bug counting too many incidents?

%3CLINGO-SUB%20id%3D%22lingo-sub-2931392%22%20slang%3D%22en-US%22%3EWorkbook%20bug%20counting%20too%20many%20incidents%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2931392%22%20slang%3D%22en-US%22%3E%3CP%3EGreetings%2C%20i%20am%20trying%20to%20put%20together%20a%20decent%20workbook%20for%20a%20customer%20to%20use%20for%20reporting%20purposes%2C%20however%20i%20have%20come%20across%20something%20that%20might%20look%20like%20a%20peculiar%20bug.%26nbsp%3B%3CBR%20%2F%3E%3CBR%20%2F%3EWhen%20i%20count%20the%20number%20of%20incidents%20for%20the%20given%20time%20period%20it%20doesn't%20match%20with%20what%20is%20actually%20shown%20in%20the%20logs.%20This%20picture%20matches%20what%20i%20can%20see%20in%20the%20incidents%20tab%20and%20the%20logs%20for%20the%20time%20period.%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22stianhoydal_2-1636121081387.png%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F324573i5DAD480BECC07E20%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22stianhoydal_2-1636121081387.png%22%20alt%3D%22stianhoydal_2-1636121081387.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CBR%20%2F%3EHowever%2C%20when%20i%20add%20the%20remainder%20of%20the%20summarize%20line%20to%20generate%20a%20chart%20it%20shows%20extra%20count.%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22stianhoydal_1-1636121015657.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F324572i612817A9B9CA8AF3%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22stianhoydal_1-1636121015657.png%22%20alt%3D%22stianhoydal_1-1636121015657.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3ENotice%20the%201%20extra%20Medium%20severity%2C%201%20extra%20Informational%20severity%20and%202%20extra%20Low%20severity.%20Any%20ideas%20as%20to%20where%20these%204%20extras%20come%20from%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2938292%22%20slang%3D%22en-US%22%3ERe%3A%20Workbook%20bug%20counting%20too%20many%20incidents%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2938292%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F819982%22%20target%3D%22_blank%22%3E%40stianhoydal%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20BIN%20is%20rolling%20all%20the%20data%20for%20the%20'whole'%20day%20into%20the%20result%2C%20the%201st%20query%20is%20only%20getting%20the%20data%20(I%20suspect)%20from%20when%20you%20actually%20ran%20the%20KQL%20minus%2024hrs.%3CBR%20%2F%3Ee.g.%20If%20%3CSTRONG%3ETimeRange%3C%2FSTRONG%3E%20was%20set%20to%20last%2024hrs%2C%20and%20you%20opened%2Fran%20query%20%231%20at%209%3A00%2C%20its%20looking%20back%20to%209%3A00%20the%20previous%20days%20(-24hrs)%2C%20the%20BIN%20is%20looking%20back%20to%20the%20midnight%2C%20so%20has%20an%20extra%209hrs%20or%20different%26nbsp%3B%20data.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2938675%22%20slang%3D%22en-US%22%3ERe%3A%20Workbook%20bug%20counting%20too%20many%20incidents%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2938675%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1210469%22%20target%3D%22_blank%22%3E%40Clive_Watson%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20for%20the%20response%2C%20I%20had%20a%20similar%20thought%20when%20i%20first%20encountered%20this%2C%20but%20the%20bin%20does%20not%20seem%20to%20be%20the%20cause%2C%20or%20at%20least%20not%20in%20the%20way%20we%20think.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThis%20is%20a%20screen%20shot%20from%20events%20accumulated%20in%20the%20previous%20month%3A%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22stianhoydal_0-1636371576592.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F325155i78DA5A5D3AD4FE2C%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22stianhoydal_0-1636371576592.png%22%20alt%3D%22stianhoydal_0-1636371576592.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EWith%20the%20accompanying%20query%20and%20graph.%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22stianhoydal_1-1636371611400.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F325156i8982007B9313020D%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22stianhoydal_1-1636371611400.png%22%20alt%3D%22stianhoydal_1-1636371611400.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3ETo%20get%20a%20similar%20number%20of%20events%20i%20need%20to%20add%20several%20extra%20days%20in%20the%20time%20range%20if%20i%20remove%20the%20bin%20function%3A%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22stianhoydal_2-1636371702838.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F325158iDBE950778063EF8A%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22stianhoydal_2-1636371702838.png%22%20alt%3D%22stianhoydal_2-1636371702838.png%22%20%2F%3E%3C%2FSPAN%3E%26nbsp%3BI%20have%20added%202%20extra%20days%20to%20make%20sure%20the%20bin%20doesn't%20gather%20extra%20information%20as%20well%20as%20set%20the%20time%20frame%20from%2000%3A00%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22stianhoydal_3-1636371764791.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F325159iFB59194D873F234A%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22stianhoydal_3-1636371764791.png%22%20alt%3D%22stianhoydal_3-1636371764791.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EThat%20leaves%20me%20with%20this%20result.%20They%20were%20obviously%20not%20expected%20to%20be%20the%20same%2C%20but%20just%20to%20prove%20a%20point%26nbsp%3B%20that%20it%20is%20not%20just%20extra%20time%20the%20bin%20function%20has%20found%20other%20incidents.%26nbsp%3B%3C%2FP%3E%3CP%3EAdding%20back%20the%20bin%20function%20in%20the%20last%20query%20gives%20this%20result%3A%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22stianhoydal_4-1636371903964.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F325162i8C17D877F3C0BEAE%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22stianhoydal_4-1636371903964.png%22%20alt%3D%22stianhoydal_4-1636371903964.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E5%20extra%20events%20this%20time%20around.%26nbsp%3B%3C%2FP%3E%3CP%3ECould%20it%20be%20that%20the%20bin%20function%20somehow%20counts%20extra%20incidents%3F%20How%20does%20it%20treat%20for%20example%20an%20incident%20that%20has%20its%20severity%20changed.%20I%20suppose%20it%20shouldn't%20show%20up%20seeing%20as%20i%20use%20the%20dcount(IncidentNumber)%20however%20i%20do%20summarize%20based%20on%20severity%20and%20that%20might%20be%20a%20source%20of%20a%20duplicate%3F%20Or%20incidents%20that%20has%20happened%20and%20the%20been%20updated%20in%20the%20next%20day%3F%20Just%20throwing%20out%20ideas.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Contributor

Greetings, i am trying to put together a decent workbook for a customer to use for reporting purposes, however i have come across something that might look like a peculiar bug. 

When i count the number of incidents for the given time period it doesn't match with what is actually shown in the logs. This picture matches what i can see in the incidents tab and the logs for the time period.

stianhoydal_2-1636121081387.png


However, when i add the remainder of the summarize line to generate a chart it shows extra count. 

stianhoydal_1-1636121015657.png

Notice the 1 extra Medium severity, 1 extra Informational severity and 2 extra Low severity. Any ideas as to where these 4 extras come from?

2 Replies

@stianhoydal 

The BIN is rolling all the data for the 'whole' day into the result, the 1st query is only getting the data (I suspect) from when you actually ran the KQL minus 24hrs.
e.g. If TimeRange was set to last 24hrs, and you opened/ran query #1 at 9:00, its looking back to 9:00 the previous days (-24hrs), the BIN is looking back to the midnight, so has an extra 9hrs or different  data.

@Clive_Watson 

Thanks for the response, I had a similar thought when i first encountered this, but the bin does not seem to be the cause, or at least not in the way we think. 

 

This is a screen shot from events accumulated in the previous month: 

stianhoydal_0-1636371576592.png

With the accompanying query and graph. 

stianhoydal_1-1636371611400.png

To get a similar number of events i need to add several extra days in the time range if i remove the bin function:

stianhoydal_2-1636371702838.png I have added 2 extra days to make sure the bin doesn't gather extra information as well as set the time frame from 00:00

stianhoydal_3-1636371764791.png

That leaves me with this result. They were obviously not expected to be the same, but just to prove a point  that it is not just extra time the bin function has found other incidents. 

Adding back the bin function in the last query gives this result:

stianhoydal_4-1636371903964.png

5 extra events this time around. 

Could it be that the bin function somehow counts extra incidents? How does it treat for example an incident that has its severity changed. I suppose it shouldn't show up seeing as i use the dcount(IncidentNumber) however i do summarize based on severity and that might be a source of a duplicate? Or incidents that has happened and the been updated in the next day? Just throwing out ideas.