Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Use a scatter chart and add one dimension and your three expressions.
Use a scatter chart and add one dimension and your three expressions.
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.
Try changing that expression to =Count({<Maintenance_type={'Breakdown'}>}Maintenance_type)
Did it but all the parts that had 0 breakdowns are still in it.