Chart Creation

Good afternoon.
I have an app where a table contains a machine relation.

In this app I have another table where I do problem logging when a machine breaks down.

I can create a chart that shows me how many machines I have available.
Look

What I want is to create a chart that shows me

Examples: I want to do that

It’s possible??