How can I apply rounding logic to time data – e.g. 1:39 PM should be 2 PM and 1:20 PM should be 1 PM.
Smarten - Solution Team
started a topic
over 2 years ago
Scenario:
We have flight data that has Flight Time upto Minute level. We also have weather data that has hourly weather parameters.
Requirement:
We need weather data for flight time with most nearer slots from weather data. For eg; if the flight time is between "1.30 - 2.30" it should come under 2'o clk slot.
Smarten - Solution Team
Scenario:
We have flight data that has Flight Time upto Minute level. We also have weather data that has hourly weather parameters.
Requirement:
We need weather data for flight time with most nearer slots from weather data. For eg; if the flight time is between "1.30 - 2.30" it should come under 2'o clk slot.
Please refer to the KB article below.
http://support.smarten.com/support/solutions/articles/9000190844-apply-rounding-logic-to-time-data
Smarten - Solution Team
Please refer to the KB article below.
http://support.smarten.com/support/solutions/articles/9000190844-apply-rounding-logic-to-time-data
-
How do I choose only required columns while creating a dataset with step by step wizard from any database
-
How do I select only the required columns after creating the dataset.
-
If we have join/union in the dataset then do we have to refresh the main dataset every time after i do any changes in the child(Join/Union) dataset.
-
How to convert timestamp based text formats to Timestamp
-
I'm Unable to display graph with financial month values (that starts from April)
-
How can I merge actual data in financial year, with Plan data in calendar year, and create plan vs actual data as per financial year
-
How can I count day wise new addition of counts from the data with day wise closing balance of counts?
-
Dataset Action Editor – Action item status (active or inactive) is not saved permanently
-
How can I create a dataset using stored procedures in RDBMS instead of a query?
See all 13 topics