June 2024
Last updated
Last updated
We've introduced a third standard snippet option in sheets, expanding the previous two to now include:
Standard Input Snippet (shown by Sheet Name): This is used for inputting and uploading data directly into the sheet.
Standard Data Snippet (shown by Sheet Name + "Data"): This snippet is for reviewing the raw data contained in the sheet/model.
Standard History Snippet (shown by Sheet Name + "History"): This is used for reviewing the audit history of data changes.
Previously, users couldn't create an Input snippet for a sheet. However, with this update, the Create Snippets option now allows you to add an Input for any sheet, enhancing flexibility in data management.
Learn more about here.
The date datatype for metrics in sheets supports operations such as adding or subtracting days to get a new date (Date +/- Number = Date), and subtracting one date from another to find the number of days between them (Date - Date = Number). Additionally, you can compare two dates to determine if one is greater, less, or equal to the other, which is useful for sorting, filtering, or setting conditions based on dates.
User can now add NetSuite as new Connection under Connections Setup. User can add a Metric as Input or Output to any of the dataflow like the usual dataflow connection. For this, user can select Metric from the Sheet section in Dataflow Object List when creating dataflow. Metric here will be similar to MEASURE in model.
As an enhancement to Remote table, user can now created table based on Define SQL Query. When adding new remote table in Table set, now user will have option to define the source as Query instead of Table or View. After select Query, user can put the query in Popup along with Table Name and Table Description, User can also add Parameter to use as Filter condition for loading rules.
Learn more about , here.