private DashboardKPI GetOutstandingDisputeCount()
        {
            var monthStart = new DateTime(DateTime.Now.Year, DateTime.Now.Month, 1);
            var monthEnd   = monthStart.AddMonths(1).AddDays(-1);
            var kpi        = new KPISinglePoint <int>
            {
                ColumnNumber = 4,
                Title        = "Outstanding Disputes",
                Type         = "single",
                Data         = _context.Disputes.Count(d => d.DecisionId == null && d.DecisionDateTime == null),
                DataFormat   = "G0",
                DataLabel    = ""
            };

            return(kpi);
        }
        private DashboardKPI GetAuditCount()
        {
            var monthStart = new DateTime(DateTime.Now.Year, DateTime.Now.Month, 1);
            var monthEnd   = monthStart.AddMonths(1).AddDays(-1);
            var kpi        = new KPISinglePoint <int>
            {
                ColumnNumber = 4,
                Title        = "Completed Audits",
                Type         = "single",
                Data         = _context.Audits.Count(a => a.AuditDateTime >= monthStart && a.AuditDateTime <= monthEnd),
                DataFormat   = "G0",
                DataLabel    = ""
            };

            return(kpi);
        }