Click HERE to see how Saviynt Intelligence is transforming the industry. |
01/05/2024 03:17 AM
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?
01/05/2024 05:33 AM
Please share the query and config done in dahsboard?
Are you using the analytics key in query?
01/08/2024 01:48 AM
@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
01/05/2024 08:16 AM
We also had same issue we prefix with year in query
concat(year(createdate),'-', MONTHNAME(createdate))
01/08/2024 01:56 AM
Thank you @rushikeshvartak . I will try with the suggested query. If possible, Can you please provide complete query you are using.
01/08/2024 05:38 AM
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.
01/08/2024 11:14 AM
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
01/09/2024 03:17 AM
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.
01/09/2024 05:31 AM - edited 01/09/2024 05:34 AM
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
01/11/2024 02:48 AM
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.
01/11/2024 08:00 PM
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
01/12/2024 12:32 AM
We have tried ordering by the month before using the Concat as well. But unfortunately this is also not working coming in sorting order
01/14/2024 05:59 PM
Share current query
try with year