Grid chart (bubble graph)

[#1]

Hi,

I want a Grid chart with three expressions; Number of breakdowns, hours of maintenance on breakdown and total costs of the breakdown .

How do i get this? i tried alot of things but it keeps says  error in calculation. (the photo is made in access)

Thanks in advance.

[Gysbert_Wassenaar · Accepted solution]

Use a scatter chart and add one dimension and your three expressions.

[#3]

Ok, now i got 75% of it working.

But the number of breakdowns comes from the selected maintenance type.

Now it shows all maintenance type (=Count(Maintenance_type)) but it should only count maintenancetype Breakdown.

[Gysbert_Wassenaar]

Try changing that expression to =Count({<Maintenance_type={'Breakdown'}>}Maintenance_type)

[#5]

Did it but all the parts that had 0 breakdowns are still in it.