Design studio bar chart - Age split

[vishal_p3]

Hello Experts,

I have a requirement as per the data shown in the table and would require a bar chart when I select a Department as shown below in SAP Design studio 1.6, as we have the fields "20-29, 30-39, 40-49, 50-59, 60-69" extracted through the field "Date of birth" in BEx query. I am not able to depict the graph and please help me.

[TammyPowlas]

Lumira Discovery has the grouping feature; have you tried that?

I would try the grouping/binning back in BEx or the BW model. If not the application will be slow.

Another idea is to use Analysis Office and use the grouping feature there and then use that as a data source to Design Studio

I believe 1.6 Design Studio will be out of maintenance soon; please consider upgrading to Lumira Designer 2.x

Good luck