문제 증상
리포팅에 숫자 및 소수점 사용자 지정 티켓 필드가 없습니다.
해결 단계
이러한 필드 유형에 대한 데이터는 보고서 내의메트릭아래에 채워집니다. 이러한 사용자 지정 티켓 필드 유형은 시스템 메트릭과 유사하게 계산되는 숫자 값을 저장합니다.
Explore의 사용자 지정 필드 유형 및 해당 개체 유형의 전체 목록은 사용자 지정 필드로 리포팅하기 문서를 참조하세요.
또는 이러한 필드 유형을 속성으로 변환하려면 다음 사용법을 따르세요. Explore 사용법: 메트릭과 속성 간 전환하기.
번역 고지 사항: 본 문서는 콘텐츠에 대한 기본적인 이해를 제공하기 위해 자동 번역 소프트웨어를 사용하여 번역되었습니다. 정확한 번역을 제공하고자 합당한 노력을 기울였으나 Zendesk는 번역의 정확성을 보장하지 않습니다.
번역된 문서에 포함된 정보의 정확성과 관련하여 질문이 있으시면 문서의 공식 버전인 영문 버전을 참조하시기 바랍니다.
댓글 7개
Noelle Cheng
This doesn't make sense why it's a metric, it should be a value you can select to add to rows or columns. The metric doesn't give me the ACTUAL decimal value.
0
Kevin Adkins
I wish I could up vote Fergal Collins post above more than just once.
It seems to be a common theme with Zendesk, is that they paint themselves into a corner with their data model.
Even if it needs to stay in the Explore as Metrics, then I would think an option in the metric to just display the value would work but I'm sure if it was that easy they would have done it.
2
Fergal Collins
This is so awkward, it should just be a standard column for listing. If people want calculations then they can use metrics.
3
Dave Dyson
Yes, but it takes an extra step. Numeric fields show up in Explore as Metrics, which normally you could use to calculate sums, averages, etc., but not to slice queries by (see Reporting with custom fields to see how custom fields are brought into Explore). However, you create a Standard Calculated Attribute using the instructions here: Creating standard calculated metrics and attributes, and simply using the VALUE function for your account ID field. So if your field is called Account ID, the formula you'd enter would just be VALUE(Account ID).
Once you've created the standard calculated attribute (give it a name, like Account ID Value, it will show up in the Calculated attributes folder in places like Filters, Rows, and Columns. So for your example, where you want to see a list of tickets where the Assignee is Agent A, and the Account ID is 12345, you'd create a query with Count (tickets) as the Metric, add Ticket ID to Rows so you get a list of tickets, then under Filters, filter on Assignee > Assignee name for Agent A, and Calculated attributes > Account ID Value (or whatever you decide to call it) for the value 12345. Then you'll probably want to add Drill-in on Ticket ID so you can click through on the Ticket ID shown in the query output so it opens the ticket in Support (here's how to do that: Using drill in to refine your queries).
With all that done, the result should be a list of ticket IDs of tickets assigned to Agent A for company 12345, where you can click each ticket ID and be taken to the ticket in Support. Hope that helps!
0
Chris Wisialowski
So, just to be clear, if we use the numeric field to identify account numbers, then i want to pull a report that shows, Agent A tickets for account number 12345 and see a nice view of all tickets on that account , i cant?
1
Dave Dyson
Glad to hear it, Samuel!
0
Sam Donovan
Literally came here experiencing what I thought was an issue. Article told me it's in "metrics" and not Rows, and I found my decimal custom field. Thank you Zendesk!
0
댓글을 남기려면 로그인하세요.