Without having all the machine's data, none of application cannot recognize total og number of machine A.
Data does not need to have down time for A3 and A4, but still need to have record of A3 and A4 like below.
Machne Name Machine ID Down Time A 1 2 A 2 1 A 3 A 4 B 1 3 B 2 4
With above data,
avail%_SM_10.5.twbx 14.3 KB
Hung Nguyen This is a common pitfall and can easily be resolved.
Tableau isn't currently calculating Avail % for those values since the value are empty. They are considered as system NULLS and thus cannot return any result in a calculation.
You can create an intermediate field that imputes zero wherever downtime is unavailable and use it instead of actual downtime in your calculations
Use the following
Hope this helps,