How to get row/index of a slice

I want to have something like [_RowNumber] of a slice.
So inside preview data of a slice I can see sth like below

polohi_0-1695089270705.png

0 5 112
5 REPLIES 5

not clear

Sorry If I did not explain clearly.

I have a slice data which I filter on some condtion.
That's say if I have a table like following: [a, b, c, d, e, f , g, h, i, j]. Which I can simply count the sequence number by the [_RowNumber] - 1 so  a -> 1, b->2.

 But if i have a slice like [b, f, g, i]. How do I add sequence as virtual colume so b -> 1, f->2

Try this

Index of : https://www.googlecloudcommunity.com/gc/Tips-Tricks/INDEXOF/m-p/427993

Virtual Column should be added in the main table. In that it will be shown in the UX of Main table.

 

This may also work. Only valid in a slice view. (Also the view of your slice should display the rows in _ROWNUMBER order if I state the obvious.)

 

COUNT(
 FILTER("YOUR SLICE HERE",[_RowNumber] < [_ThisRow].[_RowNumber]))
 + 1
)

 

 

Count (

   FILTER("YOUR SLICE HERE", condition ) )
 

Top Labels in this Space