Chart shows values for 2 dates

[xarapre7]

Hi QV experts!

I have been asked to get record  for Service which should have either the start date or completion date data.  As you can see below, there are 2 for SR ID 7001231900 for start date (201502) and completed date (201601).  But this should only show value for start date so that it should only have a bar chart with a value of 1. 

This is the expression i used for this chart.

=Num(Count({$<[Service Request Start Date]>}  DISTINCT [Service Request ID]),'#,##0') but still shows both values from 2015, 2016.

How can i make it to show just the value for start date?  Thanks in advance for your assistance.

[Anil_Babu_Samineni]

Perhaps this?

If(GetFieldSelections([Service Request Start Date]) >1, Num(Count({$<[Service Request Start Date], CREATED_YEARMO = {'$(=Max(CREATED_YEARMO))'}>}  DISTINCT [Service Request ID]),'#,##0'), Num(Count({$<[Service Request Start Date]>}  DISTINCT [Service Request ID]),'#,##0'))

[xarapre7]

Thank you for your reply Anil.  I tried it but it didn't work.  I'm still getting the same as above result.

[Anil_Babu_Samineni]

Will you able to provide mockup file to test?

[xarapre7]

How can i attach the file in here?

[xarapre7]

Here is the file.  You'll see that the chart has multiple values for the yearmo but i only need to display the value for the startdate. Thanks for your help.

[pradosh_thakur]

hi

pfa

regards

Pradosh

[xarapre7]

sorry but what do you mean by pfa?

[pradosh_thakur]

please find the attached

:d

[xarapre7]

Thank you for your help!  It worked.