V-LOOKUP to update dash chart

Hello

I want a pie dashboard created that picks up data for each individual contract automatically when selected in the drop down list.

I need charts created for down time running, efficiency.

Once these has been created, all machines associated with that particular contract should be picked up when selected from the drop list.

The chart should only display the most efficient machine.. e.g if there are 5 machines for one area then the most efficient one should be displayed in the dashboard style.

Any support would be helpful

I want a gauge doughnut chart developed