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

     

     

     

     

     

  • nchand's avatar
    nchand
    Regular Visitor
    4 years ago

    Thanks for this solution. will use this if I cannot make it to this format below: (not sure how to aggregate to this model tho)

    • 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?