Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn More

View all

Sign in to view all badges

In workspace, how can I put hour of day on the x axis?

Avatar

Avatar
Validate 10
Level 3
mooreevan
Level 3

Likes

14 likes

Total Posts

48 posts

Correct Reply

1 solution
Top badges earned
Validate 10
Validate 1
Boost 5
Boost 3
Boost 10
View profile

Avatar
Validate 10
Level 3
mooreevan
Level 3

Likes

14 likes

Total Posts

48 posts

Correct Reply

1 solution
Top badges earned
Validate 10
Validate 1
Boost 5
Boost 3
Boost 10
View profile
mooreevan
Level 3

27-06-2018

I'd like to make a line chart with the x axis consisting of hours of the day, and each line on the chart a different day. The Y axis would obviously be a variable metric. How can I accomplish this? See Excel chart for what I'd like, and a few screenshots of workspace projects that have failed - the x axis is always a date. I'd settle for a bar chart if that's what I can get, but line chart would be best. Thanks!

What I want.pngbad1.PNGbad2.PNGbad3.PNG

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar
Boost 5
Level 4
nikitaf2673776
Level 4

Likes

37 likes

Total Posts

70 posts

Correct Reply

32 solutions
Top badges earned
Boost 5
Boost 3
Boost 25
Boost 10
Boost 1
View profile

Avatar
Boost 5
Level 4
nikitaf2673776
Level 4

Likes

37 likes

Total Posts

70 posts

Correct Reply

32 solutions
Top badges earned
Boost 5
Boost 3
Boost 25
Boost 10
Boost 1
View profile
nikitaf2673776
Level 4

27-06-2018

First create Date Ranges (the purple components) for each of the days you want to compare in your chart. Then create a table with the new Date Ranges and your metric. Then highlight the cells, right click and visualize.

1517204_pastedImage_0.png

Answers (1)

Answers (1)

Avatar

Avatar
Validate 10
Level 3
mooreevan
Level 3

Likes

14 likes

Total Posts

48 posts

Correct Reply

1 solution
Top badges earned
Validate 10
Validate 1
Boost 5
Boost 3
Boost 10
View profile

Avatar
Validate 10
Level 3
mooreevan
Level 3

Likes

14 likes

Total Posts

48 posts

Correct Reply

1 solution
Top badges earned
Validate 10
Validate 1
Boost 5
Boost 3
Boost 10
View profile
mooreevan
Level 3

27-06-2018

This is great, thank you!

For anyone else that finds this, you may need to choose to view your line chart by hour in its settings.