跳至主要内容

Article 1 min read

Tip of the week: Including 0 values in Insights reports

Sarah Hagberg

最後更新 October 27, 2015

Do you have reports where the X-Axis value disappears if it is a 0 value?

For example, in this bar graph the hours 3 a.m., 4 a.m., and 5 a.m. have disappeared because no tickets were solved in those hours.

Zendesk tip of the week


This tip of the week covers how to include 0 values in Insights reports. Note: This metric will only work for reports with one attribute. To do this we’ll create a custom metric using the IFNULL function. For example, if we were reporting on # of Solved Tickets by Hour Ticket Solved, we would need to create a custom metric for the # of Tickets Solved Including 0.

To build the # of Solved Tickets metric:

  1. Click Reporting in the sidebar, then click the Insights tab.
  2. Click the GoodData link in the top right corner of the panel.
  3. For reporting on the # of Solved Tickets, it’s easiest to duplicate the metric. In Insights click Manage > Metrics > # Solved Tickets > Duplicate.

Then we can work on building the new # of Solved Tickets Including 0 metric.

To build the # of Solved Tickets Including 0 metric:

  1. Start by naming your new metric > Edit.
  2. At the beginning of the metric type: SELECT IFNULL ((
  3. At the end of the metric type: ), 0)*1
  4. Click Save.

The last step is to create a report. There you have it – Your report will now maintain 0 values! Remember, the IFNULL function can be applied to any metric.

Head to the forums to see the step-by-step explanation of this tip of the week

Keep the knowledge flowing! For more tips like this, check out Zendesk’s Tip of the Week collection.

相關案例

Podcast
1 min read

Humanizing support at scale—with Talkspace’s Donna Haddigan

For Talkspace’s support team, empathy isn’t a nice to have, it’s a must for each and every customer interaction.

Article

Top 6 reasons to attend Zendesk Relate 2024

The future of CX is here, and this is your invitation to think bigger. Here are the top six reasons why Zendesk Relate—coming to Las Vegas April 16 through 18—is the must-attend CX event of the year.

Article
1 min read

Top customer experience podcasts

Check out the top 35 customer experience podcasts for the latest trends, tips, and strategies in customer experience.

Article

Don’t miss your chance to hear Former First Lady Michelle Obama speak in person

Former First Lady Michelle Obama will join us on the Zendesk Relate mainstage for a live, moderated conversation on April 16.