Report for hour of the day | Community
Skip to main content
A
AEPAA
Level 4
January 15, 2024
Solved

Report for hour of the day

  • January 15, 2024
  • 1 reply
  • 2036 views

Hi everyone,

I need to visualise the report where hour of the day in dimension and visits with 2 date ranges column . Today and day before yesterday..

When , I tried line visualisation, the each hours in dimension in visits are showing different line.

Can anyone tell me how this can be done?

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by Jennifer_Dungan

I have thrown together a small sample using demo data:

 

 

 

Even when using "Hour" dimension, Adobe will generally combine the hours for comparison like so:

 

 

Is this what you are getting? If not, can you share a screenshot (you can block out values for privacy purposes)? 

1 reply

MandyGeorge
Community Advisor and Adobe Champion
MandyGeorgeCommunity Advisor and Adobe Champion
Community Advisor and Adobe Champion
January 15, 2024

Hi @aepaa ,

Correct me if I misunderstood your ask, but it sounds like you've got hour as a dimension down the side, visits as a metric across the top, and then two date ranges filtering the metric. Are you using date as a dimension, or the custom date ranges (the purple ones)? With the error you're getting, it leads me to believe that you're using the day dimension. Workspace gets a bit picky about how it displays stuff like that. When you're using the actual dimension and breaking it down by hour, it recognizes the dimension as having occurred at different times and adjusts accordingly. If you switch to using the purple date ranges instead, it should give you a graph where both days are trended together. 

    A
    AEPAAAuthor
    Level 4
    January 15, 2024

    Hi @mandygeorge ,

    I am using dimension - hour of the day.

    And yes visits filtered on two custom date ranges.

    I am supposed to get 2 lines in the line chart but then , I am getting multiple lines.

    Jennifer_Dungan
    Community Advisor and Adobe Champion
    Jennifer_DunganCommunity Advisor and Adobe ChampionAccepted solution
    Community Advisor and Adobe Champion
    January 15, 2024

    I have thrown together a small sample using demo data:

     

     

     

    Even when using "Hour" dimension, Adobe will generally combine the hours for comparison like so:

     

     

    Is this what you are getting? If not, can you share a screenshot (you can block out values for privacy purposes)? 

      Terms & ConditionsAccessibility statement

      Loading footer...