HTML Reports not visible in Jenkins Dashboard

Question

In my Jenkins, I have installed HTML Publisher.

After adding this I have restarted Jenkins and when I am checking Pipeline(project) Html reports is not visible on Dashboard.

This is my dashboard view

NOTE I have tried the same set up in the different project and there it was working perfectly.

Answer 1

make a list of indexes and the ranges

There can be two options to use the range

• Apply some formula on that range
• Display the values in that range

I have inserted examples for both as below

In E1 you can enter 1 ,2 or 3 (any value from the index and range created list)

Formula in F1 is =SUM(INDIRECT(VLOOKUP(E1,B1:C4,2,0)))

this will give a sum of values in range against the index

Entry of 2nd example is in A9, you can enter any index in A9

Formula in B9 is =INDIRECT(VLOOKUP(A9,B1:C4,2,0))

The trick here is that you have to start selecting the cells where you want to display the range from B9 and go till E10 (or what ever cell is best for you)

Now press F2 and press Ctrl+Shift+Enter

Answer 2

Lets assume you make your selections in cell H1 and that all the ranges are 6 rows by 5 columns. you could define your range using the following formula:

=INDEX(B:B,MATCH($H$1,A:A,0):INDEX(F:F,MATCH($H$1,A:A,0)+5)

IF you want the ID number to be part of the range, change B:B to A:A

The above formula cannot be used on its own. However since it defines a range, you can then use it in other formulas that need to work with a range. IE you could nest it in the AVERAGE function as follows:

=AVERAGE(INDEX(B:B,MATCH($H$1,A:A,0):INDEX(F:F,MATCH($H$1,A:A,0)+5))

or use it for the look up range in VLOOKUP

=VLOOKUP("Timmy",INDEX(B:B,MATCH($H$1,A:A,0):INDEX(F:F,MATCH($H$1,A:A,0)+5),3,0)