Forum Discussion
Relative age?
grggmrtn ok so just so that i understand what you asking
you want to take the year (sales year?) and work out how old they were in that year?
This is what I'm going for - just with "age group" instead of what's currently there.
grggmrtn apologies but im struggling to understand what you looking for, surely it should be easy to get the age of the current year with a count? i dont quiet understand your challenge apologies if i am understanding you incorrectly
can you demonstrate what you expecting your visual to look like
vanessafvgI understand it's a bit complicated, sorry 🙂
I'm looking for a visualsation just like the one you show there, except that I need it to be a clustered column chart, with the year as axis.
So in the chart I've attached here, the x-axis is the year and age group, and the y-axis is the number of people. Same number of total people for each year, but of course they're all two years younger in 2018 than now, so the age group distribution will be different.
Is that making any more sense?
grggmrtn ok I get it, but the question is where is the relative date sitting, is that from the slicer? how does the relative date relate to the person? You obviously need to calculate it based on the relative year. But what is that relative year based on in your date? the date in dim date that is linked to your factless fact?