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

[Peter_Luba]

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.

[Bill_French]

Hi Peter, and welcome to the community!

Peter_Luba:

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.

Two ways -

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

[Peter_Luba]

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

[Bill_French]

Peter_Luba:

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.