Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

Different results between Table and Clustered column visualisation for aggregated records

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's avatar
    Anonymous
    9 years ago

    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

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    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?

  • Eric_Zhang's avatar
    Eric_Zhang
    Icon for Microsoft Employee rankMicrosoft Employee

    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's avatar
      Anonymous
      Not applicable

      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