Bar Chart with counted expression and counted dimension

[andy8000]

Hello everybody, 

i have two different tables:

• Orders: CustomerID, Product
  • One CustomerID could order multiple identical products
• Number of employees: CustomerID, Employees (1-10)

You'll find both tables at the bottom of this post (and in the attached files). 

Now I want to create a bar chart, displaying the Count of the ordered Product A on Y-Axis and the Count of companies with 5 employees on X-Axis.

The result should look like this:

I tried it with: 

Dimension: =count({<Product={'Product A'}>}Product)
Expressions: =count({<[Employees (1-10)]={'5'}>} CustomerID)

But it throws an error in calculated dimension. 

Could somebody please help me here :S
I would be very thankful 🙂

Orders:

CustomerID	Product
9	Product B
10	Product A
10	Product A
10	Product A
10	Product A
10	Product A
11	Product A
12	Product A
12	Product A
12	Product A
13	Product A
13	Product A
14	Product A
14	Product A
14	Product A
15	Product A
15	Product A
16	Product A
16	Product A
16	Product A
17	Product A
17	Product A
17	Product A
17	Product A
17	Product A
18	Product A
18	Product A
18	Product A
18	Product A

Number of employees:

CustomerID	Employees (1-10)
9	2
10	10
11	5
12	5
13	5
14	5
15	5
16	5
17	5

[sunny_talwar · Accepted solution]

Try this

Dimension

=Aggr(Count({<Product = {'Product A'}>}Product), CustomerID)

Expression 

count(DISTINCT {<[Employees (1-10)]={'5'}, Product = {'Product A'}>} CustomerID)

 

[andy8000]

Thank you for your answer 🙂
That's it! You made my day 😄