Date: Thu, 28 Mar 2024 19:00:55 +0000 (UTC) Message-ID: <482077175.3551.1711652455820@docs.stiltsoft.com> Subject: Exported From Confluence MIME-Version: 1.0 Content-Type: multipart/related; boundary="----=_Part_3550_1302093404.1711652455819" ------=_Part_3550_1302093404.1711652455819 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Content-Location: file:///C:/exported.html
To build a pivot table you need to set the row labels and (or) column la= bels and select the calculated columns.
Row labels - table columns that will be positioned= horizontally in the pivot table.
Column labels - table columns that will be positio= ned vertically in the pivot table.
Calculated column - table columns that will be cal= culated or aggregated according to the selected operation type.
To select data series in the page view mode:
To select data series in the page edit mode:
When you select columns containing date or numeric values as the r= ow/column labels you may need to aggregate data by date or numb= er range :
You can generate a pivot table on Worklogs or Time Intervals. <= a href=3D"https://docs.stiltsoft.com/pages/viewpage.action?pageId=3D4223965= 3#Managingpivottableoptions-=E2=96=AASettheworklogsettings" rel=3D"nofollow= ">Set the correct worklog settings for the correct pivot tabl= e generation.
Counts the number of entries in the selected column.
Useful parameters:
Sums the numeric values in the selected column.
Useful parameters:
Counts the average values over the values in the selected column.
Useful parameters:
Multiplies the numeric values in the selected column.
Useful parameters:
Finds the minimal / maximal value in the selected column.
Useful parameters:
Outputs the list of unique values matching the selected criteria.
Useful parameters: