I want to have something like [_RowNumber] of a slice.
So inside preview data of a slice I can see sth like below
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 ) )
User | Count |
---|---|
35 | |
31 | |
28 | |
23 | |
18 |