Add count of two values from a field in a table where other counts for individual values of the field are displayed

Question & Answer
,
1

I need to have a row that combines the count of foxtrot and golf on this same table.

Count is a custom field counting the instances of the resolver appearing in a field with a distinct value representing different requests.

quicksight
quicksight857×546 50.2 KB

2

Hi @edredond,

Can you show a screenshot of your Count calculated field?

3

HI @edredond ,
maybe countif or sumif will help.

BR

4

image

Hello! It’s just a count of each individual instance that has an associated resolver.

5

Hello @edredond , @ErikG , and @David_Wong !

@edredond were you able to find a solution for this or were @ErikG or @David_Wong 's suggestions helpful in finding a solution. If so could you either share the solution you came up with or mark one the comments above as the solution to help the community?

6

Hello @edredond , @ErikG , and @David_Wong !

It has been some time since there has been activity on this thread, but we would still like to help find a solution.

@edredond it may be easier to do this on your dataset prior to bringing it into Quicksight. That being said you could try something like the following:

ifelse(
{resolver} = 'Golf' OR
{resolver} = 'Foxtrot',
{resolver} = 'Golf and Foxtrot',
{resolver})

If there is no activity on this thread in the next 3 days this topic will be archived.