I'm perplexed on how to do something that should be easy and hoping that someone can point me in the right direction.
I'm building a dashboard and want to have a box on it that pulls the last text value and displays it. The results will either be 'true' or 'false' and is stored in one of my indexes. I would also like to have said box change red when this value is 'true' and blue when 'false'.
I am able to do this if the field contains a value but can't seem to figure out a way to do this with text fields but seems like it should be easy.
I might be able to do this with Canvas but that would mean migrating my current dashboards over to that format.
Any ideas on how I can approach this? Markdown/Metric seems like the way to go but not sure on how to query an index for the last value using it.
Timelion might work as well but that function is unusable since my last upgrade (see attached).