How to ignore a dimension in an Aggr(count)

[davyqliks]

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

[sidhiq91]

@davyqliks  Could you please give me some sample data and expected results?

[davyqliks]

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.

[davyqliks]

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