Value from last column with this condition

[Jonathan_S]

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

[JuneCorpuz]

Jonathan_S:

([_THISROW].[uuid] = Context("Device"))

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

[LeventK · Accepted solution]

Jonathan_S:

Whenever I “Test” the expression it comes up blank

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.

[Jonathan_S]

Thank you :),

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

@Steve Could you put this in the docs?

[Steve]

Jonathan_S:

Could you put this in the docs?

Done.