Forum Discussion

nchand's avatar
nchand
Regular Visitor
4 years ago
Solved

Convert to 30min interval

Hello All,   I am trying to plot a line graph with two variables—time in 30min intervals on the x-axis and count of #ppl in that time frame.   How to convert this column to represent time in ever...
Need Help
  • NickolajJessen's avatar
    NickolajJessen
    4 years ago

    You can make it easily:
    1. Adjust the formulas to AM PM format

    2. Create a table in power query with you categories and add index (make sure to filter cate category by the index)

    3. Create relationship between the two tables
    4. Voila

     

     

     

     

     

NickolajJessen's avatar
NickolajJessen
Solution Sage
4 years ago

You can make it easily:
1. Adjust the formulas to AM PM format

2. Create a table in power query with you categories and add index (make sure to filter cate category by the index)

3. Create relationship between the two tables
4. Voila

 

 

 

 

 

nchand's avatar
nchand
Regular Visitor
4 years ago

I have a doubt in this. When we say this

Table[Timestamp]<TIMEVALUE("08:00"), "8;00am"
Table[Timestamp]<TIMEVALUE("08:30"), "8;30am"

If I had a 06:30 in the Timestamp column. what will it be considered? 8 or 8;30am?  

  • NickolajJessen's avatar
    NickolajJessen
    Solution Sage
    4 years ago

    That's a great questions!
    it returns the first value that is TRUE

    Table[Timestamp]<TIMEVALUE("08:00"), "8;00am" // This is true // AND THIS IS FIRST
    Table[Timestamp]<TIMEVALUE("08:30"), "8;30am" // This also true, but is never evaluated, beause the first the first was true