cancel
Showing results for 
Search instead for 
Did you mean: 

People Analytics - 'group by' functionality

Brandyn_Richmon
Participant
0 Kudos

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 

 

Accepted Solutions (0)

Answers (1)

Answers (1)

bellakong
Participant

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
Active Contributor
0 Kudos
was going to recommend Bella's exact solution.