Creating Pivot chart for ALM reporting. – User friendly Tech help

ByMatteo

How we created our automation progress  report from ALM to Email in 30 minutes?
n
nRequirement:–
nWe need to showcase our management regarding the  progress in Automation.So rather than giving them quantitative data we thought of sharing it in more presentable manner using Pivot charts.
n
nHope it help our fellow automation friends in creating easy and rapid reports.
nPlease feel free to share Your experience as comments, as we always believe sharing is caring.
n
nDo follow us for more updates FB,LinkedIn,G+
n
nDownload dummy Excel
n
nSolution:-
nStep1:- Getting Data from ALM(Application life cycle management),
n
nNote:- It can vary depending on the management tool which is used in the organization but still the approach would be same.
nA)Testing -> Test Plan -> Select the Test Folder -> Live Analysis Tab -> Click on ‘Add Graph’
n
n
n
B)Select ‘Summary Graph’ -> Click Next
n
n
n
C) Select any value for X-axis field -> Click Finish
n
n
n
D)Graphical view would be generated -> Click on the bar graph tower
n
n
n
E)Drill down Results window opens
n
n
n
nThis is what we were waiting for, we can change what all the columns we need in our report.Further we would export the report in Excel format.
n

n

n

n

n

n

n

n

n

Selecting columns in Drill down results view

n

n

n

n

n

n

n

n

Exporting excel from Drill down results

n


n
nStep2:-Creating Pivot Chart
nA)We have our required data in Excel,we can edit to make any required changes like headers or any other modification.
nB)Insert -> Pivot Chart
n
n
n
C)Select the Table/Range for Pivot Chart -> Click Ok
n
n
n
D)Select from “Pivot Chart” Fields, the columns that we need to displayed in Pivotchart report
n
n
nCheck the two variations of graph when we changed the data under Axis and Values.
n
n

n

n

n

n

n

n

n

n

Pivot chart view-1

n

n

n

n

n

n

n

n

Pivot Chart view-2

n


n
Step3 :- Playing with the design of the Pivot chart
nOne’s our chart is ready we can change the color or display design (Like pie chart) to make it look more impressive and easy to comprehend
n
nJust select chart -> click on brush
n

nn

n

We can also change the shape of graph, INsert -> Charts -> Select the chart option as suitable(Do select the chart below to check the live effect)
n

nn

ReRun ALM test
nLog BUG in ALM using OTA
nLearn Selenium

Was this article helpful?
YesNo

Similar Posts

Using Custom LWC inside Vlocity Omniscript – User friendly Tech help

ByMatteo

Problem: Due to omniscript limitations, you might find the need to incorporate custom LWC to meet specific requirements. Solution: Acquiring the Custom LWC: Obtain the custom LWC from the salesforce Lightning web components. For this example, we’re using a radio group. Incorporating into Omniscript Designer: Navigate to Omniscript Designer > Inputs and drag the “Custom…

Introduction to TestNG in Selenium – User friendly Tech help

ByMatteo

In our last tutorials we covered the basic aspects of Selenium. Now we are moving towards intermediate phase so that we can inculcate framework level things in Selenium execution.n n Today we are focusing on Test NG framework; we will touch its key components which will mentor us to use its capabilities with Selenium. n…

Learning basic’s of Extensible MarkUp Language(XML) – User friendly Tech help

ByMatteo

Scenario:– Learning XML, Rules and Meaning of XML, Well formed XML, Delimiters in XML n Solution :- In this video tutorial we tried to touch basics of XML. n What is XML? n n Extensible Markup Language n Extensible :- Capable of Being Extended n Markup :- In the form of tags, indicating logical components…

Working with React-Router? – User friendly Tech help

ByMatteo

“An investment in knowledge pays the best interest.” Benjamin FranklinnnIn our previous post we started with creating our first react app and than we learned about some basic terminologies in react. Today we are going to focus on creating the router behaviour using react library.nnIncase you want to learn about filtering in react check the github code….

salesforce – Page 2 – User friendly Tech help

ByMatteo

Smart way of working with Salesforce Vlocity Dataraptors STart small but think big Problem- How to improve productivity while working with Dataraptors 1)Always start with creating new version of the dataraptor, it avoids overwriting the existing stable changes, or you can always fall back to previous versions in case your changes don’t work as expected….