I'm by far not a programmer -- but I can patch things together when needed. I need to be able to display the number of tickets opened and closed in the last 7 days on an "it dashboard" that management will have access to. Is it best to do this via the API or get the info from the database directly? Has anyone else created a dashboard like this?