I would like to write an ifelse statement like: ifelse(the next row has value = ‘A’, 0,1). However, unlike excel quicksight data doesn’t have index like A1 or B11…is there a workaround way of accessing values in index form?
thank you in advance!
Hello Soyoon,
As far as i know Indexing is not available in QuickSight yet .May be you can explore Rank or DenseRank function and check if that can be used in your case. if possible good to have that from the backend itself.
Nevertheless, you can refer this old post to get some idea -How to add a new column in (Row ID) which is sequentially increasing - #2 by robdhondt
Hope this helps.
Cheers,
Deep
Hi Soyoon,
This feature is not currently available in QS, i would suggest you to handle at dataset level, so that you can have more options to use the field in further calculations.
Bless, thank you very much for the suggestion!
1 Like
Makes sense - thanks for letting me know!