Categories

###### Using formulas in spreadsheets

Conduit offers two ways to transfer data to spreadsheets: Building block “Save dataset to Google Sheets” Formulas In this article, I will talk about using formulas. Conduit supports two formulas to be used in Google Sheets. REPORT - Place a table to a spreadsheet METRIC - Place a single metric to a spreadsheet REPORT The Report formula copies a table from Conduit into a spreadsheet. It has four parameters: report startdate days rowcount report- data sourSome readers###### Time range in formulas

Every REPORT and METRIC formula has a time range. In order to guarantee high speed of processing the time range has a limit. By default the limit is 30 days. You can change it. There are two ways to define a time range for the formula: Direct parameters of the formulas Set a time range for the workflow The first approach is better for the “production” spreadsheets. The second approach is better for prototyping, because you don’t waste your time on entering these parameters. DirectFew readers