@yosiasz Thank you so much for your reply and I have solved the issue with the help of your reply above.
I want to also apologize for not being able to provide any data since the data sits on an API repository that I access with authentication. Anyways, now to the solution.
Since I am using infinity as a data source to hit the API, I have selected the data I want to gather. In this case, the type (form type) of endpoints and I needed to get a total count. I tried to use transformations to get the count, but I was not able to get a correct count.
Turns out that I need to have an empty string as a second column in order to use transform to Group by, and then calculate a count. Once I added the second empty column I was able to easily group by and calculate.
