I'm trying to plot the following as a scatter chart: The y-axis should be the namespace. Namespace is a small set of strings, e.g. "default", "argo" or "kube-system". The x-axis is time. Each point should be coloured either green or red depending on whether or not the workflow succeeded or failed. Problem 1 - you cannot have non-numeric x and y axis. Time does not appear to be numeric. So how do I convert my namespace to a number? I think it should be 0..N based on it's index is the values that namespace can be. Problem 2 - how to colour points? This is how far I have gotten so far: index=foo sourcetype=eventrouter host="event-router-*" source="foo/*" event.involvedObject.kind=Workflow (event.reason=WorkflowSucceeded OR event.reason=WorkflowFailed) | convert num(_time) as x | table event.metadata.namespace x event.reason   ... View more