Home

bin with extend varible

%3CLINGO-SUB%20id%3D%22lingo-sub-203979%22%20slang%3D%22en-US%22%3Ebin%20with%20extend%20varible%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-203979%22%20slang%3D%22en-US%22%3E%3CDIV%3E%3CSPAN%3Ethe%26nbsp%3Bfirst%26nbsp%3B%20example%20works%20fine%20the%20second%20one%20throws%20an%20error%3C%2FSPAN%3E%3C%2FDIV%3E%3CDIV%3E%3CSTRONG%3E%7C%20extend%20bucket1%3D1s%3C%2FSTRONG%3E%3C%2FDIV%3E%3CDIV%3E%3CSTRONG%3E%7C%20summarize%20any(x)%20by%20bin(TimeGenerated%2Cbucket)%3C%2FSTRONG%3E%3C%2FDIV%3E%3CDIV%3E%26nbsp%3B%3C%2FDIV%3E%3CDIV%3E%26nbsp%3B%3C%2FDIV%3E%3CDIV%3E%3CDIV%3E%3CSTRONG%3E%7C%20extend%20bucket%20%3D(iff(true%2C1s%2C1s))%3C%2FSTRONG%3E%3CBR%20%2F%3E%3CDIV%3E%3CSTRONG%3E%7C%26nbsp%3Bsummarize%26nbsp%3Bany(x)%26nbsp%3Bby%26nbsp%3Bbin(TimeGenerated%2Cbucket)%3C%2FSTRONG%3E%3C%2FDIV%3E%3CDIV%3Ethe%20error%3A%3C%2FDIV%3E%3CDIV%3E%3CSPAN%3Ebin()%3A%20failed%20to%20cast%20argument%202%20to%20scalar%20constant%20Support%20id%3A%20acaf1907-d613-4238-a4c7-f77033167916%3C%2FSPAN%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-203979%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EApplication%20Insights%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EAzure%20Log%20Analytics%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EQuery%20Language%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
asaf levi
Occasional Visitor
the first  example works fine the second one throws an error
| extend bucket1=1s
| summarize any(x) by bin(TimeGenerated,bucket)
 
 
| extend bucket =(iff(true,1s,1s))
| summarize any(x) by bin(TimeGenerated,bucket)
the error:
bin(): failed to cast argument 2 to scalar constant Support id: acaf1907-d613-4238-a4c7-f77033167916
Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies