Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi i have the below line chart which shows the % female and Male
the data is wrong when no date is selected , however when I select a date form the x axis i.e Feb 2021 in this example the data is correct and there is a huge difference. Can anyone help please?
My expression is :
Count(distinct(id))/
Count(distinct TOTAL(id))
It is because your denominator is counting distinct IDs across all months. Try the following:
Count(distinct(id))/
Count(distinct TOTAL <Month> (id))