Forum Discussion

rliu's avatar
rliu
Icon for Helper I rankHelper I
10 years ago

Rank text on X axis: Duration type

Hi everyone,   I am trying to plot a time series over 24 hours in a day. My x-axis data looks like this: 0-1 stands for the counts in 00:00-01:00 and 23-24 stands for 23:00-24:00.  To make su...
rliu's avatar
rliu
Icon for Helper I rankHelper I
10 years ago

 Hi Greg_Deckler,

So

1. when creating the time range order, don't I have to manually input 1-24 correspondingly?

2. the idea of using releted table sounds good. But I don't know how to do that. Can you elaborate it?

 

Thanks

Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
10 years ago

Yes, you would have to enter it one time manually. Easiest way to do this is to use Enter Data and just put in your time_range column and your time_range_sort column manually. Close that and set your "Sort By". Then use the Relationships pane (3rd icon down on the left-hand side in Desktop) and drag time_range column from one table to your new "lookup" table. Then, use the time_range column from your new "lookup" table in your visuals.