We want to created a visualization based on regular user in every month.
Here is the requirement:
"The visualization would display the number of regular users every month, regular users are those who have logged in on 5 different days in the same month (A user could log in several times on the same day, still would count as one)."
we have generated a sql query in MSSQL by below query:
Select loginyear,loginmonth,CustomerId, UserId, count(1) cutomerwiseregularuser
select distinct ru.CustomerId, ru.UserId,convert(date, ru.time) as logindate, MONTH(ru.time) loginmonth, year(ru.time) loginyear
from Regularuser as ru ) a
group by loginyear,loginmonth,CustomerId, UserId having count(1) > 5
How can i achieve in kibana visualization to display into dashboard.