Excel exported is not in the same format in Explore

18 Comentarios

  • Tanawat Oonwattana
    Acciones de comentarios Permalink

    Hi,

    I am still waiting for the answer.

    1
  • Eugene Orman
    Acciones de comentarios Permalink

    Hi Tanawat, 

    The fact that the attributes located in the columns are moved to rows in the CSV and Excel exports is expected behaviour. From what I know there are no plans to change it in the nearest future.

    0
  • David Williams
    Acciones de comentarios Permalink

    Hello Eugene

    I'm having the same issue and to be honest it's not very helpful. Can you explain why, when this worked in Good Data but this is no longer the case with the introduction of Explore, that this is 'expected behaviour' please? Why would transposing the row/columns seem like a good idea?

    It makes exporting Zendesk data to be used in conjunction with other sources a problem and is a retrograde step.

    Please re-consider the change plans.

    5
  • John Tieu
    Acciones de comentarios Permalink

    +1

    The way it exports now makes it nearly unusable. GoodData handled exporting well if that functionality can be added to Explore.

    1
  • Thomas Hagins
    Acciones de comentarios Permalink

    Any update as to if/when this feature will work? Makes it quite difficult to run nice reports and now be able to share them or properly review numbers that excel can do. Insights was a great tool but seems to no longer be active as my reporting numbers no longer change.

    1
  • Nick Larrick
    Acciones de comentarios Permalink

    This does make the reporting useless, for even a small company that spends $70,000 a year for your product. I'd think that you can get a developer on this for the 2 hours it would take. This feature works on insights, why go backwards?

    1
  • Eugene Orman
    Acciones de comentarios Permalink

    Everyone, thank you for the feedback on this issue. Explore team will be working on improving the exports functionality during this year. One of the goals is to make sure that attributes placed on columns are not moved to rows in the exports.

    0
  • Sean McKeever
    Acciones de comentarios Permalink

    +1 from me that this needs to get fixed.  I have to do a lot of copying and pasting into other systems for executive reports. Having to export the data to excel (because copying tables out of Explore is awful) and having to remake the report as a pivot table in Excel is painful. Not to mention a big step back from Insights/Good Data.

    0
  • Mike Cunningham
    Acciones de comentarios Permalink

    Any updates on this?  Your requirements do not appear to be user driven: "One of the goals is to make sure that attributes placed on columns are not moved to rows in the exports" .  The only goal we're talking about here from a user point of view is ability to export format along with values.

    1
  • Andrey
    Acciones de comentarios Permalink

    It is strange, we should pay for something but it doesn't work correctly. Waiting for fix

    0
  • Bart
    Acciones de comentarios Permalink

    Rob Stack

    Eugene Orman

    Exporting reports from explore - where you have #Number of tags / ticket topics built per week as columns and tags / topics as rows exports into csv / excel as a single column with same tag / topic repeated with second column showing as numbers. -- Same report in Insights has the columns as per week - as per the query. 

    Metrics are:
    COUNT(TICKETS)

    Column:
    Tickets Solved - Week of year

    Rows:

    Ticket Tags

    Filtered by 2020. 

    Explore report = OK columns showing okay
    Exporting to Excel / csv is not ok.

    This needs to be a priority. -- There is no way that columns in explore become a second column in rows. Insights has the same query as

    What = Solved Tickets
    How = Ticket Tag / Week / year solved

    Each week is it's own column with 1 ticket tag per row - and the number of solved tickets. No issues with Insights excel exporting.

    0
  • Rob Stack
    Acciones de comentarios Permalink

    Hi Bart I do know this is something that's being looked into. Hopefully, we'll have more news soon. Thanks!

    0
  • Richard Heintze
    Acciones de comentarios Permalink

    This is an issue for our reporting as well. In our case, other internal teams request the exports to integrate with other internal data sources. It seems like a reasonable requirement to match the export view to the report view, or to  make this configurable upon export.

    The current behavior discourages adoption of Explore and encourages users to export unformatted data to start the report workflow and formatting in Excel or Google sheets.

    1
  • Bart
    Acciones de comentarios Permalink

    Rob Stack

    Thanks for looking into this. I think the issue is in explore you set all of your "columns" as rows - and then it exports everything into a row. But if I need to see tags per week and set the ticket solved per week as a row, because that's how it splits it into columns on the dashboards, then it should also export them into columns. -- Or make it so the columns part of explore actually is a column and splits the by week section per column. 

    One other metric I noticed missing from insights is week solve / year. I know you have time filters - but my boss would like to see every week since 2017 by tag. A large query for sure, but as part of investor meetings - they don't showcase explore dashboards - they do so through other software products to build these based on the numbers. Insights simply had week 15 / year 2018 etc. 

     

    Thanks again for looking into this. 

    0
  • Rob Stack
    Acciones de comentarios Permalink

    Hi Bart. From Eugene's answer above, I do know the engineering team will be doing work during the year and this feedback will be invaluable to them. I can't speak to specific timeframes, but we'll be sure to provide an update when this happens.

    0
  • Elise Flores
    Acciones de comentarios Permalink

    Any updates on the timeline of when this issue will be resolved?

    3
  • Денис Шпак
    Acciones de comentarios Permalink

    HI everyone!
    +1 Like others, i'm patiently waiting for correct exporting tables into excel. Please, give us a message when it will be released.

    1
  • Viacheslav Parshin
    Acciones de comentarios Permalink

    Hello!

    I would like to add my voice to this post as well. I've recently encountered this shortcoming when trying to export a table report for our finance department and would very much like to see the table export behavior changed.

    1

Iniciar sesión para dejar un comentario.

Tecnología de Zendesk