最近搜索
没有最近搜索
Combined linked article tickets and created article tickets in Explore
已回答
已于 2022年11月07日 发布
Our Support agents are going to be expected to create new or link existing Guide articles on 80% of their solved tickets. I can pull all kinds of counts out of the box in relation to created articles and linked articles, but am having issues combining them into one metric.
In looking at the logic, it makes sense to me that the following calculated metric would provide this information.
(( D_COUNT(Linked article tickets) + D_COUNT(Created article tickets)))/DCOUNT_VALUES([Ticket ID])
It doesn't seem to be working the way it seems to be as it should.
I'm hoping someone can help me figure out how to combine these as I'd prefer to keep them in one simple clean %.
Thanks in advance!
0
2
2 条评论
Gab Guinto
Have you tried adjusting the display format of the results. If DCOUNT_VALUES([Ticket ID]) returns a much higher value that the sum of the other two metrics, then the result of the calculation would not be a whole number, and this could be why the table displayed zero. Can you try adding decimal places for your metric '% Linked and Created Articles' via Chart configuration → Display format? Example:
0
Michael Mader
Thanks Gab, I think I was doing a bit too much work on this one as the Agent Engagement metric should get us what we need.
0