Different results between Table and Clustered column visualisation for aggregated records

[Anonymous]

Hi,

I have a Count aggregation on the number of activites by users as a Table chart

I have some Page level filtering that filters out some users depending on team name.

Team name is a field on a related table connected to the main activities table via a GUID

When I switch to clustered oclumn chart I get some users that are should NOT becoming up. 

It looks like page level filtering is not filtering out these users.

Any idea why?

[Eric_Zhang]

---

@Anonymous wrote:

Hi,

I have a Count aggregation on the number of activites by users as a Table chart

I have some Page level filtering that filters out some users depending on team name.

Team name is a field on a related table connected to the main activities table via a GUID

When I switch to clustered oclumn chart I get some users that are should NOT becoming up. 

It looks like page level filtering is not filtering out these users.

Any idea why?

---

@Anonymous

So how do the filter fields look like after switching? As you mentioned that you just switched from Table visual to a clustered column chart, could you give a snapshot of the Table/clustered column chart Fields? I think the values might change according to evaluation context change.

[Anonymous · Accepted solution]

Thanks for the responses.

All good I changed my relationship between to bi-directional for team and users table  and got what I needed.

I was able to get this sorted with the help of this great video:

https://www.youtube.com/watch?v=-4ybWQSRcOY

[Anonymous]

Hi @Anonymous

It's hard to tell without seeing the data and the relationsships between the tables.

May you provide us with more details or pics?