About sweety1309

sweety1309 · ‎02-15-2021

Sure.Here is the screenshot @ITWhisperer

sweety1309 · ‎02-15-2021

Still facing this issue @ITWhisperer

sweety1309 · ‎02-15-2021

This solves my problem to a few extent as it removes true from the already filled column but doesnt remove it from the empty one.Please have a look at the image. Thanks for ur reply @ITWhisperer

sweety1309 · ‎02-11-2021

@ITWhisperer

sweety1309 · ‎02-11-2021

Ya sure.Here is the screenshot @ITWhisperer

sweety1309 · ‎02-10-2021

No,I m facing the same issue @ITWhisperer

sweety1309 · ‎02-10-2021

As you can see in the picture..Some td tags have two div containing true.If I remove the second true div,the work is done. @ITWhisperer

sweety1309 · ‎02-10-2021

Here is the screenshot @ITWhisperer

sweety1309 · ‎02-10-2021

I have attached the screenshot on the inspect element.Please have a look @ITWhisperer

sweety1309 · ‎02-09-2021

This is how I have written its query.Can u plz point out my mistake @ITWhisperer <row> <panel depends="$stayhidden$"> <title>Only SimpleXML no JS required</title> <html> <style> #tableRowColor table tbody td div.multivalue-subcell[data-mv-index="1"]{ display: none; } </style> </html> </panel> <panel> <table id="tableRowColor"> <search> <query>index="dpsn-classroom-students" profile.emailAddress="$email$" earliest=0 latest=now | join type=outer courseId [search index="dpsn-courses" courseState="ACTIVE" ] | join type=outer courseId max=0 [search index="dpsn-course-work" | rename id as courseWorkId ] | join type=outer userId, courseId, courseWorkId [search index="dpsn-students-submission" | dedup userId, courseId, courseWorkId sortby -updateTime] | rename profile.name.fullName as StudentName | rename name as Classroom | rename submissionHistory{}.gradeHistory.pointsEarned as pointsEarned | foreach * [| eval <<FIELD>>=mvappend('<<FIELD>>',late)] | table StudentName, courseId, courseWorkId, userId, Classroom, descriptionHeading, title, workType, maxPoints, pointsEarned, state </query> <earliest>$time_tok.earliest$</earliest> <latest>$time_tok.latest$</latest> </search> <option name="count">20</option> <option name="drilldown">cell</option> <option name="percentagesRow">false</option> <option name="rowNumbers">true</option> <option name="totalsRow">false</option> <option name="wrap">false</option> <format type="color"> <colorPalette type="expression">if(match(value,"true"),"#53A051",null)</colorPalette> </format> </table> </panel> </row>

sweety1309 · ‎02-09-2021

Thanks a lot for ur quick response @ITWhisperer . If u look at the image,true value is coming in all the columns now which I dont want.Can u please help me with this. Thanks in advance

sweety1309 · ‎02-09-2021

Thanks for ur response.I want that whole row to get coloured which contains true value.

sweety1309 · ‎02-09-2021

Hey I have the query- index="classroom-students" profile.emailAddress="something" earliest=0 latest=now | join type=outer courseId [search index="courses" courseState="ACTIVE" ] | join type=outer courseId max=0 [search index="course-work" | rename id as courseWorkId ] | join type=outer userId, courseId, courseWorkId [search index="students-submission" | dedup userId, courseId, courseWorkId sortby -updateTime] | rename profile.name.fullName as StudentName | rename name as Classroom | rename submissionHistory{}.gradeHistory.pointsEarned as pointsEarned | table StudentName, courseId, courseWorkId, userId, Classroom, descriptionHeading, title, workType, maxPoints, pointsEarned, state, late. In late column,i get "true" in some rows.I want to color those rows where I am getting "true" in late column.Like if u look at the imagfe,I want to color the whole second row. Any help would be highlt appreciated.Thanks in advance.

sweety1309 · ‎12-16-2020

Can u help me with any alternate options ..I need the meeting_code..Please help me with this.I am stuck here

sweety1309 · ‎12-14-2020

But meeting_code is all I need here.

sweety1309 · ‎12-14-2020

But now I am not getting the meeting_code which I was getting earlier in this case.U can have a look at the image.

sweety1309 · ‎12-14-2020

Please help me

sweety1309 · ‎12-14-2020

