Liongard Ideas Portal

Submit and upvote ideas to make Liongard better. You get 20 votes so vote wisely. 🙂

The Product Team is constantly reading your ideas and while we can’t promise that all ideas will become a reality, we value your feedback and promise to always have our Partners in mind when building and improving Liongard.

Check out our FAQs to learn more.

See what we've shipped by clicking here!

Excel Report Formatting

I am trying to generate a stale account report. The report generates, but all stale accounts are listed in the same cell separated by commas. This would require significant formatting to make this report useful to send to a client.

Is there a way you can create a new method of generating these reports?

  • Guest
  • Jun 29 2021
  • Planned
Last Reviewed Date 2023-01-13
  • Attach files
  • Zyad Khan commented
    24 Oct, 2022 11:11am

    Hi Daniela, thank you so much for the follow up.

  • Admin
    Daniela Weisz commented
    21 Oct, 2022 01:38pm

    Hi Zyad, this is still on our roadmap and we plan to work on it soon. I understand this is a current frustration and we have not lost sight of it. We've been wrapping up some other reporting improvements we had in flight (PDF reporting which is release over the next few weeks and cleaning up the excel export to remove unnecessary characters ("[", "/"...etc) from the export.) and now we're shifting to improving this experience.

  • Zyad Khan commented
    19 Oct, 2022 11:28am

    Hi Daniela, was there any progression to this?

  • Zyad Khan commented
    12 Sep, 2022 11:22am

    We are looking to have generate a excel template that generates both stale and unused users for a client. However, when the report is made, the users are clustered into a single cell which makes it nearly unreadable.

    As I mentioned in my earlier comment, it would be extremely helpful if there is an option so that the format will have one value per column instead of all of them in a single cell.

  • Admin
    Daniela Weisz commented
    7 Sep, 2022 07:32pm

    Hi Zyad, we do have some work queued up for improvements to our reporting feature to help with the formatting of reports when a metric is returning multiple items and data points from an array. I think this will help address your issue but for me to be sure do you mind sharing what report you'd like to build and with what data?

  • Zyad Khan commented
    2 Sep, 2022 12:40pm

    Hi Daniela,

    In response to your question on how to make formatting more presentable, could there be an option so that the excel sheet will have exactly one metric per column rather than all in one cell.

  • Joe Johnson commented
    25 Jul, 2022 04:11pm

    We also ran into this issue with any metric that grabs an array in the reports metrics tables. We expected that our reports would look like the arrays do when exported from individual inspectors.

  • Matt Scutt commented
    14 Jun, 2022 08:43pm

    Im surprised this still hasn't been implemented - reports are unreadable in the current state and are pretty much unusable

  • Steve King commented
    8 Oct, 2021 06:59pm

    Need excel exports to be formatted properly, with one metric per column rather than having having everything bunched into one cell. Makes it very tedious to have to do text to columns, then transpose the data just to make it readable.

  • Admin
    Daniela Weisz commented
    15 Jul, 2021 04:46pm

    Appreciate the additional feedback, I see what you're referring to now. This is a valuable and very valid request, unfortunately it is not something that we can jump on immediately as we have some other higher priorities we're working on at the moment but we will continue to monitor the votes on this idea and move this along when we're able to.

  • Guest commented
    12 Jul, 2021 07:06pm

    I need something that lists each system on its own line in a spreadsheet. Right now it basically makes a list with commas separating the entries. This is not helpful to us as we plan to provide these reports to our clients to make some decisions regarding accounts to disable.

    I am attaching what is currently being generated. It is hard to read and not a great tool for us to use in its current format.

  • Admin
    Daniela Weisz commented
    12 Jul, 2021 06:44pm

    Hi there, thanks for your feedback! Can you share what type of formatting improvements would be helpful in excel to make it a bit more presentable?