Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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