05/12/2022 12:06 AM - edited 05/12/2022 01:40 AM
Solved! Go to Solution.
05/12/2022 07:58 AM - edited 05/12/2022 08:00 AM
Query:
Output :
You don't need Dashboard 🙂
11/28/2022 11:00 PM
Hi @rushikeshvartak ,
I have a similar requirement and we do not give access to analytics to end users.
We need a dashboard that takes in the logged-in user data and when user clicks "re-load" or clicks, it should show the data for that specific user
11/29/2022 09:18 AM
You can create dashboard and give access to analytics but dont give analytics tab access
11/29/2022 11:18 AM
To create a run-time analytics that uses ${user.id} we need to create v1 analytics.
But while creating dashboards, it only accepts v2 analytics, right?
Like this:
Here the analytics with analyticskey=26 is from v2 analytics and is not the analytics that I wished to use in this dashboard.
The analytics that I created:
This is v1 analytics, which also has analyticskey=26
11/29/2022 11:53 AM
What’s issue with v2 ?
future in v2 analytics
11/29/2022 08:37 PM
In the V2 analytics create new option, I see only these 3 varierty:
No option for run-time analytics like in v1.
If I create new V2 Analytics "Using SQL Query" using the query: select username,firstname,lastname from users where manager=${user.id}
When clicking on create analytics, I get this pop-up:
What am I missing here?
11/29/2022 08:43 PM
while creating analytics
11/29/2022 09:35 PM
While creating v2 analytics, I only get 3 options, as seen in the screenshot shared above.
But I have an option in the SQL query analytics
I missed this, so please ignore my last 2 comments.
Request you to please read my next comment
11/29/2022 09:43 PM - edited 12/07/2022 10:10 PM
The dashboard is not showing results..
I have a v2 runtime analytics, that takes in logged-in user data properly and when a person runs the analytics, he gets data according to his userID.
But as I mentioned, we do not want to give access to analytics.
So, I made a dashboard
Added this dashboard and that runtime analytics in the SAV Role
But the dashboard in ARS is showing 0 data.
And nothing happens if I click the dashboard
(If I make dashboard for normal analytics, clicking the dashboards takes me to the analytics history page of that analytics)
11/30/2022 07:01 PM
Share query of analytics
11/30/2022 11:33 PM
select username,firstname,lastname from users where manager=${user.id}
12/01/2022 10:03 AM
try removing space of column name for fieldToGroup attribute in dashboard
12/02/2022 02:52 AM
{"analyticsConfigES":"525","fieldToGroup":"Loggedinusername"}
Changed to this... But still dashboard is showing 0 and not opening on clicking
12/12/2022 07:43 AM
Hi @rushikeshvartak ,
We got the dashboard to work.
Instead of using run-time analytics, we used USER CONTEXT.
In the query, added select u.userkey as USERCONTEXT
and changed the "Context" from None to User . The dashboard now gives data based on the logged in user perfectly.