Hello everyone,I have this query- index="dpsnapitt" AND (class= "GRADE 12 B" OR class= "GRADE 12 B *") AND (day="DAY 4" OR NOT day=*) | rename "start time" as start, "end time" as end | rename class as Class | rename email as organizer_email | dedup subject, Class, organizer_email, start | join type=outer organizer_email [search index="dpsn_teachers" earliest=0 latest= now | rename name.fullName as teacher | rename primaryEmail as organizer_email] |join type=outer organizer_email max=0 [search index="dpsn_meet" | where email== organizer_email] | rex field=date "(?<yy>[^\.]*)\-(?<mm>[^\.]*)\-(?<dd>[\S]*)T(?<hh>[^\.]*)\:(?<min>[^\.]*)\:(?<sec>[^\.]*)\." | eval ndatetime = yy.mm.dd.hh.min.sec | eval _time=strptime(ndatetime,"%Y%m%d%H%M%S") + 19800 | eval Time=strftime(_time, "%H:%M") | eval p = strptime(start,"%H:%M")-1020|eval q = strftime(p,"%H:%M") | eval r = strptime(end,"%H:%M") |eval s = strftime(r,"%H:%M") | eval meet_start_time = strftime((strptime(Time,"%H:%M")-duration_seconds), "%H:%M") | eval z = if((meet_start_time >= q AND meet_start_time <= s), 1, 0) | eval meeting_code = case( z == 1, meeting_code, z==0, "N/A") | dedup organizer_email, meeting_code, start, end | table Class, teacher, organizer_email, subject, "start", "end", meeting_code | sort - period - day | reverse If I run this query on 4 Dec 2020,it is producing following result-see image. Those rows where meeting code is present is getting duplicated with meeting_code "N/A".I dont want that duplicated row. Please help..I would be very thankful.

sweety1309 · ‎12-09-2020

Hello,I have this query.. index="dpsn_students" earliest=0 latest=now suspended=false AND (class= "*" OR class= "* *") | dedup primaryEmail | rename primaryEmail as email | eval class=upper(class) | join type=outer email [ search index="dpsn_meet" | rex field=date "(?<yy>[^\.]*)\-(?<mm>[^\.]*)\-(?<dd>[\S]*)T(?<hh>[^\.]*)\:(?<min>[^\.]*)\:(?<sec>[^\.]*)\." | eval ndatetime = yy.mm.dd.hh.min.sec | eval _time=strptime(ndatetime,"%Y%m%d%H%M%S") + 19800 | eval Time = strftime(_time, "%Y-%m-%d %H:%M:%S") | eval Duration = duration_seconds/60 | stats sum(Duration) as tot by email] | join type=outer class [ search index="dpsnapitt" AND (class= "*" OR class= "* *") AND day="DAY 1" | stats count as Total by class | eval class_time=Total*30] | fillnull value="0" | where class!="0" | eval m=0.75 | eval p=1 | eval n=class_time | eval o=m*n*p | where tot >= o | stats count as "Total" If I run this query on Monday with the time range of last 31 hours before 2pm, some data is coming but it should be 0 as there is no school on Sunday. At 2pm on Monday, cron job is done but I dont know how to handle it before 2pm. Pleases help.

sweety1309 · ‎10-27-2020

but OR will not give me the common data which occurs in all the duration set.I need common data

sweety1309 · ‎10-27-2020

I need common data which occurs in all the duration set thats why i m using AND here

sweety1309 · ‎10-26-2020

I need all data which is available in all three durations set

sweety1309 · ‎10-26-2020

Hi I have the below query.But its output is "no results found".I dont know what mistake am I making.Please help index="entab_due" Session=2019 ClassName="* *" | join type=outer AdmissionNo, FeeInstallmentName, Session [search index="entab_collection"] | eval start = strptime(DueDate, "%d/%m/%Y") | eval end = strptime(RecDate, "%d/%m/%Y") | eval duration = round((end-start)/86400) | where (duration > 45 and duration <= 75) AND (duration > 105 and duration <= 120) AND (duration > 120 and duration <= 180) AND (duration > 180) | table AdmissionNo,StudentName

Posts	25
Solutions	0
Karma Given	0
Karma Received	1
Member Since	‎08-28-2020

Online Status	Offline
Date Last Visited	‎02-15-2021 07:31 AM

Color a row based on a column value

Duplication of row

Manage data for Sunday

Multiple 'Where' conditions

Re: Color a row based on a column value

Re: Color a row based on a column value

Re: Color a row based on a column value

Re: Color a row based on a column value

Re: Color a row based on a column value

Re: Color a row based on a column value

Re: Color a row based on a column value

Re: Color a row based on a column value

Re: Color a row based on a column value

Re: Color a row based on a column value

Re: Color a row based on a column value

Re: Color a row based on a column value

Color a row based on a column value

Re: Duplication of row

Re: Duplication of row

Re: Duplication of row

Re: Duplication of row

Duplication of row

Manage data for Sunday

Re: Multiple 'Where' conditions

Re: Multiple 'Where' conditions

Re: Multiple 'Where' conditions

Multiple 'Where' conditions