area visualisation 'group by' not showing

[BryanM]

Hi,

I'm new to databricks, and I'm trying to create an area plot in a visualisation, the only problem is that I do not see the 'group' otion in the y axis section.  I see 'Color' but that is all, not 'group by' option (I'm expecting to see 'Color/Group by' Have I got a setting wrong?

TIA

Bryan

[lingareddy_Alva]

Hi @BryanM 

Use "Color by Y-Series" for Grouping
In Databricks, the "Color by Y-Series" section IS your grouping mechanism for area charts:

Add your grouping dimension (the field you want to group by) to the "Color by Y-Series" section
This will create separate colored areas for each group
Each group will be stacked in the area chart

Check Your Data:
Make sure your underlying query returns the grouping field. You can verify by:
1. Running your query in the SQL editor first
2. Ensuring the grouping column appears in the results
3. Then configuring the visualization

The key insight for Databricks is that "Color by Y-Series" is your grouping mechanism - it's not called "Group by" but
functions the same way by creating separate colored series for each distinct value in that field.

[BryanM]

HI,

Thanks for the response.  I get what you are saying, but that goes against what is in the documentation.  I  was assuming (again based on the documentation) that I could specify a column to group on, and the values I want to use and then assign the colors.  I'll check the data, but what I am seeing is not what is in the documentation.

Bryan

Documentation