Forum Discussion
JamesBurke
1 year agoHelper III
Missing Data
Hi All , I have Two tables One is a date table with records to todays date which updates every day. I also havce a data table which has 5 Meters that measure solar production. I have made t...
Kedar_Pande
1 year agoSuper User
create a calculated column:
Meter Connection Status =
IF(
[Days Missed] >= 1,
"Not Connected",
"Connected"
)
Legend: Meter Name (groups) (Ensure this is a categorical field)
Value: A calculated column (Meter Connection Status)
π If this helped, a Kudos π or Solution mark would be great! π
Cheers,
Kedar
Connect on LinkedIn