Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
paulsparrow
Contributor III
Contributor III

Counts with multiple filters

Trying to create a bar chart that will give me counts based on filters chosen for dimensions.  Fields include

CSRep

Year

Month

Team Lead

Survey Type

ResponseId (distinct for each line of data)

My bar chart has CSRep and counts of Survey Types.  I'm looking for those counts to reflect the Year and Month chosen.  COUNT(DISTINCT [Response ID]) returns total count of rep for all months with the same amount for all Survey Types.  No reflection of filters chosen.  Looking for ideas.

Thanks

3 Replies
trdandamudi
Master II
Master II

Can you please share a small sample...

paulsparrow
Contributor III
Contributor III
Author

So here I've used COUNT(DISTINCT(ResponseId))

However the filter non Month_Survey is not taking into consideration as the counts represented are for 3 months total data (Jan-Mar)

Capture.JPG

Digvijay_Singh

If filters are not getting response means there could be some problem in data association. Can you share data model or you can check if month is not connected with other desired fields.