질문
보고서에 일부 날짜의 값이 0으로 표시됩니다. 0 값을 제외하려면 어떻게 해야 하나요?
답변
보고서 빌더 에서결과 처리(
) > 메트릭 필터. 슬라이더를 사용하여 포함 및 제외할 값의 범위를 정의합니다. 0 값을 제외하려면 슬라이더를 1 이상으로 이동합니다.
참고: 값 범위에서 소수점 이하 자릿수를 지정하려면 슬라이더 아래에 나타나는 숫자를 클릭하고 값을 직접 입력합니다.
0 값이 아닌공백 또는빈 값을 제외해야 하는 경우에는 보고서에서 빈 값을 제외하려면 어떻게 해야 하나요?
번역 고지 사항: 본 문서는 콘텐츠에 대한 기본적인 이해를 제공하기 위해 자동 번역 소프트웨어를 사용하여 번역되었습니다. 정확한 번역을 제공하고자 합당한 노력을 기울였으나 Zendesk는 번역의 정확성을 보장하지 않습니다.
번역된 문서에 포함된 정보의 정확성과 관련하여 질문이 있으시면 문서의 공식 버전인 영문 버전을 참조하시기 바랍니다.
댓글 7개
Marco
Hi Timothy,
Thanks for getting back to us. I get your point, and just to clarify you want this report to be blank at the moment since all results are 0, correct? If that's the case, there would be no way to do it with how metric filter is set up right now, and you'll only be able to do this once you actually have data to be shown by the report. Meaning once there are results that are greater than 0. It does look that this may be important for your use case, which is why I would suggest also posting this as a feedback or feature request: https://support.zendesk.com/hc/en-us/community/topics/360001200913--Feedback-on-Explore-
Hope this helps clarify it.
Regards,
Marco M. | Zendesk Support | support@zendesk.com
-1
Timothy Collins
Hey Marco,
If the results are 0 and 0, you are unable to slide the bar to greater than 0. I want a table that only shows results greater than 0 if there are any. Otherwise, you see _all_ results.
0
Marco
Hi Timothy,
Thanks for reaching out to us regarding this. I'll be glad to assist you.
You can go to Result Manipulation > Metric Filter and drag the bar to the left to not show 0 results. This would set a floor or ceiling for your results. For more information regarding this, you may check this article: https://support.zendesk.com/hc/en-us/articles/360022184654-Selecting-the-metric-result-range
Hope this helps you out! Feel free to let us know if you need any further help.
Cheers!
Marco M. | Zendesk Support | support@zendesk.com
-1
Timothy Collins
Hey Taylor,
This doesn't seem to work if the values are _all_ 0. In my case, I want to create a table of our Reopens by agent and ID... but I cannot see a way to ensure the table only lists tickets that have been reopened (1 or more).
0
Taylor Bowser
Hi Ben,
If you're using the metric COUNT(Public Comments) sliced by ticket ID, you could go to result manipulation>>metric filter and exclude any 0 values for this metric as this article covers.
If this isn't quite what you're looking for, can you clarify what metrics and attributes you're using so we can take another look?
Best,
0
Hannah Meier
Hi 403863206334,
It would be better to create a Standard calculated attribute that identifies tickets with 0 public comments and use that attribute to filter your query.
-1
Ben L
Can I use this feature to exclude tickets containing 0 public comments on my data?
0
로그인하세요.