Export Data from Dashboard in Explore | Community
Skip to main content

Export Data from Dashboard in Explore

  • October 28, 2020
  • 3 replies
  • 0 views
E

Hi,

Not sure if the answers to the following queries are already available as i couldn't find them. Please advise. Thanks. 

I created a new dashboard with query in Zendesk Explore, and scheduled it to run daily.

In the query, I have indicated the display format for ticket age to be no decimal places. However, in the exported excel report, the result has many decimal places for the ticket age field.

May I check,

  1. How can I remove the decimal places in the report for a particular field?
  2. How can I set the column width or formatting of fields in the report?
  3. Can I sort column A in ascending order and then by column B in descending order in the report?
  4. The exported excel file is in a .zip file when I received it via email. Can it be sent as a excel file instead of a .zip file to ease operational needs?

    3 replies

    Chris112
    • Chris112
    • November 5, 2020

    Elene,

    I will address each of your questions here.

    1. This is done in the chart configuration > display format
    2. Column width is set automatically based on what is in the field, formatting can be adjusted under chart configuration > display format
    3. Only one sort is allowed currently
    4. Zip is how these are sent unfortunately

    I hope this helps!

    Best,

    T
    • Tejas
    • December 14, 2020

    @Chris H Since 11th December the files I am receiving from export are in excel format,( all individual queries clubbed in a single excel file).

    Is it part of any update/changes released or something else?

    Regards,

    Tejas Patil

    Elissa
    • Elissa
    • January 13, 2021

    Hello @Tejas Patil

    I'm sorry for the delay in getting back to you. Yes! You are correct. There has been an update to how excel exports from Explore are formatted. This was in response to a lot of customer feedback. You can see more details in this post: Excel exported is not in the same format in Explore.

    I hope that helps!

    Terms & ConditionsCookie settingsAccessibility statement