Excel like calculations on dashboard data

mgilfix

One of the great things about excel is that you can quickly create ad hoc calculations on data or extend some analysis with addition calculations. When looking at dashboards, I often want to do ad hoc calculations using data points on one or more graphs as part of a deeper root cause analysis or data exploration. Today, I would have to hover over the graphs from the cards to get my data points, then do a separate calculation to get my summary data. Doing this via cards would be tedious, might require extensive beast modes, and might even require manipulating the view of the data to fit into the visualization algorithm. It would be great if there was excel like graphical feature where you could pick data points on the graph and then use formulas like in excel for calculations in context in the dashboard.