DATASCADE
Tactical reporting
A credit risk manager receives every day a list of clients balances and he wants to create a tactical report showing for each client with negative balances the number of days where they have had insufficient funds.
​
A first Datascade spreadsheets loads the list of the day, adds a new column with the current date and saves it to a local "history" folder.
A second spreadsheet loads the entire content of the local "history" folder into a single sheet and filter on the positive balances.
A pivot table is then added to the spreadsheet to calculate the most recent date where a client has had a positive balance.
A new column is then added to the pivot table to calculate the number of days between today's date and the last time a client has had a positive balance.
