Home› Analytics

I can't get some default Analytics Reports running

Jonas_MüllerJonas_Müller Customer IT Monkey ✭
in Analytics

Dear community,

I can't get some default reports from cireson analytics to run and i'm not sure if i'm doing something wrong or it's a bug from cireson.

I am trying to show the "top affected users with most service requests", however it looks completely wrong.

Attached you will find the screenshots of configuration and result.

Can someone please help me shed some light into why it doesn't work?



image.png


image.png


Answers

  • Adam_DzyackyAdam_Dzyacky Product Owner Contributor Monkey ✭✭✭✭✭

    What version of the portal are you on?

  • Simon_ZeinhoferSimon_Zeinhofer Customer Ninja IT Monkey ✭✭✭✭
    edited December 2022

    Your category is the AffectedUser, and the value is the Created (CreatedDate). So this bugs out your dashboard - @Adam_Dzyacky doesn't it try to add every createddate to the y axis (or x axis, either if it is a bar chart or a column chart), so this cannot work?

    I tried it myself and get back the following:

    image.png

    So as you cannot select the CNT as a value in this query, I don't know how it can be used at all.

    @Jonas_Müller - Try this query instead, it should work as expected. You can adjust the TOP 25 to your needs :

    Select TOP 25 COUNT(WorkItemId) as CountWorkItem,
AffectedUser 
from dbo.SM_WorkItem_ServiceRequest


group by AffectedUser
order by COUNT(WorkItemID) DESC

    In the dashboard settings set the AffectedUser as "Kategorienfeld" and the CountWorkItem as your "Wertfeld".

    Be aware that you have to define a name for the count (here it is countworkitem), else the dasboard shows nothing ;)

Sign In or Register to comment.