How do I select rows within a specific time range and create a new column using the selected rows?For example, I only wanted to select rows when the time is between 7pm-10pm. How do I create a column with the selected rows within the specified time range?
AnalyticsData TableOtherScriptingRe: How do I select rows within a specific time range and create a new column using the selected rows?Using the 'Hour()' function (see 'Help > Scripting Index'), you could add a new column with a formula such as:
Hour( :test_start_date ) >= 19 & Hour( :test_start_date ) <= 22
