cancel
Showing results for 
Search instead for 
Did you mean: 

SAC - Show running number in table

mfrieser
Participant
0 Kudos

Hello,

I am working with analytic application and I want to show a running number in my table.

I am working on a project planning application. Every project contains of several Items.

The user can add these items.

Example table 1:

Project 1

1 - Item A

2 - Item B

3 - Item C

table 2 with different project:

Project 2

1 - Item C

2 - Item A

I need to create this running number dynamically, based when the item was added (Date).

I already tried the "Count Dimension" Aggregation calculation measure (with project and also with item dimension as aggregation dimension) but this returns

Project 1

1 - Item A

1 - Item B

1 - Item C

and so on ...

Thanks!

Best regards

Michael

JBARLOW
Contributor
0 Kudos

HI Michael,

Is this something you could mock up using the BestRunJuice sample data?
Mainly asking as i'm trying to get my head around the requirement.

Cheers
James

N1kh1l
Active Contributor
0 Kudos

michael-frieser

Are you trying to index the items within the project? You might need analytical app for this I feel.

mfrieser
Participant
0 Kudos

Yes, you can call that an index.

The user is able to add new items to the table. Depending on the amount of items, the number should be added incrementally.

e.g. if there are no items in the table yet and the user adds a new item, this item gets the number 1

if there are already 3 items in the table an the user adds another item, the item should get the number 4

the tables exists for every project.

Depending on the project, item A can have a different running number than in another project

Accepted Solutions (0)

Answers (0)