Change drill path or legend

user063141
user063141 Member
in Charting

I have a scatter plot that has 400 individual 'units' each with a different unique name.

I have the series set as a quadrant identifier of their progress that will classify them by colors.

So when I add a drill path I will click on individual dot and it will drill on the quadrant identifier that shows all of the unique names in that quadrant, so not on an individual level.

Is there a way to have it drill on that unique name while still showing that quadrant as the legend and coloring the dots?

I have tried putting the unique name in the series and having a color rule based on quadrant identifier but the color rule only seems to work when I have that quadrant identifier in the series spot.

Any ideas?

Thank you, hopefully this made sense.

Answers

  • ArborRose
    ArborRose Coach

    Yes, it seems possible. But it requires configuration.

    • Keep Quadrant Identifier in the Series (Top-Level Chart):
      • Make sure the "quadrant identifier" is used in the series field to maintain the color-coded legend for the quadrants in the scatter plot.
    • Use Unique Name as the Drill Key:
      • Set the drill path so that clicking a dot drills into the unique name rather than the quadrant.
      • In Domo, you can configure the drill path by specifying a lower-level view or dataset detail that breaks out data by the unique name.
    • Preserve Quadrant Colors in Drill Path:
      • If the drill-down view still needs to show quadrant-based colors:
        • Include the "quadrant identifier" in the drill path dataset.
        • Apply the same color rules to the drill path scatter plot as in the top-level chart.


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

Categories