Discussions

 View Only
  • 1.  Trending Chart Reports

    Posted 09-19-2018 20:13
    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.


    ">https://d2r1vs3d9006ap.cloudfront.net/s3_images/1752556/RackMultipart20180919-26912-1qv4egu-Example_inline.jpg?1537387996">



  • 2.  RE: Trending Chart Reports

    Posted 09-20-2018 13:45
    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).





  • 3.  RE: Trending Chart Reports

    Posted 09-20-2018 14:26

    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


  • 4.  RE: Trending Chart Reports

    Posted 09-21-2018 02:45
    is the fraud type a related table?


  • 5.  RE: Trending Chart Reports

    Posted 09-21-2018 16:14
    Yes it is