nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

A piechart to show how many users login to the system each day

Tim_Hoang_(ASERA01Admin_(Delete)_2490215)

Hi,Is there anyway to generate a piechart to show how many users login to the system each day for a time frame of 30 days?Appreciate for any help

Find more posts tagged with

Comments

Tim_Hoang_(ASERA01Admin_(Delete)_2490215)

I make a mistake, it should be bar chart for "How many users login to the system each month" and I got the solution report as follow:SELECT substr(to_char(DAUDIT.AUDITDATE, 'yyyy mm'), 0, 8), count(distinct(DAUDIT.USERID)) FROM daudit WHERE DAUDIT.EVENT='LOGIN' group by substr(to_char(DAUDIT.AUDITDATE, 'yyyy mm'), 0, 8)8^)

Jonathan_Thomson_(jonathanthomson_-_(deleted))

This works for Oracle based, but what about SQL server?