Forum Discussion

StephanieHarris's avatar
StephanieHarris
Qrew Assistant Captain
7 years ago

Trending Chart Reports

One of the things my application tracks is the # of investigations at a specific location as well the type of fraud that occurred in that specific location.  I would like to create trending reporting to tell me the Top 5 (might want to change this but between 3-10) Fraud types that are occurring in a specific area.  

I would ideally like to display in a stacked bar of Fraud Methods.  Right now I have a stacked bar that looks like this because it's showing every method, not just the top 5.




reports and charts
  • KevinSlider's avatar
    KevinSlider
    Qrew Trainee
    7 years ago
    Hello Stephanie, 

    I can think of a dynamic solution, but it may be easier just to filter the report until you get the top 5. filtering where the # of frauds is greater than (x).



    • StephanieHarris's avatar
      StephanieHarris
      Qrew Assistant Captain
      7 years ago

      I was thinking about how I would do that and to be honest I'm not really sure.  So 1 investigation has 1 fraud for 1 property.  I want to see in the report the top 5 types of fraud for 1 property.  So I can filter so just Property A but I can't think of a way to filter to the highest types of fraud.  If I think of it like a table report instead of a chart, I can group and sort by Fraud Type (equal values) and see the # of investigations for each type