Trending Chart Reports

  • 0
  • 1
  • Question
  • Updated 3 months ago
  • In Progress
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.




Photo of Stephanie

Stephanie

  • 722 Points 500 badge 2x thumb

Posted 3 months ago

  • 0
  • 1
Photo of Slider

Slider

  • 1,346 Points 1k badge 2x thumb
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).



Photo of Stephanie

Stephanie

  • 722 Points 500 badge 2x thumb

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
Photo of Slider

Slider

  • 1,346 Points 1k badge 2x thumb
is the fraud type a related table?
Photo of Stephanie

Stephanie

  • 722 Points 500 badge 2x thumb
Yes it is