Total Months are not appeared once cleared!

[nevilledhamsiri]

Dear Our Experts!

I have loaded data relating to (MAY,JUN,JULY,AUG,SEP & OCT) but what is appeared in the table except part of JUL & no data for  AUG,SEP & OCT. But if I select those Months individually using list box for Months, it is appeared. Can some one explain me the reason for that. I may present the excel too.

Thanks

Neville

Date/Month(As per the Plan)	Person assigned for Visit	Branch to be visited	Ammended_Plan	Person visited	Branch visited
18-May-17	Neville	Embilipitiya	25-May-17	Neville	Embilipitiya
19-May-17	Neville	Kahawatta	19-May-17
30-May-17	Neville	Godakawela	25-May-17	Neville	Godakawela
30-May-17	Neville	Pallebedda	25-May-17	Neville	Pallebedda
17-May-17	Vernon	Thanamalwila	18-May-17	Vernon	Thanamalwila
23-May-17	Vernon	Kalawana	23-May-17
19-May-17	Vernon	Pelmadulla	19-May-17
22-May-17	Mahesh	Eheliyagoda	19-May-17	Mahesh	Eheliyagoda
25-May-17	Mahesh	Kiriella	19-May-17	Mahesh	Kiriella
22-May-17	Mahesh	Kuruwita	19-May-17	Mahesh	Kuruwita
26-May-17	Iresha	Middeniya	23-May-17	Iresha	Middeniya
26-May-17	Iresha	Angunakolapelessa	23-May-17	Iresha	Angunakolapelessa
30-May-17	Iresha	Balangoda
20-Jun-17	Neville	Kiriella	29-Jun-17	Neville	Kiriella
22-Jun-17	Neville	Kalawana	26-Jun-17	Neville	Kalawana
28-Jun-17	Neville	Pelmadulla	27-Jun-17	Neville	Pelmadulla
28-Jun-17	Neville	Balangoda	27-Jun-17	Neville	Balangoda
23-Jun-17	Vernon	Embilipitiya	26-Jun-17	Vernon	Embilipitiya
19-Jun-17	Vernon	Angunakolapelessa	20-Jun-17	Vernon	Angunakolapelessa
19-Jun-17	Vernon	Godakawela	26-Jun-17	Vernon	Godakawela
21-Jun-17	Mahesh	Middeniya	27-Jun-17	Mahesh	Middeniya
26-Jun-17	Mahesh	Kahawatta	23-Jun-17	Mahesh	Kahawatta
21-Jun-17	Mahesh	Pallebedda	23-Jun-17	Mahesh	Pallebedda
22-Jun-17	Iresha	Eheliyagoda	22-Jun-17	Iresha	Eheliyagoda
22-Jun-17	Iresha	Kuruwita	22-Jun-17	Iresha	Kuruwita
27-Jun-17	Iresha	Thanamalwilla	27-Jun-17	Iresha	Thanamalwilla
21-Jul-17	Neville	Eheliyagoda	21-Jul-17	Neville	Eheliyagoda
19-Jul-17	Neville	Kiriella	19-Jul-17	Neville	Kiriella
21-Jul-17	Neville	Kuruwita	21-Jul-17	Neville	Kuruwita
27-Jul-17	Neville	Thanamalwila	28-Jul-17		Thanamalwila
21-Jul-17	Vernon	Middeniya	27-Jul-17	Vernon	Middeniya
19-Jul-17	Vernon	Angunakolapeless	27-Jul-17	Vernon	Angunakolapeless
19-Jul-17	Vernon	Godakawela	26-Jul-17	Vernon	Godakawela
20-Jul-17	Mahesh	Kalawana	20-Jul-17	Mahesh	Kalawana
28-Jul-17	Mahesh	Pelmadulla	28-Jul-17	Mahesh	Pelmadulla
28-Jul-17	Mahesh	Balangoda	28-Jul-17	Mahesh	Balangoda
24-Jul-17	Iresha	Embilipitiya	24-Jul-17	Iresha	Embilipitiya
26-Jul-17	Iresha	Kahawatta	21-Jul-17	Iresha	Kahawatta
21-Jul-17	Iresha	Pallebedda	21-Jul-17	Iresha	Pallebedda
22-Aug-17	Neville	Thanamalwila	25-Aug-17	Neville	Thanamalwila
18-Aug-17	Neville	Kalawana	18-Aug-17	Neville	Kalawana
25-Aug-17	Neville	Pelmadulla	22-Aug-17	Neville	Pelmadulla
25-Aug-17	Neville	Balangoda	22-Aug-17	Neville	Balangoda
24-Aug-17	Vernon	Embilipitiya	24-Aug-17	Vernon	Embilipitiya
21-Aug-17	Vernon	Middeniya	21-Aug-17	Vernon	Middeniya
21-Aug-17	Vernon	Pallebedda	21-Aug-17	Vernon	Pallebedda
17-Aug-17	Mahesh	Eheliyagoda	17-Aug-17	Mahesh	Eheliyagoda
23-Aug-17	Mahesh	Kiriella	23-Aug-17	Mahesh	Kiriella
17-Aug-17	Mahesh	Kuruwita	17-Aug-17	Mahesh	Kuruwita
30-Aug-17	Iresha	Angunakolapelessa	29-Aug-17	Iresha	Angunakolapelessa
16-Aug-17	Iresha	Kahawatta	16-Aug-17	Iresha	Kahawatta
30-Aug-17	Iresha	Godakawela	16-Aug-17	Iresha	Godakawela
27-Sep-17	Neville	Embilipitiya	25-Sep-17	Neville	Embilipitiya
21-Sep-17	Neville	Middeniya	25-Sep-17	Neville	Middeniya
19-Sep-17	Neville	Thanamalwila	19-Sep-17	Neville	Thanamalwila
21-Sep-17	Neville	Pallebedda	19-Sep-17	Neville	Pallebedda
26-Sep-17	Vernon	Kalawana	26-Sep-17	Vernon	Kalawana
20-Sep-17	Vernon	Pelmadulla	20-Sep-17	Vernon	Pelmadulla
20-Sep-17	Vernon	Balangoda	20-Sep-17	Vernon	Balangoda
29-Sep-17	Mahesh	Angunakolapelessa	27-Sep-17	Mahesh	Angunakolapelessa
19-Sep-17	Mahesh	Kahawatta	19-Sep-17	Mahesh	Kahawatta
21-Sep-17	Mahesh	Godakawela	27-Sep-17	Mahesh	Godakawela
25-Sep-17	Iresha	Eheliyagoda	26-Sep-17	Iresha	Eheliyagoda
21-Sep-17	Iresha	Kiriella	26-Sep-17	Iresha	Kiriella
25-Sep-17	Iresha	Kuruwita	26-Sep-17	Iresha	Kuruwita
25-Oct-17	Mahesh	Eheliyagoda	25-Oct-17	Mahesh	Eheliyagoda
25-Oct-17	Mahesh	Kuruwita	25-Oct-17	Mahesh	Kuruwita
27-Oct-17	Vernon	Embilipitiya	27-Oct-17	Vernon	Embilipitiya
19-Oct-17	Vernon	Middeniya	19-Oct-17	Vernon	Middeniya
25-Oct-17	Vernon	Thanamalwila	25-Oct-17	Vernon	Thanamalwila
20-Oct-17	Iresha	Angunakolapelessa	20-Oct-17	Iresha	Angunakolapelessa
17-Oct-17	Iresha	Kahawatta	17-Oct-17	Iresha	Kahawatta
26-Oct-17	Neville	Kalawana	24-Oct-17	Neville	Kalawana
20-Oct-17	Neville	Pelmadulla	20-Oct-17	Neville	Pelmadulla
20-Oct-17	Iresha	Godakawela	17-Oct-17	Iresha	Godakawela
27-Oct-17	Mahesh	Pallebedda	27-Oct-17	Mahesh	Pallebedda
20-Oct-17	Neville	Balangoda	20-Oct-17	Neville	Balangoda
19-Oct-17	Sineka	Kiriella	19-Oct-17	Sineka	Kiriella

[sunny_talwar]

Did you try to uncheck 'Suppress Zero Values' on the presentation tab of your chart properties?

[nevilledhamsiri]

Dear Sunny,

As you said when 0 values were unchecked, total Months are shown. But the two expressions I have written get the 0 values for most of the cases. But when each individual Months are selected picture is correct that too presented here. For you to check the expression too given.

SUM(AGGR(COUNT(DISTINCT([Person assigned for Visit])),[Branch to be visited],[Branch visited]))

SUM(AGGR(COUNT(DISTINCT([Person visited])),[Branch visited],[Branch to be visited]))

Thanks

[nevilledhamsiri]

Please let me know the reason as to why this happen so!

[sunny_talwar · Accepted solution]

Try this

SUM(AGGR(COUNT(DISTINCT([Person assigned for Visit])),[Branch to be visited],[Branch visited], SET_MONTH))

SUM(AGGR(COUNT(DISTINCT([Person visited])),[Branch visited],[Branch to be visited], SET_MONTH))

[nevilledhamsiri]

Thank you very much dear sunny!

Your answer worked well!. Of course it was very fine.

Neville