People Analytics - 'group by' functionality

[Brandyn_Richmon]

Does anyone know if Stories for People Analytics supports 'group by' functionality? 

EXAMPLE

US Cities (group 1😞 Denver, Seattle, Detroit, Chicago

Non-US Cities (group 2😞 Paris, Rome, Tokyo

We would like to group them and create charts/graphs based upon the two groups (not 7 cities). This possible in a view in SAP Analytics Cloud ... but not sure how to handle in Stories for People Analytics.

Any help is appreciated.

Thanks,

Brandyn 

[bellakong]

Hello, 

There is no direct function in story as Group by. However based on the request, I think you can create a calculated column in query to mark out each record if it is US or Non-US.

Then just apply the Dimension in the chart and add needed measures in story report. So it will present 2 labels (US and Non US) what the measure for each labels. 

Hope it may help. 

Bella

[ChrisPaine]

was going to recommend Bella's exact solution.