Create a record ranking number in a view/report | Community
Skip to main content
PavlinPa1
PavlinPa1
Level 3
July 13, 2021
Solved

Create a record ranking number in a view/report

  • July 13, 2021
  • 3 replies
  • 1546 views

Hello,

How can I create a record ranking number in a single view or report?

For instance, there is a view or report created with 10 records. Then, I sort those in a certain way, e.g. by date. At that point, I'd like to have a record number in the first column to show me 1, 2, 3, ..., 10. In that case, I may refer to... "Record 5, 7, and 8..." without counting the records/lines on the screen. It could be more complicated, such as "Record 16, 22, and 34...", etc. Then, I may change the sorting, e.g. by % Complete. I want to have the ranking number from 1 thru N (top to bottom), again. And son on and so forth.

Is there a way to add a (static) line/record ranking number column in a view or report with sorting being changed? Thank you.

Best,

+Pavlin

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by Doug_Den_Hoed_AtAppStore

Nope, not natively, Pavlin.

Regards,

Doug

3 replies

Doug_Den_Hoed_AtAppStore
Community Advisor
Doug_Den_Hoed_AtAppStoreCommunity AdvisorAccepted solution
Community Advisor
July 14, 2021

Nope, not natively, Pavlin.

Regards,

Doug

PavlinPa1
PavlinPa1Author
Level 3
July 16, 2021

Doug, What about with some programming? Do you have any ideas? ;)

Doug_Den_Hoed_AtAppStore
Community Advisor
Doug_Den_Hoed_AtAppStoreCommunity Advisor
Community Advisor
July 17, 2021

Oh, well that's entirely different Pavlin,

If I'm allowed to cheat and use dark matter, we could whip up a Magic Report solution for you that presents the data in a grid layout similar to what you'd see in the Workfront report (heck, maybe even read the definition from it), but when its then presented, add a line number entry in the first column for easy reference; and even alternate the grid row colors etc. if you want to get fancy.

That said, it's such a good, simple idea, I'd think that maybe @Jeremy Flores‚ could consider grafting it into a future release of Basic Views (and Reports), and/or @Matt Thomas‚ might like to incorporate it into the upcoming New Reporting Experience; but of course, I'll leave it to them to comment further.

Regards,

Doug

Matt-Thomas
Adobe Employee
Matt-ThomasAdobe Employee
Adobe Employee
July 20, 2021

This is a fantastic idea @Pavlin Panayotov‚ and @Doug Den Hoed‚! Having the ability to toggle on line numbers for rows in a table seems like a great feature to incorporate in the new reporting experience. @Pavlin Panayotov‚ do you mind scheduling some time with me to make sure I have fully captured your idea and then talk about possible ways to implement it https://calendly.com/matt-thomas-wf/30min. Thanks!

PavlinPa1
PavlinPa1Author
Level 3
July 20, 2021

Hi Matt, Just scheduled time with you. Chat soon. Thank you.

Terms & ConditionsAccessibility statement

Loading footer...