Date count of year not coming after bypass the month

[#1]

Hello Everyone,

i have one table, dimension is Month and Measure is count of days, i need to get total date count for the year (that is 365), for each month

i am using the below expression, still it is showing the month wise count only

(count({<Month=>}DATE))

the result i am getting is below:

The expected result is below

any suggestions please where i am doing mistake

Thanks in advance

[Gysbert_Wassenaar · Accepted solution]

count(total DATE)

[#3]

Thanks Gysbert, it is working fine

[senpradip007]

Use this Count({<Month>} TOTAL Date)

[#5]

Hi Sreeharsha,

by using the dimension in your chart, your expression will still evaluate over it even with the set analysis you have.

You should be able to use Count(TOTAL Date) instead for this

hope that helps

Joe