figueiredo.lucas779 Posted December 1, 2022 Posted December 1, 2022 My report exhibits the total rows existing in a group, like the example belowNAME | CLIENT_ID | PRODUCT |john | 100 | spoon |--------------------------------------------mary | 111 | dress |-------------------------------------------john | 100 | pan |-------------------------------------------Total Rows: 3How can i count only once the rows with the same id and display it in the report? example belowNAME | CLIENT_ID | PRODUCT |john | 100 | spoon |--------------------------------------------mary | 111 | dress |-------------------------------------------john | 100 | pan |-------------------------------------------Total Rows: 2
Solution jgust Posted December 1, 2022 Solution Posted December 1, 2022 Create a variable with a class type of integer and a "Distinct Count" calculation.In the expression add the field you would like a distinct count of.Finally, create a text field on the canvas to display the value of the expression.
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now