topic Re: Counting Feature in Connectivity & Data Prep

Counting Feature

Ishilad — Thu, 04 Apr 2019 15:44:19 GMT

Hi I have a quick question.

I am currently working on a sheet with a series of projects listed. Each project has a number of people working on it. I have the project names and the people who are working on them as Dimensions on a pivot table. I need to add a column that allows me to count how many people there are working per project. I tried using the aggr() function, if statements, in addition to a few other features. I cannot seem to figure out how to do this.

Re: Counting Feature

dplr-rn — Thu, 04 Apr 2019 16:22:03 GMT

can you give a sample of output you need?

shot in the dark did you try Total<People>

Re: Counting Feature

Ishilad — Thu, 04 Apr 2019 16:29:22 GMT

Sure. I attached a photo of a sample I created. Shown are the Projects and next to it are the names of the people on each project. I need something that will count that there are 2 people in the first project or five people in the second project.

Re: Counting Feature

dplr-rn — Thu, 04 Apr 2019 16:31:47 GMT

Columns are Just project and number of resources?

Re: Counting Feature

Ishilad — Thu, 04 Apr 2019 16:32:49 GMT

The columns are Project Name, Total Hours spent on each project, and name of resource

Re: Counting Feature

dplr-rn — Thu, 04 Apr 2019 16:34:03 GMT

wheres the count?

Re: Counting Feature

Ishilad — Thu, 04 Apr 2019 16:35:31 GMT

The highlighted cells are what I need. I don't have a count of how many people are working per project. That is what I am having trouble with

Re: Counting Feature

dplr-rn — Thu, 04 Apr 2019 16:38:26 GMT

use expression Count(distinct total<Project> ResourceNameorID)

Re: Counting Feature

Ishilad — Thu, 04 Apr 2019 16:45:26 GMT

I tried that and a series of variations that involved it and the count i receive is 143 throughout the whole table. I think it is counting all of the employees and not differentiating who is on which project

Re: Counting Feature

dplr-rn — Thu, 04 Apr 2019 16:48:53 GMT

it should work. see below from a dummy sample app.

proj 1 has 2 people, proj2 has 3...

Re: Counting Feature

Ishilad — Thu, 04 Apr 2019 16:50:10 GMT

Maybe it has to do with my data then. I'll take a closer look. Thank you!

Re: Counting Feature

Ishilad — Thu, 04 Apr 2019 17:04:04 GMT

This formula works, but it also factors in the '0' values. I went into add ons and exluded values that are 0 but this does not seem to make a difference.

Re: Counting Feature

Ishilad — Thu, 04 Apr 2019 17:04:30 GMT

This formula works, but it also factors in the '0' values. I went into add on's and excluded values that are 0 but this does not seem to make a difference.

Re: Counting Feature

dplr-rn — Thu, 04 Apr 2019 17:09:33 GMT

i am assuming the resource name column will be null for those.
exclude null for that dimension

Re: Counting Feature

Ishilad — Thu, 04 Apr 2019 17:19:18 GMT

The null values in the dimensions are excluded as well

Re: Counting Feature

dplr-rn — Thu, 04 Apr 2019 20:20:04 GMT

hard to help further without access to your app