Date: Thu, 28 Mar 2024 13:01:09 +0000 (UTC) Message-ID: <1940541193.3483.1711630869607@docs.stiltsoft.com> Subject: Exported From Confluence MIME-Version: 1.0 Content-Type: multipart/related; boundary="----=_Part_3482_1452735893.1711630869606" ------=_Part_3482_1452735893.1711630869606 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Content-Location: file:///C:/exported.html
= &nbs= p; The= Source Table:
= &nbs= p; &n= bsp; The Result:
Find more information about the Co= nfiForms app on the documentation site= and in the Quick tutorial on how to = use ConfiForms TableView and ConfiForms Field to show the data in a table f= ormat.
Table Filter & ConfiForms TableView
1. Add the Table Filter macro<= /a> to the ConfiForms TableView macro.
Table Filter helps you to filter data, set default sorting, freeze r= ows and columns, calculate totals <= span>and more.
2. Add filters t= o the table columns and set filter values.
Pivot Table & ConfiForms TableView
3. Add the Pivot table macro to the ConfiForms TableView macro with filtered data.
Pivot Table allows you to sum=
marize and aggregate your table data.
You can select the following operations: Sum, Count, Min, Max, =
Average, Literal.
Chart from Table & ConfiForms TableView
5. Add the Chart from Table macro <= span style=3D"color: rgb(51,51,51);">to the already filtered and aggregated= ConfiForms TableView= macro to visualize data with the help of charts and graphs.=
You can change the filtration crit=
eria, the pivot table and chart parameters on the fly.
The changes will be automatically applied to t=
he data from the Office Excel macro.
In this use case filtered data, the pivot table and chart will be a= utomatically updated when the ConfiForms Form is filled in.
Table Transformer & ConfiForms TableView
1. Ad= d the Table Transformer macro to ConfiForms TableView.
You can place one or multiple tables within the ma= cro body to merge= , look up them or to perform custom calculations.
2. Select one of the presets or switch to the SQL query tab to use a custom = SQL query.
This SQL query allows you to create a new c= olumn with data outputted by condition.
SELECT = *,=20 CASE=20 WHEN 'Desired salary'<2000 THEN "Approved" ELSE "Not approved" END AS 'Results' FROM T*
You can use the ConfiFo= rms TableView mac= ro with each of our macros separately or combine them according to your nee= ds.