Hey there,
I am relatively new at SAP Analytics Cloud and I'm currently struggling with the following use case in Stories. I’ve also searched a bit for answers of my question, but now I’m even more confused.
So hopefully I can get any help from you guys:
In one of my data sets, I’ve got a birthday dimension. So, how is it possible to calculate the age for every single person out of „birthday“ and the actual date, when „birthday“ is mapped as type „dimension“ and not as type „date“?
Therefor the date is stored in DD/MM/YYYY format. I did a direct excel file import, which was generated by SAP BW before.
Additionally, is there any possibility to cluster all of calculated ages into different age groups simultaneously?
Thank you in advance for your help. It would be great if you can provide me some ideas.
Have a nice day and all the best
Albrecht