Monthly trended view wrong

[Anonymous]

Hi friends,

I have 2 charts:

left chart - shows total

right chart -shows by months (trend)

It works well when it's full months.

But when I select some days in May 23- May 31, my trended chart is wrong.

How can it fix?

Thanks,

[Gysbert_Wassenaar]

Using the same expression in both charts would help. You now have different expressions, so you get different results.

[Anonymous]

When I use expression from left chart (it shows total respondents)

it's completely wrong results

individual counts/ total count for whole periods

I need individual counts/ count total by Months or Date

I dont know how to set up trended chart depended of calendar

[jerem1234]

How exactly is it wrong? Your column is for the whole month of May, when you select the days, you are only selecting part of May (May 23- May 31).

Can you explain a little more of why the values are wrong, and what values you are expecting?

Maybe you want to just get the MYear from the dates like:

Count({<oDate=, MYear = p(MYear)>}[qID_15863_Purpose of Visit])

/ Count(ALL<MYear>[qID_15863_Purpose of Visit])

Hope this helps!

[Anonymous]

I wanted to have the same results as left chart

May 23-31 selected days, total count for these days -134, but for whole month- 181

I think I got it

Count([qID_15863_Purpose of Visit])/

Count(TOTAL<MYear,oDate>[qID_15863_Purpose of Visit])

[Anonymous · Accepted solution]

it's final version for my purpose

Count([qID_15863_Purpose of Visit])/

Count({<[qID_15863_Purpose of Visit]=>}TOTAL<MYear,oDate>[qID_15863_Purpose of Visit])