Generating data in Bar chart or backend

[hitha1512]

Hi Team,

I am calculating availability of Devices. On selecting one device i get the below data. Is there a way i can populate 100%  for months this device has no data on ? provided my entire data set starts from June 2022.

June - 100% , July - 93.03% (as displayed below), August- 100% , Sep - 100% and so on 

[edwin]

this means there are no records associated to the selected dates.  you can force a measure ignoring the device.  

if(count(Device)=0, sum({<Device=>}1), sum(Measure))

if Device is the selected device, and sum(Measure) is your expression.  this means if there are no devices for the month, return sum(1) ignoring selected Device, else - normal expression