Wrong data is shown on line chart when no date is selecte

ishafate — Tue, 28 Feb 2023 16:04:56 GMT

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))

Re: Wrong data is shown on line chart when no date is selecte

BenjaminT — Thu, 02 Mar 2023 15:58:10 GMT

It is because your denominator is counting distinct IDs across all months. Try the following:

Count(distinct(id))/
Count(distinct TOTAL <Month> (id))

topic Wrong data is shown on line chart when no date is selecte in App Development

Wrong data is shown on line chart when no date is selecte

Re: Wrong data is shown on line chart when no date is selecte