About learningquery

learningquery · ‎10-26-2023

absolutely, I was too beginner to grasp it!

learningquery · ‎10-26-2023

I figured out the minor error was - "True" needs to be "true", as the value returns a boolean.

learningquery · ‎10-21-2023

Sorry, now I put the correct result (Pl ignore the previous result)

learningquery · ‎10-21-2023

Thanks for the hint. Attached is the result I get. But want the total count of all TRUE cases listed per calendar week in numbers and also in % (I don't want the FALSE as result ). The attached .xls shows what I am looking for with example numbers

learningquery · ‎10-20-2023

Thanks for providing the hints. I tried both the changes eval and random command it did not work unfortunately. While I am sure the data exists.

learningquery · ‎10-17-2023

Hi community, | eval ycw = strftime(_time, "%Y_%U") | stats count(eval("FieldA"="True")) as FieldA_True, count(eval('FieldB'="True")) as FieldB_True, count(eval('FieldC'="True")) as FieldC_True by ycw | table ycw, FieldA_True, FieldB_True, FieldC_True I get 0 result even though there is data. Could anyone please suggest a correct query? BR

Posts	6
Solutions	0
Karma Given	6
Karma Received	0
Member Since	‎10-17-2023

Online Status	Offline
Date Last Visited	‎11-02-2023 04:56 PM

conditional count(eval)

Re: conditional count(eval)

Re: conditional count(eval)

Re: conditional count(eval)

Re: conditional count(eval)

Re: conditional count(eval)

conditional count(eval)