Overview
The Office 365 Kloudio Function enables users to return a single piece of data to a cell, a single column, multiple columns, or the entirety of a Report.
If you’ve installed the Kloudio add-in directly from Excel and not from the Office 365 Store please see the Excel Kloud Function documentation.
Usage
In order to use the Kloudio Function, you must have the Office 365 Kloudio add-on installed. You must also have a report created or shared with you from the Kloudio portal, app.kloud.io.
Example: Return a Full Report
To select a full report, use an empty string for the second parameter. Do not omit the second parameter as it is required.
=Kloudio.Report(Report Name, Column to Return, Filter Column, Value)
In this Example: Report Name = Qtr_Act Column to Return = “” empty string will select all Filter Column = omitted Value = omitted Function call: =KLOUDIO.REPORT(“Qtr_Act”, “”) |
Example: Return a Single Piece of Data
=Kloudio.Report(Report Name, Column to Return, Filter Column, Value)
In this Example: Report Name = KloudFunctionReport Column to Return = product Filter Column = company Value = Wikizz Function call: =KLOUDIO.REPORT(“KloudFunctionReport”, “product”, “company”, “Wikizz”) |
Example: Return a Single Column
=Kloudio.Report(Report Name, Column to Return, Filter Column, Value)
In this Example: Report Name = Qtr_Act Column to Return = fiscalqtr Filter Column = omitted Value = omitted Function call: =KLOUDIO.REPORT(“Qtr_Act”, “fiscalqtr”) |
Example: Return Multiple Columns
Multiple columns can be returned by including them in a comma separated list in the second parameter.
=Kloudio.Report(Report Name, Column to Return, Filter Column, Value)
In this Example: Report Name = Qtr_Act Column to Return = fiscalqtr and account parent. Filter Column = omitted Value = omitted Function call: =KLOUDIO.REPORT(“Qtr_Act”, “fiscalqtr,account parent”) |
Summary
The Kloudio Function in Office 365 is extremely flexible allowing pre-made reports to be returned in full or desired selections. This pre-filtering allows for advanced use cases and prevents limitations in excel from large datasets.
If you have further questions on the Office 365 Kloudio Function, please contact us at support@kloud.io