Need a report that lists the number of times each article has been linked to a ticket each month | Community
Skip to main content

Need a report that lists the number of times each article has been linked to a ticket each month

  • February 23, 2021
  • 4 replies
  • 0 views

Mary12

Need a report that lists the number of times each article has been linked to a ticket each month.  When I try to get this report, Explore puts the data in an unusual order:

 

Article title |  Jan 2019 links | Jan 2020 Links | Jan 2021 Links | Feb 2019 Links

 

We would like the report to show 

Article title | Jan 2019 | Feb 2019 | Mar 2019 | ... | Jan 2020 | Feb 2020| ...

 

How can this be done?

4 replies

Marie-Cathrine

Hi 9718087827,

You should be able to get a report with data in chronological order by using the metrics and attributes like in this image and then setting the visualization type to table.

Remember to have the Event - Year placed before Event - Month. This article also explains that. The same goes for custom attributes combining year and month. 

#helpsome regards,
Marie-Cathrine Sørensen
Developer @ helphouse.io


Mary12
  • Author
  • February 23, 2021

It would be nice to list the author of each article, however, I understand you cannot use multiple datasets at this time.  Makes it difficult to contact the author of the articles b/c you have to view each separately.


Marie-Cathrine

You are able to add the author to the report like this:

  1. Click the Add link in Rows.
  2. Click on Article so it folds out.
  3. Select Article author.
  4. Click Apply.

The author's name should now be displayed next to the article title.

#helpsome regards,
Marie-Cathrine Sørensen
Developer @ helphouse.io


Mary12
  • Author
  • February 23, 2021

Thank you! Exactly what I needed.