Splunk Search

How to highlight table cell based on two jobs runtime?

avni26
Explorer

Hi Team,

I have multiple jobs runs daily . Showing the status of these jobs in table. Now, I want to highlight the cell depend on the jobs run time.
 For example there is three jobs .. Job Name A1 A2 A3 
and data for 3 days is like
date                    jobName              StartTime                                       Status
22-02-2022      A1                            22-02-2022 01:00:00         Success
22-02-2022      A2                            22-02-2022 04:00:00           Success
22-02-2022      A3                             22-02-2022  02:00:00          Success
23-02-2022      A1                            23-02-2022 00:50:00            Success
23-02-2022      A2                            23-03-2022 00:10:00           Success
23-02-2022      A3                             23-03-2033  03:00:00         Failed
24-02-2022      A1                            24-03-2022 00:20:00          Success
24-02-2022      A2                            24-03-2022 01:00:00          Success
24-02-2022      A3                             24-03-2033  00:00:00        Success

Now , I want  

  1. Job dependencies 01: If A2 runs before A1 then it should be highlighted with a different color., suppose red
  2. Job dependencies 02: If A3 runs before A1 then it should be highlighted with a different color., Yellow

    And at last table will look like


    Date A1 A2 A3
    22-02-2022 Success Success Success
    23-02-2022 Success Success Failed
    24-02-2022 Success Success Success

    Please help me to achieve this without using JS.
Labels (4)
0 Karma
Career Survey
First 500 qualified respondents will receive a $20 gift card! Tell us about your professional Splunk journey.

Can’t make it to .conf25? Join us online!

Get Updates on the Splunk Community!

Can’t Make It to Boston? Stream .conf25 and Learn with Haya Husain

Boston may be buzzing this September with Splunk University and .conf25, but you don’t have to pack a bag to ...

Splunk Lantern’s Guide to The Most Popular .conf25 Sessions

Splunk Lantern is a Splunk customer success center that provides advice from Splunk experts on valuable data ...

Unlock What’s Next: The Splunk Cloud Platform at .conf25

In just a few days, Boston will be buzzing as the Splunk team and thousands of community members come together ...