Dashboards

[Kavyasree]

Hi All,

Currently, we are working on requirements for creating Dashboards. One of the dashboard has to show number of users onboarded each month. So, we have created on for 2023, but the dashboard is not sorting the Month properly even when we group by Month. Can someone please guide on how to resolve this?

[Manu269]

Please share the query and config done in dahsboard?

Are you using the analytics key in query?

[Kavyasree]

@Manu269 Below is the query I am trying with.  yeah I am using Analytics key in the Dashboard query like {"analyticsConfig":"568","fieldToGroup":"MONTH"}

Select username,employeetype,YEAR(CREATEDATE) AS YEAR,MONTHNAME(CREATEDATE) as MONTH from users where DATE_FORMAT(CREATEDATE, "%Y-%m-%d") >= '2023-01-01' and DATE_FORMAT(CREATEDATE, "%Y-%m-%d") < '2024-12-31'. 

This is the query I am using

[rushikeshvartak]

We also had same issue we prefix with year in query 

concat(year(createdate),'-', MONTHNAME(createdate))

[Kavyasree]

Thank you @rushikeshvartak . I will try with the suggested query. If possible, Can you please provide complete query you are using. 

[Kavyasree]

I have updated the query as per the comment, but it is not coming in the sorting order as well.
Select username,employeetype,YEAR(CREATEDATE) AS YEAR,concat(year(createdate),'-', MONTHNAME(createdate)) as MONTH from users where DATE_FORMAT(CREATEDATE, "%Y-%m-%d") >= '2023-01-01' and DATE_FORMAT(CREATEDATE, "%Y-%m-%d") < '2023-05-01'

Please let me know if I am doing it incorrectly.

[rushikeshvartak]

Select concat(year(createdate),'-', MONTHNAME(createdate)) as MONTH,username,employeetype,YEAR(CREATEDATE) AS YEAR from users where DATE_FORMAT(CREATEDATE, "%Y-%m-%d") >= '2023-01-01' and DATE_FORMAT(CREATEDATE, "%Y-%m-%d") < '2023-05-01' order by MONTH

[Kavyasree]

I have tried the same already but still november is coming first. And also it is kind of all jumbled with years and bar chart is not expandable.

[rushikeshvartak]

If months are more it get jumbled please use max 5 records and already idea ticket in place for same

https://ideas.saviynt.com/ideas/EIC-I-2422

[Kavyasree]

Thank you Rushikesh for the response. I have limit only 4 months and then also, it is showing April month in first. This is the same initial issue we had.

[rushikeshvartak]

Select concat(MONTH(createdate),'-', MONTHNAME(createdate)) as MONTH,username,employeetype,YEAR(CREATEDATE) AS YEAR from users where DATE_FORMAT(CREATEDATE, "%Y-%m-%d") >= '2023-01-01' and DATE_FORMAT(CREATEDATE, "%Y-%m-%d") < '2023-05-01' order by MONTH

[Kavyasree]

We have tried ordering by the month before using the  Concat as well. But unfortunately this is  also not working coming in sorting order

[rushikeshvartak]

Share current query

try with year