Trying to add two filter conditions in Numerator and divide that by denominator using Calculated field

Hi I am pretty new to Quicksight and I am trying to create this calculation. Please let me know if you have any suggestions on this.

Numerator: Total count of distinct Issue Numbers where Issue type in A, C, D, F and Discovery Channel not in Customer complaint, External Agency

Denominator: Total count of distinct Issue Numbers

Calculation: Numerator/Denominator

The calculation is pretty straight forward but i need to add two filter conditions in the Numerator where issue type in A, C, Discovery channel, F

& Discovery Channel not in Customer complaint, External Agency

The data set looks something like this. There are three columns,

|Issue Numbers | Issue Type | Discovery Channel

|1 | A | ICTT | |
|2 | B | Customer Complaint | |
|3 | C | External Agency | |
|4 | Discovery Channel | Business Exec | |
|5 | E | ICTT | |
|6 | F | Customer Complaint | |

Hi @Rus welcome to the community.

The high-level steps involve, creating two variables with the appropriate filters using “if else” (similar to click here). Then, perform the calculations based on this video.
2024-04-28_10-16-27

In case you need further assistance with your problem, please create a sample dashboard with sample dataset showing your problem state using Arena and post it here. (Details on using Arena can be found here - QuickSight Arena

Please let us know if this is helpful.

Alex

1 Like

Sure, i have created this dashboard: I couldnt attach the link here.

Here I am trying to achieve:

Numerator = Total Count of distinct Issue ID where Issue type in ‘Kiwi’,‘Mango’,‘Banana’
And Discovery Channel not in ‘ACT’ and ‘CBB

Denominator = Total count if distinct Issue ID

Calculation = Numerator/Denominator


When i create variables using ‘if else’, it doesnt allow me to even add to it my numerator but i tried using IN function and it did work. Now the challenge i have is to divide the numerator with the denominator. It says " mismatched aggregation". Please help.

Hi @RUS,
Please use this article to trouble shoot the mismatched aggregation: