How to custom name data series in legend?

jblecha · 2021-07-20T19:00:05+00:00

There was an error rendering this rich post.

I'm looking to name each series its own custom label, take a look:

So for example, I want to change the top label to "Point - Tree - Batch", the second label to "Point - Tree - Manual", the third to "Linear - Curb and gutter - Manual", and so on... a custom label for each of the eight series.

Can anyone help?

Thank you.

Find more posts tagged with

Charting

Accepted answers

All comments

GrantSmith

Hi @jblecha

You can utilize a beast mode conditionally set the value and use that as your series.

CASE WHEN `field` =  {"MODE":"Auto","Rule":"Tree"} THEN 'Point - Tree - Batch'
WHEN `field` = ...
...
END

Alternatively you could parse your field values in an ETL or you could have a separate dataset with two columns, one for the original value and another for a human readable format and then join that to your original dataset and use the human readable field as the series.

MarkSnodgrass

You can do this by creating a beast mode that would rename your fields and then drag that field into your series. Your beast mode would look something like this:

CASE WHEN 'fieldname' = '{"Mode":"Auto","Rule";"Tree"}' THEN 'Point - Tree - Batch'

WHEN 'fieldname' = '{"Mode":"Manual","Rule";"Tree"}' THEN 'Point - Tree - Manual'

END

Keep adding WHEN statements for each one you want to rename.

jblecha

thank you both @GrantSmith and @MarkSnodgrass, makes sense.

I've built out the syntax for each of my eight different series in Beast Mode, but do I apply to the Data Table itself or the within the card via the Analyzer? Where in the Analyzer?

I'm sorry for the basic questions here - marketing guy in over his head!

Thank you!

GrantSmith

You can create a beast mode in analyzer. On the bottom right there should be a button that says Add calculated field. It will also give you the option to save the beast mode to your dataset which will make that same calculation available for other cards you make with the same data set