CountIf in BeastMode or ETL ?

user12446

Good Morning Community

I have a 5M+ row dataset where I need to develop a "COUNTIF" function based on a 'Category" column (image enclosed/table below). Any help would be appreciate

Data contains too many distinct categories to list individually in beast-mode by name - kindly assist. 

 

 

 

Date	Price	Category	Report	COUNTIF GOAL
2019-Feb	10,000.00	Type 89	Report 32	5
2019-Feb	10,000.00	Type 89	Report 107	5
2019-Feb	10,000.00	Type 89	Report 17	5
2019-Feb	10,000.00	Type 89	Report 53	5
2019-Feb	10,000.00	Type 89	Report 19	5

 

 

 

Unknown

Just to clarify,  Are you looking to check the Unique no. of reports under each category against the goal of 5?

user12446

No, the goal is not dependent on unique report names - only the number of times the category (i.e. Type 89) occurs in the column. 

Unknown

Try this beast mode:

COUNT(DISTINCT category) 

 

This will give you a count of unique categories.

user12446

tried this, the result shows row data only not the column data. i.e. Goal = 1 not 5 

Randyb

Its most likely doing that because of the report component which is different it appears on each row.

If you sum the count(Distinct) it should give you the value of 5 that your looking for.

If I'm interpreting this correctly.

Randy