My apologies if this has been asked before, but I’ve been working on this for a week and have not found a solution. Also, first time posting and if there is anything I missed out, please let me know. Thanks in advance!
I have a table with entries of my work sessions and I would like to have a view where I only see the most recent n-amount of entries. My current workaround is to have a form sorted by descending [time stamp].
I would also like to create a graph based on the most recent n-amount of entries. So then I figured I would need “a new set of data”.
My attempts thus far have involved using Slice and VCs. Both of which have no success.
I’ve tried creating a Slice with the expression: [module (wk)]=“MDP Anatomy” AND sort([time stamp],TRUE)
I’ve also created a VCs where I used Sort() to have a descending list based on a given category.
Any help or suggestions would be most appreciated!