Create a record ranking number in a view/report | Adobe Higher Education
Skip to main content
PavlinPa1
Level 3
July 13, 2021
Beantwortet

Create a record ranking number in a view/report

  • July 13, 2021
  • 3 Antworten
  • 1540 Ansichten

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

Dieses Thema wurde für Antworten geschlossen.
Beste Antwort von Doug_Den_Hoed__AtAppStore

Nope, not natively, Pavlin.

Regards,

Doug

3 Antworten

Doug_Den_Hoed__AtAppStore
Community Advisor
Community Advisor
July 14, 2021

Nope, not natively, Pavlin.

Regards,

Doug

PavlinPa1
Level 3
July 16, 2021

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

Doug_Den_Hoed__AtAppStore
Community 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

jerflo
Adobe Employee
Adobe Employee
July 23, 2021

@Pavlin Panayotov‚ @Doug Den Hoed‚ great idea! If Matt wouldn't have beat me to the punch I would've considered taking this on myself :).

PavlinPa1
Level 3
July 26, 2021

Hey Jeremy,

Thank you for your reply. Moreover, Matt and I had a very good conversation on Friday. As far as I understand, Matt has already considered this row numbering solution for a future product release. Good things are coming down the line from Workfront... as always!

Cheers,

+Pavlin