Sum values based on a count in an expression

[#1]

Hi,

With the following expression I simply count values based on some string values of the dimension data:

=count({$<data={'value a', 'value b'}>}profile.id)

However, I want to sum these two values in this expression and not through the 'expressions - Full Accummulation', or the 'Total Mode - sum of rows'.

I tried it with rangesum and aggr, but with no success. Can anyone help?

Thanks in advance!

[Gysbert_Wassenaar · Accepted solution]

Maybe this:

sum(aggr(count({$<data={'value a', 'value b'}>}profile.id), MyChartDimension1, MyChartDimension2, ... etc ))

Replace MyChartDimension1, MyChartDimension2, ... etc with the names of the dimensions in your chart.

If that isn't what you need, see here and here.

[#3]

Thanks! I had tried this expression before too, but I forgot to remove the dimension data, so I always got two results and no accumulation.

[#4]

Hey guys,

I find this discussion helpful and I seem to have a similar problem. Basically I need to find the SUM of all employees in a company that has offices in different countried. A country is represented by Country ID and each employee has an employee ID. I need to count all employees in each country and sum up all employees. here is my equition that is giving me an error

='No. of Emp = ' &count({< [Country ID] = {'CI-005'} >}  distinct [Emp ID]),  count({< [Country ID] = {'CI-008'} >}  distinct [Emp ID])

Can someone here help to tell me whats wrong?