The above graph was created by using the following SQL Select against the DotNetNuke database and the SQLChart Settings displayed:

SQL Select Statement

select
   convert(varchar,DateTime,102) as [Date],
   count(SiteLogID) as [Views],
   count(distinct dbo.SiteLog.UserHostAddress) as [Visitors]
from
   dbo.SiteLog
where
    PortalId = [DNN:portalID]
    and dbo.SiteLog.DateTime between dateadd(d, -15, getdate()) and dateadd(d, -1, getdate())
group by
    convert(varchar,DateTime,102)
order by 
    Date desc

Settings