Hi there,
My requirement is we have 8882 meters, from them some meters will not respond the total meters responded in particular day(i.e from 8882 meters 5785 meters only responded today on 12-12-2019) on field and for every half-n- hour they will send data. but i want only unique service no count i.e COUNTD(serviceno) on applying power factor rating on that particular day. the count should be divided by the total no of meters responded. I'm attaching screenshot's as well.
Based on responded meters only power factor rating has to be divided
In power factor Rating sheet which was showing was wrong.even i had applied
the below calculation for power factor
{ FIXED [Service No]:MAX(
IF [Interval TimeStamp]={ FIXED [Service No]:MAX([Interval TimeStamp])} THEN [Power Factor]
END
)
}
and
for time stamp
{ FIXED [Service No]:MAX(
IF [Interval TimeStamp]={ FIXED [Service No]:MAX([Interval TimeStamp])} THEN [Interval TimeStamp]
END
)
}
please help or suggest some calculation.
thankyou,
surya
Hi,
While using LOD{} you've to aggregate your measure. You can use any aggregate function as per your requirement in the expression{}. Modify the logic as per below screenshot and check.
Let us know if this help else It'd be helpful if you share your expected output in a screenshot.
Mahfooj
