Get new metric calculated AFTER aggregation[ Edited ]
June - last edited June
Let's say I have a data source like this :
date | gender | number
2017/06/21 | Male | 3456
2017/06/21 | Female | 2481
2017/06/22 | Male | 1672
2017/06/22 | Female | 1293
I would like to plot the ratio # of males / # of females.
According to me, it is currently impossible to create a new metric based on that.
My feeling is that calculated metrics are only possible on the same "line" of data, as they are calculated BEFORE the aggregation happens... I am wrong?
Get new metric calculated AFTER aggregation
you are right, what you can do though, is add a column in your data source, with total = male +female
then you can get your ratio.
for me this is the biggest limitation of GDS, the calculated field formula is very very limited compared to the like of PowerBI and Qlik, I hope they are working on that. a simple sum_total function will make a huge difference.