Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
HI,
I have an Aggr count expression which is giving me a wrong number due to duplications being created by a related field.
i have tried the below after some reading.
aggr(Count (total {<Standards =- {'Non-Applicable Standards'}, portal_order_no=>} standard_name),parent_name)
There are multiple portal_order_no for each standard name so i wish to ignore portal_order_no data in the count.
Please can anyone give some advise on how this can be achieved?
thank you
Daniel
@davyqliks Could you please give me some sample data and expected results?
Thank for the reply,
I have exported the table to excel to access the situation on a smaller scale.
in the below i need to count the Standard names(not including the ticks) and only one per production facilty.
So the count should be 5 on a single line where as i am getting 10.
Looking at the below i do not need to ignore the portal order number, however i cannot get the number i need.
Thank you for your help in advance.
Hi experts,
Is anyone able to assist, i am going round in circles trying to get t he correct result. From the image previously attached i need to achieve a count total on a single line of 5 and i can only get 10 based on the below expression:
aggr(
Count ({<Standards =- {'Non-Applicable Standards'}>} standard_name),parent_name)
I did manage to get the desired 5 by using the following however, this was on every line, and when i unfiltered the total count for all was on every line.
Thank you in advance if anyone is able to assist,
Daniel