Hi,  I have onboarded data via DBConnect through Rising Column for which we have configured the Risinig Column value as RS_LAST_MAINTENANCE_TIMESTAMP which is the default Time field. But in the dashboard we have filtering the month wise apps count based on APPLICATION_CRT_DT which has no timestamp. Issue is if we search data for last 7 days, Jan month data is also populating as that particular app is created on Jan month and updating values in last 7 days. so, written "where" condition like below which is not working in all cases(working only when searching since "date",applying epoc time for the below where condition and getting accurate results, but when searching for last 7 days or 24 hrs or all time, that parameter is passing as -7d@d and getting error as invalid). Kindly help on this <input type="time" token="datefield" <default> <earliest>0</earliest> <latest>now</latest> <row> <table> <search> <query>index=* source=tablename |eval Total_Apps=if(match('Type',"NTB"),"1","0") |eval Date=strptime(APPLICATION_CRT_DT,"%Y-%m-%d %H:%M:%S") |where Date&gt;=$datefield.earliest$ OR Date&tl;=$datefield.latest$ |eval Mon-Year=strftime(strptime(APPLICATION_CRT_DT,"%Y-%m-%d %H:%M:%S"),%b-%Y) |stats sum(Total_Apps) as "Total Apps" by Mon-Year ... View more

Hi, I have below fields in which i need to display the count of each field value |eval TotalApps=if(match('Type'="NTB"),"1","0") |eval InProgress=if(Type= "NTB" AND isnull(date),"1","0") |eval Submitted=if(Type= "NTB" AND isnotnull(date),"1","0") |eval Apps_Submitted=if(match('Myinfo_Used',"1"),'REASON_CD',"0") |stats count by Apps_Submitted getting results as COPS   1 CMS   2 FCO   3 but requirement is |stats sum(TotalApps) as TotalApps sum(InProgress) as InProgress sum(Submitted) as  Submitted (along with the AppsSubmitted count of each field value) Eg: TotalApps    10 InProgress   5 Submitted   5 AppsSubmitted  5 COPS       1 CMS         2 FCO          3 ... View more

|eval TotalApps=if(match('Total',"NTB"),"1","0") |eval In-Progress=if('Total'="NTB" AND isnull('APPL_SUB-DATE'),"1","0") |eval Submitted=if('Total'="NTB" AND isnotnull('APPL_SUB-DATE'),"1","0") |eval My-InfoUsed=if('Total'="NTB" AND isnotnull('APPL_SUB-DATE') AND isnotnull('MY-INF0-CONCUR-FLAG'),"1","0") |stats sum(TotalApps) as "Total Apps" sum(In-Progress) as "In Progress" sum(Submitted) as "Apps Submitted" sum(My-InfoUsed) as "My InfoUsed" by Mon-Year |transpose Column_name="Category" getting results as Category        row1 Mon-Year                Jan-2023 Total Apps                06 In Progress              06 Apps Submitted      0 My InfoUsed              0 But requirement is , Mon-Year        Category               Total Jan-2023         TotalApps              06                               In Progress            06                               Apps Submitted    0                               My InfoUsed             0 ... View more

Hi, I have 5 multiselect input filed in dashboard as below Environment, field2,field3, field4,field5 After selecting the Environment value in the Environment field, the dashboard immediately starts searching. But our requirement is the dashboard will not start searching until the Environment has Values and either of  remaining 4 fields(field2 OR 3OR 4OR 5) has values. kindly help me on this on how to pass token to achieve this result. Thanks in advance!       ... View more

I have field called URN, ControlFlowID, RequestID and SpanID Requirement is to get data for each URN,how many controlflowid and for each controlflowID, how many requestID and for each requestID how many SpanID needs to populate data in a table view by merging multivalue in a single row. can anyone help me on this. Eg: URN    ControlFlowID     RequestID      SpanID URN1    CTRLFLOW1       REQ1               SpanID1 URN1     CTRLFLOW1       REQ2             SpanID2 URN1      CTRLFLOW1     REQ3               SpanID3 Requirement as below: URN    ControlFlowID     RequestID      SpanID                 CTRLFLOW1        REQ1              SpanID1 URN1                                       REQ2               SpanID2                  CTRLFLOW2        REQ3                SpanID3 ... View more