Hi Enrico,

My 2 cents (which might not work):

1. To get the number of time a phone number called: Create a Pull Up function using count, where a domain table on phone number is the first argument. Somehting like PU_COUNT(DOMAIN_TABLE('Phone number'),'case_table'.'ID')
2. Then create a histogram on this KPI, to create the chart you want.

If you want this in a table, then simply add the PU_COUNT as dimention, and a COUNT_TABLE('CASE_TABLE') as KPI.

As said, not tested, but these might get your further.

If this helps, please mark my post as 'the answer' ;)

Hello,

It's a little bit hard to visualise it because it seems to be 3 dimention chart. It would be combination of histogram (bucketing by number of calls) and also normal column chart with Caller ID as dimention and count of Phone number column.

Normal column graph looks like this:

The histogram can be done by aggregating table by itself using PU_COUNT(DOMAIN_TABLE("_CEL_CASES"."CALLER_ID"), "_CEL_CASES"."PHONE_NUMBER"). Histogram would be OK if you would find way to view the caller id on the axis where the number of occurrences is.

For now unfortunately I don't have idea how to combine those 2 chart types.

Hope it helped in any way.

Best regards,

Mateusz Dudek

First of all, thanks to both of the replies.

@deleted deleted maybe I expressed myself wrong, but I'm not interested in seeing the Caller IDs, but the output I would like is the second diagram you have attached (the one with yellow bars).

I also think that the Pull-UP function is the best solution, even if I don't have a DOMAIN_TABLE because the only tables I have are the ACTIVITY TABLE and the CASE TABLE (I don't have a table that collects apart from the numbers they call)

But I will try to extrapolate and create a table that collects the numbers (DOMAIN_TABLE) and then I will do as you advised me.

Thanks for the support. I appreciate it.

Enrico