Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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'))
Thank you for your reply Anil. I tried it but it didn't work. I'm still getting the same as above result.
Will you able to provide mockup file to test?
How can i attach the file in here?
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.
hi
pfa
regards
Pradosh
sorry but what do you mean by pfa?
please find the attached
:d
Thank you for your help! It worked.