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...
Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
10 years ago

Why would the first option need repeated work? If you have a related table with time_range and time_range_sort, then that table should be absolutely static within your data model.

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.

  • v-caliao-msft's avatar
    v-caliao-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    10 years ago

    Could we consider to omit the “-” here?

     

    Or consider replace the “- ” with a special number like “0” ?

     

    There is no available data types that would make the time range here (with the “-” inside numbers) to format as number type.

    Also as you already suggested, create another column to give a manually rank seems to be a more suitable way.

     

    Regards,

    Charlie Liao