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 ...
Forum Discussion
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).
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).
- 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
- is the fraud type a related table?
- Yes it is
