This is what i was looking for.

sum(pd_status) by (pd_location) 
  * on(pd_location) group_left(pd_RG) 
    pd_RG 
  * on(pd_location) group_left(pd_command_queuing) 
    pd_command_queuing
  * on(pd_location) group_left(pd_performance) 
    pd_performance
  * on(pd_location) group_left(pd_readahead) 
    pd_readahead
  * on(pd_location) group_left(pd_serial) 
    pd_serial
  * on(pd_location) group_left(pd_size) 
    pd_size
  * on(pd_location) group_left(pd_standby) 
    pd_standby
  * on(pd_location) group_left(pd_status) 
    pd_status
  * on(pd_location) group_left(pd_status_health) 
    pd_status_health
  * on(pd_location) group_left(pd_status_usage) 
    pd_status_usage 
  * on(pd_location) group_left(pd_type) 
    pd_type
  * on(pd_location) group_left(pd_vendor) 
    pd_vendor
  * on(pd_location) group_left(pd_write_cache) 
    pd_write_cache

Grafana query options should be like this