Building trends dashboard - advice needed

So I have a data source that contains a list of tables. For each table it has two columns - row count and table size in mb - both of which show the change from the previous day. I need to be able to show all the tables that have gone over the threshold of 10% increase compared to previous day. It would also be nice to visualize performance of each table on daily, weekly, monthly, yearly basis - i.e. how many rows have been added in that period and what percentage increase that is from the start of time interval. But most importantly visualization should flag any tables that have exceeded the threshold. Data ranges over the past 5 months, and refreshes each day.

What klip/powermetric structure (and dashboard structure) would you recommend? What's the best way to proceed in building it?


Please sign in to leave a comment.