Good Morning, I attended the knowledge2020 lab Make Better Business Decisions with Query Builder and they pointed me here for some assistance. There is an option to create a report off a query once it is placed on a schedule. However, when attemptin...
When creating a report that uses aggregation, such as a Bar chart, if you want to aggregate with a Distinct Count it only gives you the option to aggregate on Reference fields. I want to aggregate based on a String field (such as Number in an inciden...
Hi i am new to Performance Analytics in snow and was trying to create an Automated indicator and adding automated breakdowns to it. After executing the Job. When i go to see Score for the indicator, nothing comes there. Not sure if i am missing any ...
Hi all, my client's requirement is to build a bar chart displayed below. It is displaying the number of "cmdb_ci_hardware" records grouped by "DNS Domain" field on the x-axis and stacked by the "Class". At first, I tried to achieve this with reports,...
Hello, is it possible to clear the "recent" list under the Self-Service module -> Dashboards? We have a now inactive dashboard we would like to just remove from the list for everyone that had accessed it previously. I've tried looking in the sys_ui_r...
I am able to create and save a new report, but if I go to edit that same report it only gives me the option to "Insert" or "Insert and Stay". The save option is no longer there. Also from a dashboard I used to be able to click the pencil to edit th...
Hi Team, I have an indicator, which displays Percentage of calls attended by agent. Below is formula. [[GSDKPI_Number of calls answered]]/[[GSDKPI_Total Calls Received]]*100 Daily Number are coming correct for all the agents. But I also want Monthly ...
Hi, I would like to create a report (single score type) with percent instead of count. For exemple, on critical incidents (priority 1), I'd rather have a result like 10% of total incident instead of a count of 225 incidents. Is there a easy way to d...
Hi All, Is there a way to share a dashboard to all the users who are having no roles assigned to them. We can share to specific users, groups and specific roled users but how can we share to all the non roled users without adding them one by one. Is ...
Can anybody advise what script to use to be able to help build a report based on the users "Level 1" Company. We have over 1000 companies that can be selected for our users, however we only have 5 "Level 1" companies. The remaining companies will t...
what is the fact table for service request table for indicator source we need to select.
I need to creat a report that shows the average number of tickets the Service Desk creates per day. Is this possible, or do I need to have Performance Analytics?
How to add bookmark for the dashboard on the left panel not below the filter navigation(not as module).
I want to put count of active incidents in tiles for already created dashboard.
Hi, Can you guide me how to get service catalog variable in Sysapproval_approver table. I am trying to fetch a report. As per community i tried below steps. approver for ->questions-> and added the variable name. After clicking on run report i a...
