Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have a table as shown in the screenshot below .. If you look at the Defects column the total being displayed is 962 .
and the defects are displayed as 2, 2 .where as all of them should be 1.1.1.1 they are showing double and this is the reason the total of 962 is summed up where as it should count the total ID's which 481...
Do I need to change anything in my expression to make it appear unique rather than double?
Please help me in resolving this issue .The expression being also has count in it
count(Distinct{<Category=P(Sub_Category),
Status={'Delivered','Dispatched','On Way'},
Severity{'1 - Critical','2 - High'}>} if(CREATE_DATE>DispatchedDate,ID))
+
count(Distinct{<Category={'null'},
Status={'Delivered','Dispatched','On Way'},
Severity{'1 - Critical','2 - High'}>} if(CREATE_DATE>DispatchedDate,ID)))
Thanks in Advance
Hi Expertise
any help on my post ?
Thanks
@smilingjohn is it possible to provide some sample data for us to work upon?
Thanks for the reply Sidhiq
Sorry but cannot post the data ... I have the expression which I have posted.
Thanks
Hi All,
Tried all the options that I know but no luck ....