Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
How do I use Age function in Set Analysis?
Age([END DATE],[START DATE])
How do I add Set Analysis condition on this? Like calculate age for Concept=A
Hi,
with age function you cannot use set analysis but you can use sum on top of it to filter data then apply age function like :
sum({$<Concept={'A'}>} Age([END DATE],[START DATE]))
so when you use it with dimension it will work accordingly.
hope this helps.
Regards,
Hi,
with age function you cannot use set analysis but you can use sum on top of it to filter data then apply age function like :
sum({$<Concept={'A'}>} Age([END DATE],[START DATE]))
so when you use it with dimension it will work accordingly.
hope this helps.
Regards,
Thanks @usamabinsadiq