topic Re: Horseshoe visualisation - Complex Logic in Dashboards & Visualizations

Horseshoe visualisation - Complex Logic

RobertEttinger8 — Thu, 25 Mar 2021 12:45:22 GMT

Hi,

I've been struggling with the horseshoe visualisation for a couple days. I have a specific scenario I would like to present but not sure if this can be done:

I have a table with 2 rows and 3 fields per row: source, count, status. Example:

source,count,status

sourceA,200,0(not breached)

sourceB,100,0(not breached)

sourceC, 100,1(breached)

I would like to show a horseshoe per source (trellis) where the dial shows the count but the color is based on the status. So, for instance, sources B and C would be similar looking (count-wise) but the color would be different as one is breached and the other one is not...

Is that possible? I've seen some posts about showing a different value as a token, but this doesn't work because 1-I need to work with multiple sources and 2-Each row may have its own threshold....

Thanks! 🙂

Re: Horseshoe visualisation - Complex Logic

tscroggins — Sun, 28 Mar 2021 16:29:57 GMT

@RobertEttinger8

Are you using the built-in radial gauge or the custom horseshoe meter?

The horseshoe meter trellis option splits by aggregation (column), so your results should include one event with one field per value:

Re: Horseshoe visualisation - Complex Logic

RobertEttinger8 — Mon, 29 Mar 2021 05:56:31 GMT

Hi,

I was talking about the horseshoe meter...

The challenge comes when trying to apply different thresholds per horseshoe when using trellis and to display a value but the color of the threshold is based on another field... I actually found a visualization that allows this, the "Display Number Viz". It is a game changer for me 🙂

Thanks,