First time posting here, I've been looking around but haven't found anything to point me towards the right direction to solve my issue.
I'm creating a Data Table with a Date Histogram as a bucket, and i need to display two columns.
One column is the Total amount of successful Jobs (this is a unique count of the field ['JOBID'] with ['Errorid'] being Null)
second column is the total amount of jobs with errors (this is a unique count of the filed ['JOBID'] with ['Errorid'] having a value other than null)
I've tried using a filter but it applys to the whole table so that doesn't work for me. i also tried using a split rows with two conditions exists:errorid and !(exists:errorid) but this doesn't display it in a seperate column, rather it splits the rows which is not what i want.
my end result should look something like this:
| DateTime | Successful jobs | Failed Jobs |
| Nov.22-2017 | 10 | 3 |
| Nov.21-2017 | 15 | 6 |
Any insight on how to tackle this would be highly appreciated.