Pam

I'm trying to create a query in Explore that just shows the number of average daily tickets created over the last year.

So far I created the query below and added a Total Result Manipulation > all columns > average. That gives me a column with the daily average over a specified time period (which is great!), but I just want a text box that spits out a single number without me having to hide a bajillion columns from the past year's daily data. 

Does that make sense? I'm trying my best to do my due diligence for Explore 😅