Skip to Content
0
Aug 31, 2018 at 08:54 AM

Days between and Count function - No of open queries by site

49 Views

Hi All,

I’m seeking to do a Count of queries that are open with outstanding days in these named categories;

<30 Days

31-60 Days

61-90 Dayssummary.pnglist-page-1.pnglist-page-2.pnglist-page-3.png

>90 Day

First calculations were done for a variable: xDaysOpen =DaysBetween([Query Open Date];[xCurrentDate])

Now I have these 74 rows (see attached) but would just need to do a count function that will place each of the categories in a columns rather than rows. What is the best approach in handling this summation? Thanks for your support.


epj

Attachments

summary.png (11.6 kB)
list-page-1.png (24.9 kB)
list-page-2.png (24.7 kB)
list-page-3.png (22.1 kB)