Need a report that lists the number of times each article has been linked to a ticket each month
RespondidaNeed 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?
-
Hi Mary Paez,
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 -
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.
-
You are able to add the author to the report like this:
- Click the Add link in Rows.
- Click on Article so it folds out.
- Select Article author.
- Click Apply.
The author's name should now be displayed next to the article title.
#helpsome regards,
Marie-Cathrine Sørensen
Developer @ helphouse.io -
Thank you! Exactly what I needed.
Por favor, entrar para comentar.
4 Comentários