Make Change ID in Analytics Plus clickable - Hyper linking to SDP ticket
Requirement:
To create a formula column in AnalyticsPlus for Change request as a 'URL' to respective ServiceDesk Plus Change request.
Solution:
Step 1:
Open a Change request in ServiceDesk Plus and copy the URL in the address bar as shown below.
Step 2:
Open 'Change' table in Analytics Plus and click on 'Add' and select Formula Column to create a custom formula for change request URL in Analytics Plus.
Use the 'concat' function to join the URL taken from ServiceDesk Plus(Refer step 1) and the 'change request ID' from the column listed.
Use the 'concat' function to join the URL taken from ServiceDesk Plus(Refer step 1) and the 'change request ID' from the column listed.
Step 3:
Once the formula column is created, right-click on the 'Change Request URL' column and choose 'Change Data Type' and select 'URL' from the drop down list.
Once the data type is changed to URL, the 'Change Request URL' column will have a clickable link for the corresponding change request as shown below.