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

Did this answer your question?