How to get row/index of a slice

AppSheet AppSheet Q&A
1

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
polohi_0-1695089270705.png1650Ă—2172 149 KB

2

not clear

3

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

4

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.

1 Like
5

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
)
1 Like
6

Count (

FILTER(“YOUR SLICE HERE”, condition ) )