Calculate Summary Stats OVER TIME (change in summary stats as records get created)

Our table can calculate our conversion % using a summary stat (% Filled). How can we make a chart using an app that will show this % change over time, since we want to see how our conversion rate changes over time.

Hi Peter, and welcome to the community!

Two ways -

  1. The Chart app
  2. The new Vega-Lite app

Hey Bill, thanks for the quick reply. How in the chart app can I show this change over time? It seems like I can only see the actual summary stat

Impossible for me to answer without seeing and fully understanding your data model. It’s likely that some type of aggregation (see roll-ups) or possibly a script process will be required to prepare the data to be viz-ready.