Not sure how new but this is the high level. If you need more details let me know
- Create a custom group for each folder and use the folder name in the membership rules.
- Create a supermetric sum(${adaptertype=VMWARE, objecttype=VirtualMachine, metric=cpu|usagemhz_average, depth=1})
- enable the SM in your policy and wait 5-10 mins
- Create your dashboard with the groups in the object list and add a metric chart and select the SM
- set up the widget interactions and you should be good to go
If you are 6.6.1 or lower you will need to create a metric config for the chart with the SM in it.
Also if you want to convert to GHz from MHz add /1000 after the last bracket in the SM