Forum Discussion

onevagi's avatar
onevagi
Regular Visitor
2 years ago
Solved

Time Frame

Hi,   I have column which includes timeframe of 30 minutes for a day (Example: 00:00:00, 00:30:00, 01:00:00, 01:30:00.... till 23:30:00). I have created a Line and clustered column chart, the timef...
  • Alican_C's avatar
    Alican_C
    2 years ago

    You can use the following steps:

    1. Create a new calculated column to mark the rows that fall within the desired timeframe.

    2. Filter the visual by the use of new column

     

    1. Creating the calculated column:


    IsWithinTimeframe = IF(HOUR([TimeColumn]) >= 8 && HOUR([TimeColumn]) < 20,1,0)

     

    2. Filtering the data:

     

    • Go to the "Filters" pane.
    • Drag the new IsWithinTimeframe column to the "Filters on this visual" area.
    • Set the filter to only include rows where IsWithinTimeframe is 1.

     

     

Alican_C's avatar
Alican_C
Resolver II
2 years ago

You can use the following steps:

  1. Create a new calculated column to mark the rows that fall within the desired timeframe.

  2. Filter the visual by the use of new column

 

1. Creating the calculated column:


IsWithinTimeframe = IF(HOUR([TimeColumn]) >= 8 && HOUR([TimeColumn]) < 20,1,0)

 

2. Filtering the data:

 

  • Go to the "Filters" pane.
  • Drag the new IsWithinTimeframe column to the "Filters on this visual" area.
  • Set the filter to only include rows where IsWithinTimeframe is 1.

 

 

onevagi's avatar
onevagi
Regular Visitor
2 years ago

Hi,

 

Thank you so much for the help. It worked. Cheers 🙂