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 2022-08-19
  • Attach files
  • Zyad Khan commented
    12 Sep 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 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 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 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 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?