Skip to main content

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.

3 replies

Forum|alt.badge.img+19
  • Inspiring
  • 3264 replies
  • November 14, 2020

Hi Peter, and welcome to the community!

Two ways -

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

  • Author
  • New Participant
  • 1 reply
  • November 14, 2020
Bill_French wrote:

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


Forum|alt.badge.img+19
  • Inspiring
  • 3264 replies
  • November 14, 2020
Peter_Luba wrote:

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.


Reply