Month wise count mismatch

[yoganantha321]

hi,

I have master calendar showing year, month and date.

If I select 2017 and feb it is showing as below chart:

               chart-1

total count must be:117 only but it is showing for 194.

If I select 2017 and feb with particular date means it is showing correct count as given below:

eg:01/02/2017

                    chart-2

It is showing the correct count for 98.

Can any one help me how to achieve the correct count for monthly wise also..........

regards,

Yoganantha Prakash G.P

[sunny_talwar]

Would you be able to share your app? or at least the expression you are using?

[yoganantha321]

I have used dimension as Allocation level(Which have all the above three for day wise) thirty count for each employee per month

and

Expression as (Count (distinct Employee))

[sunny_talwar]

I think distinct might be the reason behind the issue... distinct is evaluated based on the dimension. If you have a single employee number falling under two categories, it will be double counted here.

[Anil_Babu_Samineni]

May be whole February has that much total in your data set. If you select particular data it may have 98 only. Can you recheck with Text box by using same Expression and selection

Or

Try for Chart-1 expression by using date = {'01/02/2017'}

[yoganantha321]

how can I separate it can you give any suggestion Sunny......

[sunny_talwar]

For instance

FieldName, Date, EmployeeNumber

Occupied, 02/01/2017, 100

Available, 02/02/2017, 100

When you select 02/01/2017, Employee number 100 will show in only one bucket, but if you select Feb 2017, then he will be within Occupied and Available

[sunny_talwar]

Look at my example below... which category will employee number 100 fall into? Occupied or Available?

[yoganantha321]

Anil,

day wise means count showing correctly count for feb 1 is 98.

But month wise count means it should be 117 but it is wrong count showing that is my problem.

[Anil_Babu_Samineni]

Would you able to share sample please