Forum Discussion

ChenChristyYu's avatar
ChenChristyYu
Helper II
8 years ago
Solved

relationship

I joined together tblCustBatch, tblCustJob, and BRPrint Batch Detail and use country(2) as a slicer, but it keeps messing up the grouping. By which I mean, it does not accurately group the data by co...
Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

    In your visualisation pane you have an area called "Page Level Filters" and "Report Level Filters".  That is where you might need to check first.  You will need to step through the logic of any filters contained there to see if they might be hiding information long before your slicer has an effect.  A filter that affects 1 table, might in turn hide information from other tables its linked to.

ChenChristyYu's avatar
ChenChristyYu
Helper II
8 years ago

Thanks Ross!!!!!

 

I checked query edit, and I am wondering if it has something to do with this. "Limit of 1000 values reached" Do you have any idea how to fix that?

Anonymous's avatar
Anonymous
Not applicable
8 years ago

The query editor, for performance reasons, only takes in a small sample of your dataset.  Since you have access to the code itself, via "Advanced Editor", you should be able to tweak written code yourself.

 

For example if you wished to filter out a particular string, you could use the UI to filter out the wrong string temporarily. This would create the necessary code for you to hand change.