Exploreの式におけるエラーのトラブルシューティング

image avatar

Eugene Orman

Zendesk Product Manager

編集日時：2024年11月07日

1

0

23件のコメント

日付
    新しい順
      image avatar

      Ethan Kim

      Hey team, I get a different error message every time I try to drill into a report that previously used to work. 

      These codes are not listed in this document so its unhelpful. 
      When I check our formulas, all of them show a checkmark and no errors. 
      There is no way for me to tell what the cause of this obfuscating error code is. 
       

      0

      image avatar

      Aaran Chilinski - Customer Success Developer

      The Functions table midway through the article doesn't display properly for me and seems to cut a portion off at the right hand side.

      0

      image avatar

      Walter

      Hi 6300548696090 ,

       

      Try this formula instead:

      IF (DATE_DIFF(TODAY(),[Ticket created - Date],"nb_of_days") <= 365) THEN [Requester email] ENDIF

       

      Cheers,

      Walter

      0

      image avatar

      Denis Iliev

      I need assistance with creating report:

      A report that shows users who have provided an email address for feedback and have not had contact with technical support in the past year. Here’s what I’ve tried so far:

      I created a date filter to include tickets from the past year.

      I attempted to create a metric with a standard calculation using the following formula:

      sql

      IF (DATE([Ticket created - Year]) = (DATE("today") - 1 year)) THEN [Requester email] ENDIF

      However, I keep encountering a syntax error. I then tried this formula:

      sql

      IF [ticket created - Year] <= today() - 364 THEN [requester email] ENDIF

      But I received this error:

      “You can’t use [Ticket created - Year] as a number and TODAY() - 364 as text. Use only numbers or only text. If necessary, use the NUMBER function to transform text to numbers.”

      Any help or suggestions would be greatly appreciated. Thank you in advance!

      0

      image avatar

      Jeff Ramos

      Hello everything is fine? Trying to create a metric and I'm not following it, I also don't know if it's possible. Can you help me?

      I have some tickets that have an x ​​tag, and later receive a y tag. I would like to calculate the time (could be in days) that it took for the ticket to receive this new tag. It's possible?

      0

      image avatar

      Javier DM

      Hola muy buenas Merigen!
       
      No estoy del todo seguro que exactamente quisieras realizar, en este artículo tienes una guía de como crear métricas: Creación de métricas y atributos calculados estándar
      Te sugiero revisarlo y luego puedes crear un ticket con nuestro equipo de Soporte para despejar dudas.
       
      Si se tratara de un campo numérico, pudieras utilizarlo directamente desde las métricas, sin necesidad de crear una. Puedes ver este artículo al respecto: Informes con campos personalizados
       
      Para ello te diriges al botón de "Añadir" una métrica > te desplazas al final del desplegable > verás al último "Campos personalizados numéricos". Para otro tipo de campo, pudieras crear la métrica y simplemente insertarlo en la fórmula:
       

       
      Sin embargo sin todos los detalles de tu requerimiento no puedo guiarte mucho mas. Por eso recomendaba crear un ticket con nosotros si tuvieras mas dudas.
      Un saludo!

      0

      image avatar

      Dainne Kiara Lucena-Laxamana

      Hi 1265072906149 !

      It's possible that it's because it's due to this:

      “Note: Reports and dashboards appear in the Updates required category only if they were opened on or after April 11, 2024. If you suspect that other, less frequently used reports or dashboards are impacted, open them so they can be validated.”

      For reference, this note is at Announcing deprecation of invalid calculations in Explore

       

      0

      image avatar

      Michelle Marafiote

      I can see a couple of reports that are flagged as Update Required, however I cannot see what needs to be updated. Can someone please point out how to see this? Also if you go into one of the Update Required reports and then leave making no changes its automatically removed from my Update Required list

      0

      image avatar

      Andrew Chu

      Hi team,

      Can you please suggest a way that we can effectively locate the attributes and metrics that have errors? The “Updated required” tab is very helpful already however we're having a challenge checking dashboards/reports that are having multiple attributes and/or metrics so a quick highlight tech can save us a lot of time.

      0

      image avatar

      Andrew Melvin

      We have several reports that now have  Standard Calculated Metrics with the  error “The type of the element VALUE(metric name inserted) is unknown. Contact Zendesk Support”. What does this mean and how do we fix it?

      3

      サインインしてコメントを残します。

      アカウントの詳細情報

      サインインして詳細を表示

      サインインするとアカウントの詳細を一目で確認できます

      サインイン

      その他のコンテンツ

      詳細
      Videos about reporting configuration
      Resources to troubleshoot reporting issues