Create a pivot table having 1 dimenion as row, and in columns i want number of calls and in values no of leads who have been called 0 times, 1 time, 2 time and so on

Question & Answer
, ,
1

I want to create a pivot table Lead vintage wise, Nof calls made in Columns I.e 0 calls,1 call, 2 calls, 3 calls and so on, and in values no of leads with 0 calls, 1 call,2 calls, 3 calls and so on.

The view looks like this

image
image834×112 7.96 KB

How to achieve this?

2

Hi @kariappa
So you have a “number of calls” and an “id” field,right?
BR

3

id field is there which is distinct
number of calls - we have calls raw data, i.e my raw data consists of each call as a row and it has datetime column as well, so here no of calls also needs to be aggregated.

4

And one ID can have 0,1,2,3 calls? Because your table looks like it.

Maybe you can share sample data, in best case with Arena?

If you do a sum({number of calls},[id]) you will get to total calls for each ID.

5

Agree with ErikG. We can help you further after you replicate your issue with a simple dashboard and non sensitive data at our Arena: QuickSight Arena – An embedded instance of QuickSight within the QuickSight Community