I’m trying to display active failed runs in my visualisation. I have 4 fields namely Client,build,instance,status and the values are populated as below:
Client: AAA,BBB,ABC
Build: 202405,202404,202403
Instance: 20240522,20240521,20240520
Status: Success, Running, Failed
We are trying to filter/display only records that got failed and haven’t been restarted[Running/Success] yet for a particular instance[Current date]
In simple words we would like to display active failures, which is runs that got failed and was not started[does not have Running/Success status] for current day.
I think there are two ways to do this if I understand your use case correctly. 1) You can add your your client name to a visual and then filter by Status and Instance so that it would only show the current Instance as well as “Failed”. 2) You can create a an ifelse statement like the one below:
ifelse(
{instance} = [current instance] AND {status} = ‘failed’,
{client},
NULL)
This would be easier with a date field, is your instance a date field or a string value?
As per your suggestion, I can create a visual and filter by Status and instance but my goal is to display records that are failed and not restarted(Status: Running), Success.
Also, the ifelse statement provided also displays the same which is only failed records but not active failed runs. Please find the below example for better understanding
The output I expect is below:
Client Build Instance Status
BBB 202406 20240527 Failed
Here, both AAA and BBB failed for 202406 build but AAA client has been restarted and is in progress and BBB was not restarted and is still in failed status. Hence I would like to display that record(BBB 202406) alone. Thanks!
Hi @Madhan482,
I wanted to follow up to see if you were still in need of assistance regarding your initial topic or if you were able to find a work around?
Perhaps if you could share your analysis in Arena view, we’d have a better opportunity to provide support:
Looking at the data provided, it seems like ‘Build’ is a date? This scenario would be easier to achieve if you had a date field to utilize in this. You could then use parsedate and an ifelse statement to narrow down your results.
Did this solution work for you? I am marking this reply as, “Solution,” but let us know if this is not resolved. Thanks for posting your questions on the QuickSight Community!
In case you need further assistance with your problem, please create a sample dashboard with sample dataset showing your problem state using Arena and please create a new post, so we can look at it from a fresh perspective. (Details on using Arena can be found here - QuickSight Arena)