Request for Creating Separate Calculated Fields for Passenger Count in QuickSight

Question & Answer
, , , , , , , ,
1

In QuickSight, I would like to create a calculated field that calculates the number of passengers based on the category of a cruise reservation (ID). Reservations can be made either as a group or as an individual. Currently, I have a field that calculates the number of passengers in two rows:

  1. It calculates the number of passengers when the category field is equal to “individual.”
  2. It calculates the number of passengers in a second row when the category field is equal to “group.”

I would like to create two separate calculated fields to calculate the number of passengers in each category, instead of combining them into a single field. The objective is to display this information in a single row rather than on two separate rows. The calculated fields will be named “number_passenger_individual” and “number_passenger_group.”

2

Hi @Lahcen - Are you facing any issues in creating the calculated field? Also if you can share sample data and expected output, it will help community to guide you the right approach and solution.

Regards - Sanjeeb

1 Like
3

Hi @Lahcen

Have you been able to resolve this ? . Please share screenshot of sample data & expected output.
If we do not hear back in the next 4 days, we will archive the question.

4