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

Avatar

Avatar

mooreevan

Avatar

mooreevan

mooreevan

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

nikitaf2673776

Avatar

nikitaf2673776

nikitaf2673776

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

mooreevan

Avatar

mooreevan

mooreevan

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.