Value from last column with this condition

Good Day All,

Looking for some help with an expression problem that I got from steves wonderful post here.

Im looking to get the latest value a user from the same device has selected.

See expression

LOOKUP(
  MAX(
    SELECT(
      Viewing Production Lines[_ROWNUMBER],
      ([_THISROW].[uuid] = Context("Device"))
    )
  ),
  "Viewing PRoduction Lines",
  "_ROWNUMBER",
  "Production Line"
)

See table.

Whenever I “Test” the expression it comes up blank

This is the culprit why you are getting a blank result.

3 Likes

When tested from the editor CONTEXT("Device") always returns a value of expression-assistant-device-id. I believe there won’t be any rows matching this record, so it returns a blank value. As such, CONTEXT("Host") - when tested in the editor - always returns the value of Server.

3 Likes

Thank you :),

Next time I should just proceed to the next step, its all working.Thanks.

@Steve Could you put this in the docs?

Done.

3 Likes