Comparing multiple dimensions with same outcome

[Bujinlkham_Boldbaata]

The dataset has several dimensions with outcomes such as PASS, FAIL, WARNING as shown in the image. I want to create a stacked bar or a summary table example shown from the Tableau.

[Nico]

@Bujinlkham_Boldbaata ,

have you tried countIf?

countIf - Amazon QuickSight

Best regards,
Nico

[Nico]

Here is an example for one status:

countIf(
   {authenticityCheckStatus},
   {authenticityCheckStatus}= "PASS"
)

[Bujinlkham_Boldbaata]

Hello Nico,

Thank you for your response. I did try countif but is there a way to countif for all dimensions by PASS, WARNING, FAIL instead creating calculated field for each and every one of them.

[Nico]

Hi @Bujinlkham_Boldbaata ,

You could prepare the datasource. Glue could be helpfull.

I do not see another way to solve this only with the quicksight tools.

Best regards,
Nico

[WLS-D]

Hi @Bujinlkham_Boldbaata,
It’s been awhile since we last heard from you, just wanted to check in and see if you have any additional questions regarding your original topic or if Nico’s suggestion helped you.

If we do not hear back in the next 3 business days, I’ll go ahead and archive this topic.

Thank you!

[Brett]

Hi @Bujinlkham_Boldbaata,
Since we haven’t heard back, I’ll go ahead and mark the solution. If you have any further questions, feel free to create a new topic in the community and link this discussion for relevant information.

Thank you!