topic Re: area visualisation 'group by' not showing in Warehousing & Analytics

area visualisation 'group by' not showing

BryanM — Thu, 05 Jun 2025 19:37:03 GMT

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

Re: area visualisation 'group by' not showing

lingareddy_Alva — Thu, 05 Jun 2025 20:02:11 GMT

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.

Re: area visualisation 'group by' not showing

BryanM — Thu, 05 Jun 2025 21:14:24 GMT

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