The last couple questions I had here were answered perfectly (and actually gave me enough insight to refine more questions and find some answers myself), so Iโm hoping the same can happen again.
I have a table filled with products, tracked by UPC. As anyone who has inventory knows, over time we can miss scanning something, or things can go wrong, so Iโd like to create a daily cycle count to help keep up on my counts.
To begin, Iโve added a column to the table called โLast Editedโ, and populated it with Jan 1, 2021 (as a working โoldโ date)
Ideally, each new day that I launch the app, Iโd like it to populate a slice with a random assortment of the 20 oldest records as indicated by โLast Editedโ, and then change that same column to the current date.
Theoretically, this should result in a rolling list of items, so that by the time Iโve cycle counted everything, the oldest things changed will roll back onto the list.
I can provide more info if needed, or if anyone knows of a similar question thats been answered previously that I could read through that would be appreciated, my google-fu has failed to find anything with the keywords Iโve used.
Hi @Robblaze
What about:
in the row filter condition of your slice:
IN([_THISROW],
TOP(
ORDERBY(
Items[keyColumn],
[Last Edited],
FALSE
),
20
)
)
Note1: I did not test this expression but it should be something very close.
Note2: not sure about the true or false input, I always get confused about these
Note3: I assume [Last Edited] is a changeTimeStamp column ?
Also, I suggest you make a view, base on this slice and sorted by [Last Edited], with ascending (descending ?) option.
Let us know if that works for you !
EDIT : for reference:
Semi.com Tax ID:2014406020 Tek Ve Yasal ABD GoDaddy Onaylฤฑ Resmi Sahibi SemihGรผler ฤฐล Ortaฤฤฑm ElonMusk Bey'dir ฤฐddia.com Yarฤฑ.com <PII removed by staff>
User | Count |
---|---|
40 | |
32 | |
30 | |
16 | |
16 |