Expand my Community achievements bar.

Join us for the next Community Q&A Coffee Break on Tuesday April 23, 2024 with Eric Matisoff, Principal Evangelist, Analytics & Data Science, who will join us to discuss all the big news and announcements from Summit 2024!

How do you create a visual that updates with sales throughout the day

Avatar

Level 1

when i worked somewhere previously, a colleague created this dashboard for a high demand product and we could see the sales and the adds update all day (maybe using the hour of day metric) and then we could see it as a visual and then either we could refresh or it would refresh by the hour. i cannot remember what metrics are needed to do this and then to create the visual after. any ideas welcome.

Topics

Topics help categorize Community content and increase your ability to discover relevant content.

3 Replies

Avatar

Community Advisor

I think there are a couple of different ways you could approach this.

You could build a workspace project for the current day and breakout by hours so you could see the key product sales volume throughout the day.

Depending upon the audience, this could also be a good use case for a mobile scorecard.

Here are example screenshots for each approach with demo data.  Also note that the data in Analytics has a delay, typically around an hour. 

Josh__Stephens_0-1712243480329.png

Josh__Stephens_1-1712243834236.png

 

 

Avatar

Level 4

Just a a not on this, adobe runs about 45 mins behind real time in my experience. 

Avatar

Community Advisor

In addition to the point about the 45 min delay to process data, you might want to use some custom date logic to only show up to the last hour of the day, and maybe compare the previous day up to the same hour.

 

You can set you "current" date range to:

Jennifer_Dungan_0-1712258249863.png

 

And if you are comparing to yesterday, you can add a custom date comparison of:

Jennifer_Dungan_1-1712258548212.png

 

 

This will at least hide all the empty rows, but that last hour of today may still be partial data due to the latency.

 

Jennifer_Dungan_3-1712258803182.png

 

But at least I am not comparing the full yesterday to the partial today, and when not comparing you won't have all the empty rows that haven't happened yet.