How to custom name data series in legend?

jblecha
jblecha βšͺ️

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.

Tagged:

Answers

  • GrantSmith
    GrantSmith Indiana πŸ”΄

    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
    MarkSnodgrass Portland, Oregon πŸ”΄

    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
    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
    GrantSmith Indiana πŸ”΄

    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