I have 2 logs as below:
Fields: Timestamp, Job Name, Job Id, Error Code, Status: <Success/Fail>
Fields: Job Id, Error Code, Error Reason
My requriement is to display Log 1 data in bar chart ie. the number of jobs that have entered the system over the time period and number of jobs that have failed. When user clicks on the failed jobs in the bar chart, we need to show the failed job details in a data table.
I have created a bar with job count as Y Axis and job status as X axis. The graph is displaying the data correctly.
Now the issue is when I try to link it with the Data table.
Log 1 and Log 2 have only Job Id as common field and I can not display job count on my bar chart.
Is there any way that I can keep Job Id as hidden field in bar chart and when user clicks on failed job bar then the data table with error reason of failed job is displayed.