Dashboard Creation error while trying to monitor active Processes

[AnimeshDT]

I am creating a dashboard to monitor Processes running on VSI servers. These processes are grouped as the same bunch runs on all servers. I am trying to use builtin:pgi.availability.state as metric in table, but the problem is when a process goes down, the process availability still shows the value for that process as 1 and available, it also creates a new row which shows process as unavailable but the value is still 1. I just want to create a table which shows all my process names, their respective hostnames and if the process is up then either it should show as "Available or 1" and if it is down then it should show "unavailable or 0". 1 Row for each process only. I have tried everything I understand but the down process never shows value as 0.

Can someone kindly guide me with this?

[p_devulapalli]

@AnimeshDT Not sure you are on Managed or SaaS , if on SaaS you can try the below DQL as an alternate approach for process availability 

timeseries m1 = sum(dt.process.availability, rollup: sum) ,
filter: { matchesValue(host.name, "hostxyz") },
by: {
  availability.state,
  dt.entity.process_group_instance,
  host.name
}
| fieldsAdd intervalToMinutes = toLong(interval) / 60000000000
| fieldsAdd m1 = if(m1[]>intervalToMinutes, intervalToMinutes, else: m1[])
| fieldsAdd m1 = (m1[] / intervalToMinutes) * 100
| fields host.name,
         dt.entity.process_group_instance.name = entityName(dt.entity.process_group_instance),
         Availability = arrayAvg(m1)