Forum Discussion
Current and Previous recharge dates
Hello guys, How can I get the last two recharge dates (current and previous) on my model? Or keep a history of recharges? Thank you
Hi mvidalbenitez ,
Your could describe your issue more clearly by sharing screenshots or sample data.
According to your situation, you could use RANKX() function and add a filter( earlier than current date ) to show the result.
The report is reloaded every hour into a mysql database, and I need to show the data differences between current and previous reload (RefreshTime).
Is it possible to create the RefreshTime field in the data model with an incremental update to detect hourly changes?
Another option could be to call a stored procedure in SQL Server to store the reload times.
Example:
New tickets (previous reload): 2
New tickets (current recharge): 3
Thank you