How to custom name data series in legend?

jblecha
jblecha Member
in Charting

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

image.png

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 Coach

    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.

    **Was this post helpful? Click Agree or Like below**
    **Did this solve your problem? Accept it as a solution!**
  • MarkSnodgrass
    MarkSnodgrass Coach

    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.

    **Check out my Domo Tips & Tricks Videos

    **Make sure to <3 any users posts that helped you.
    **Please mark as accepted the ones who solved your issue.
  • jblecha
    jblecha Member

    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 Coach

    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

    **Was this post helpful? Click Agree or Like below**
    **Did this solve your problem? Accept it as a solution!**

Categories