Version 3110 released
We have released a newer version of Analytics Plus today. This release comes with the following bug fixes. Synchronization issues with ServiceDesk Plus installations that have more than 8 request additional fields has been addressed. Problems in exporting dashboards that contain widgets have been fixed. Synchronization problems with the latest version of Applications Manager have been addressed. Users running version 3050 or above will be able to apply this upgrade pack. Users running version
Widget resize fail
We just upgraded to 3100 last week. I noticed that the widgets needed to be resized manually on one of our main custom dashboards. now, when testing the read-only licenses, I embeded a dashboard into a sharepoint page and the widgets are now REALLY messed up. Bug? Could be CSS conflict being in a SharePoint site. I'll try and do a test in a normal page and see if that has same behavior. Although the application itself has issues re-sizing widgets so that's probably not related. View is from IE 11
dashboard viewer license
Is there someone I can contact for pricing and specifics on the "dashboard viewer license" I learned about yesterday? We'll be looking for a quote for a few new licenses in a bit and I need to let my manager know to include this or not. I'll need to know a price and if I just need 1 of that type or multiple depending on the circumstances. I sent an email to sales yesterday but haven't heard back. Thanks David
Axis Sorting
Hi, New user to AA here, and this one is driving me NUTS. The sorting of each Axis is a complete nightmare, I have a graph where dates are listed on the X axis and a percentage on the Y axis, the chart is then not sorted with the oldest date first to the most recent last, it randomizes them. I go in and have to manually sort them, there does not appear to be either a) Keep source formatting - They are already in the right order according to the sheet b) sort by date Am I missing something?
How to link Request Custom Fields and Worklog Tables? Please help - URGENT
Hi There - Last year, i created a custom field called "Request Type" prior to SDP releasing the default field of "Request Type". Therefore, when integrated with Zoho Reports, "Request Type" was populated in table Request Type Custom Fields and not table Request, which I thought was fine. However, I'm running into an issue. When I create a report using attributes from Request Custom Fields and WorkLog, it say's I can't because they are not connected. However, they should be as Request ID exists in
Access your favourite Analytics Plus dashboards from within Service Desk Plus's console
'If Analytics Plus is integrated with ServiceDesk Plus(SDP), can the dashboard view in SDP include the dashboards created in Analytics Plus?' Yes, now you can. From ServiceDesk Plus version 9300 onwards, there is a provision to customize dashboards, that have been already created in Analytics Plus. By simply adding the URL of your Analytics Plus dashboard or report you can view it on ServiceDesk Plus's visual interface. So, what are the benefits of this feature? Analytics Plus gives you
Tips and tricks : Use timeline filters to apply date changes to reports and widgets in your dashboard
While creating dashboards, do you find yourself adding separate date columns as user filters for each report? There's an easier way to do this. Instead of adding multiple user filters, you just need to add a single timeline filter, in your user filter column. The timeline filter will be applied to the date values of all your reports and widgets on your dashboard. E Example shows how you can add a timeline filter to the alarm trending dashboard.
Why average values of helpdesk KPIs don't give you the full story?
While measuring helpdesk KPIs such as resolution time and response time, we always look at the average value. An average resolution time of 5 hours tells you that your technicians take around 5 hours to provide end users with a resolution to their problem.
How to create report about which request id has almost miss SLA or created too long?
Would you please advise or give me some tip? Thank you in advance
Is it Possible to Move From 'On Cloud' to 'On Premise'
Is it possible to move from Zoho Reports (On Cloud) to ManageEngine Analytics Plus (On Premise) and migrate my database, dashboards, and reports?
Advanced Analytics Link
Even though I have a local advanced analytics installation configured in Servicedesk and the show link checkbox checked it goes to https://reports.zoho.com/ZDBDataSheetView.cc?DBID=301 instead of my locally installed advanced analytics installation.
How to copy templates from old to new database ?? // problem after restoredatabase !!
hello someone can help me, how can i copy some templates from old to new database ? i have two databases SDP SPOC - old database ME ServiceDesk Plus Analytics - its new database my old databse have many templates. Why do i need this? Actually i need to move analytics from old to new instance. my old database have link: https://war04aps001:9443/ZDBDataSheetView.cc?DBID=303 Operation on old server: 1. stop analytics service 2. backup data by using backupDB.bat 3. copy file ZIP to new instance. operation
Tips and Tricks : Pivot charts vs Funnel charts
As compared to pie and bar charts, pivot and funnel charts are not used very often. However, they do an excellent job in drilling down to specifics in your data. So, when is it ideal to use them? 1. When you want to create multi-dimensional reports, opt for pivot charts. Pivot charts are useful when you want to compare more than two metrics/fields/columns in your report. Sample shows a pivot chart depicting the site and department wise grouping of reopened requests. 2. However, funnel charts are
Embedding reports
Just a feature request... Currently we can exports as html/pdf/etc. There IS an embed option, but it requires the users to have a license and log in. So if I want to display a dashboard on my intranet or sharepoint site, it will only be available to certain users. It's not the most elegant. While I understand that licenses=money for your company, I would LOVE to see a read only option for embedding reports where I can do it for all users/visitors to my internal site. I can schedule email reports
FAILURE :Exception in creating table in Analytics.
When synchronizing from Servicedesk Plus to Advanced Analytics we get the error: FAILURE :Exception in creating table in Analytics. The connection between Servicedesk and Advanced Analytics is successful.
[Solved]: How to create worklog report from project tasks - request + request tasks + project tasks
Hello everyone, I'm testing Analytics plus and I can't find solution how to create worklog reports for project tasks. I won't create worklog report which count time spend by my Service Desk Technician who are involved not only in requests, requests tasks but also in project tasks on project module. Would you mind give me some tip ? Best regards Tom.
How do I bind AnalyticsPlus to an IP Address
How do I bind AnalyticsPlus to a specific IP Address? Same for the port.
license of Analytics Plus
Hello, I am using Servicedesk Standard version and interesting on Analytic tool. I wonder if I can you Personal Edition of Analytic tool for Business purpose. for organization need. what is the license term for the Personal Edition thank you !
Tips and tricks : When to use stacked charts.
Stacked charts are popularly used for visual analysis. But when is it ideal to use them? 1. When you want to compare data values, use the stacked bar chart. Stacked bars are better than bar charts when there is a field used in the color section of your chart builder. They are useful, when you want to analyze different parts of a whole. Example shows a stacked bar chart displaying the backlog requests for 10 customers, based on priority. 2. When you want to compare trends across different categories,
Keeping your SLA compliance in check
One of the biggest reasons for businesses to fall back on SLA compliance is a sudden increase in request volume. Organizations agree upon an SLA compliance time with the best case scenario in mind. An organization that has 10 helpdesk technicians, receiving about 100 requests per day on average can easily adhere to a response time of let's say, 20 minutes. But will the same helpdesk be able to comply to that SLA if it suddenly receives 150 requests on a particular day? Maybe. What if the number of
OPM Alerm giving no data available
Hi. We have an OPManager instance Build 11600 and we are beginning to test the Analytics Plus integration. We have Analytic Plus professional version The fetching works fine, but while exploring the KPI Dashboard it's showing in the alarm KPI Section no data available after checking i found all Alarm reports and table is empty Rest of the data was fetched fine. I wonder if you have some idea of what is going on with the OPM Alarm data lastely is there any way to have KPI Dashboard numbers in
How to identify merged requests in a report
We’ve noticed in our reporting that all merged requests are displaying as individual tickets in the reports. For example, we have a report that shows how many requests were raised each week in a particular category. It counts the number of Request ID's for each category for a given week.In this report, it's showing every request we receive as an individual one, even if they've been merged. If we receive 20 hardware requests for the same issue, and we merge them all into one, it still shows 20 hardware
Webinar Recording: How analyzing data patterns can improve IT service delivery
Learn how to Identify data patterns using visual analysis to spot trends easily. Correlate data from multiple sources and get unified visibility into your IT. Create live dashboards to make continuous improvements in ITSM processes.
Survey data from SDP available?
Is it possible to get survey data from SDP into Analytics Plus easily? Any hints how?
Tips and tricks: When to use custom and aggregate formulas in Analytics Plus
If you want to define your own formulas to meet your reporting requirements, you can make use of the custom and aggregate formulas in Analytics Plus. Custom formulas can be used to get derived values from your raw data, more specifically for string and data columns, while aggregate formulas are useful for aggregating numeric data and deriving statistical values. They are useful when you want statistical output like average, mean, median etc. An example for custom formula: This formula calculates
Reporting unassigned time
The "Assigned time" field in ServiceDesk Plus gets updated every time a request is re-assigned to a new technician. This may not be useful in scenario where you want to calculate the unassigned time. Here is how you can get that data using Analytics Plus- 1) Add a new table in the ME ServicedeskPlus Analytics database 2) Use the below query in the import process 3) Look-up Request ID of the unassigned table with the Request ID of the request table.Once the below steps are completed, you will find
Statistics from project Module
Hi team, Ability to get columns from the project management module to create control panels with statistics and trends. Regards, Mauricio
Latest update of Analytics Plus version 3100 now available
Hello there, Yes, we are back with an all new release of Analytics Plus- build no 3100. Here's a quick roundup of some of the latest features in this release. 1. Live connection with Amazon Redshift database for real-time reports and dashboards. Now you can easily import data by using an option to live connect with your Amazon Redshift database. For every report that you create, Analytics Plus will generate appropriate queries to fetch the required data from Amazon Redshift at the time of report
SiteID table
Hi, In which table can we find a description for the SiteID field for a custom query? Thanks!
Free Webinar on March 14th - How analyzing data patterns can improve IT service delivery
Given that data is an important organizational asset, it is key that users get to access them easily, in order to make important decisions. Analytical tools help in combining data from different sources and analyze them to reveal useful insights. Join our free webinar and know how you can use IT analytics to decipher data patterns, and improve IT service delivery. View more details here Schedule: March 14th Time : 10 am -11 am GMT| 2pm-3pm AEDT | 11am-12pm PDT
% Requests within SLA widget shows incorrect information
When I create a widget showing % Requests within SLA for current month vs previous month, the widget displays correct information upon creation. But when I change dashboard to "View Mode" the current month SLA value calculates incorrectly. I am using Data Column: % of Requests within SLA (Actual) grouped by Created Time (Month & Year). I am comparing Latest with Previous values. Please assist - what am I doing wrong?
Tip of the week : Use the lookup column to merge data across tables
While creating reports, sometimes you may need to merge data from separate tables, in order to get the complete picture. In Analytics Plus, you can use the 'lookup column' and combine data across two related tables in your database. It's that simple, and definitely easier than writing multiple SQL queries to join tables. While using the lookup function, just make sure that the parent lookup column has unique, non-repetitive values.
Drill down different for me and users
So if I make a dashboard, or even a report, share it with everyone, enable drill down or "underlying data", the users CAN see some data. When I click on a report, I see all the data for that record, the users just see the fields that make up the report (I think). How can I enable them to see more data when the drill into a report? Thanks
Filter by Week uses Fiscal Year?
So it's currently March 1st (almost). If I have a report for this year where i want to see more than just month/year and less than full date, week would seem to be a solution. And although I get 9 weeks of data, the week numbers are from 26-35. Digging into this, those weeks are from the fiscal year starting July 1, 2016. I would rather see the current week numbers from 1-9. Is there a deeply hidden setting that forces week count starting from Fiscal year or is this like a bug? Not a deal breaker
Tip of the week : Make use of CSV settings to import cleaner data into Analytics Plus
When you click on 'More CSV settings' , you have options to customize delimiters, skip rows etc. in your spreadsheet. This way you can import cleaner data into Analytics Plus.
Reporting Dashboards as Presentations
Present the KPI reports from Helpdesk/ServiceDesk, Network Monitoring, Traffic Analysis, Server Monitoring, Application Monitoring and all other IT management reports in a single dashboard or view them as slideshows.
Reporting Dashboards as Presentations
Present the KPI reports from Helpdesk/ServiceDesk, Network Monitoring, Traffic Analysis, Server Monitoring, Application Monitoring and all other IT management reports in a single dashboard or view them as slideshows.
Problem with dates in some reports
Hello, I recently installed Analiytics Plus and use it with a base of ServiceDesk Plus. In some reports, I have a problem with dates. For example: "Incoming Ticket Count Trend Monthly". If I choose in the Filter Time Created "Nov 2015", will be written on the chart creation time "Oct 2015" (see ITCTM_Nov2015.png). Now I remove filter: all months shifted Nov 2015 -> Oct 2015, Dec 2015 -> Nov 2015, ..., Feb 2017 -> Jan 2017. (see ITCTM_All.png). Change the chart type for a Line Chart (see ITCTM_Line_All.png).
Latest patch casuing ZOHO Report issues!
HI Team - I've upgraded to the latest patch and having some issues with Analytic Plus (Zoho). 1. Nothing available in left hand pane when editing a report; it's merely blank. Nothing to drag and drop 2. Certain custom fields are BLANK when clicking on "Underlying Data" in the report. However, when I got to the view which houses the custom fields, its populated correctly. The lookups seem to be broken. A. These looks are not custom, rather what is available by default. Please assist ASAP, this
Tip of the week : Normalizing date columns in Analytics Plus
It is important to ensure that all the date columns in your spreadsheet are normalized. If the date format is not uniform, then columns with date values may get categorized as text columns. This can be done during data import or after the import operation is complete.
Next Page