Expand my Community achievements bar.

Webinar: Adobe Customer Journey Analytics Product Innovations: A Quarterly Overview. Come learn for the Adobe Analytics Product team who will be covering AJO reporting, Graph-based Stitching, guided analysis for CJA, and more!

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

Community Advisor

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.