Bar Chart with counted expression and counted dimension

andy8000 — Sat, 16 Nov 2024 02:45:20 GMT

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:

Number of employees:

Re: Bar Chart with counted expression and counted dimension

sunny_talwar — Tue, 13 Aug 2019 19:11:49 GMT

Try this

Dimension

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

Expression

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

andy8000 — Tue, 13 Aug 2019 19:21:37 GMT

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