6 Replies Latest reply on Jul 5, 2018 4:36 AM by Zhouyi Zhang

Y-Axis in Hours - Custom Sorting

Gian Pedrun Jul 3, 2018 2:22 PM

Hi Tableau Champs out there

I'm struggling with something that you probably have a solution for it.

I have a data source with milestones per day that are reached, means for every day I have multiple records (for each milestone one) with ID of the milestone, a field for date (only date) and and time (HH:mm).

I want to show a trend graph (line) per day (on x-axis) and by hour (on y-axis), which is a quite easy thing. It looks like that:

Now, I want to have a custom sort on Y-Axis, means I want to start the Y-Axis at 20:00 to 24:00 (resp: 0:00) and then go one with 0:00 to 19:00, because it's an overnight procedure.

I have found a way by creating a calculated field, but the issue is that I have now numbers on the Y-Axis as label and I need to display hours.

test_file.twbx 25.2 KB

1. Re: Y-Axis in Hours - Custom Sorting

Zhouyi Zhang Jul 3, 2018 5:17 AM (in response to Gian Pedrun)

Hi, Gian

You probably can use format to format your calculation result as hh:mm:ss, but it will be good if you can share a sample workbook.

ZZ
Like Show 0 Likes(0)

Actions
2. Re: Y-Axis in Hours - Custom Sorting

nikher verma Jul 3, 2018 5:26 AM (in response to Gian Pedrun)

Hi Gian Pedrun ,

It would be better if you had been shared twbx file as it can be solved in many different ways .

I am not sure but you can solve it using dual axis chart and remove the number axis and keep only time axis .So you are just hiding the number axis and showing the time axis .

In case you stuck somewhere please attach your work .

-Nikher Verma
Like Show 0 Likes(0)

Actions
3. Re: Y-Axis in Hours - Custom Sorting

Gian Pedrun Jul 4, 2018 6:18 AM (in response to nikher verma)

Hi Nikher
I have added the twbx file.
I have tried things with dual axis but was not able to resolve it ;-(
Like Show 0 Likes(0)

Actions
4. Re: Y-Axis in Hours - Custom Sorting

Zhouyi Zhang Jul 4, 2018 6:25 AM (in response to Gian Pedrun)
Hi, Gian

Please find my solution attached.

Below is the screenshot of steps and result

Hope this helps

ZZ

test_file_v10.2.twbx 52.1 KB
Like Show 0 Likes(0)

Actions
5. Re: Y-Axis in Hours - Custom Sorting

Gian Pedrun Jul 5, 2018 1:59 AM (in response to Zhouyi Zhang)

Hey Zhouyi

Thank you very much for quick answer. The solution is so simple ;-)

Regards
Like Show 0 Likes(0)

Actions
6. Re: Y-Axis in Hours - Custom Sorting

Zhouyi Zhang Jul 5, 2018 4:36 AM (in response to Gian Pedrun)

No worries, glad it helped

ZZ
Like Show 0 Likes(0)

Actions