Using grouping in data export templates: Difference between revisions

From Planfix
Jump to: navigation, search
 
No edit summary
 
(2 intermediate revisions by the same user not shown)
Line 1: Line 1:
In order to group data in output files, you need to use special variables. These variables are available in reports where there is grouping. For each grouping in the variable list, there is a variable with the format:
*'''Report.Column::Grouping N'''
where N is the sequence number of the grouping.
The sequence number is determined by the position of the particular type of grouping in the grouping list in the '''Selection parameters report''' tab. Look at these grouping settings, for example:
https://pic.planfix.ru/pf/MC/5J34jH.png
*Grouping by project will be number 1
*Grouping by task will be number 2
In the report export template, each variable for grouping is a column in an Excel table. For example, grouping by project and task in the template file could look like this:
https://pic.planfix.ru/pf/KL/lTjD5T.png
Export of report data with this template would look like this:
https://pic.planfix.ru/pf/pH/HKW9YW.png
== Go To ==
== Go To ==
*[[Data export templates for reports]]
*[[Data export templates for reports]]

Latest revision as of 06:52, 6 June 2020

In order to group data in output files, you need to use special variables. These variables are available in reports where there is grouping. For each grouping in the variable list, there is a variable with the format:

  • Report.Column::Grouping N

where N is the sequence number of the grouping.


The sequence number is determined by the position of the particular type of grouping in the grouping list in the Selection parameters report tab. Look at these grouping settings, for example:


5J34jH.png


  • Grouping by project will be number 1
  • Grouping by task will be number 2


In the report export template, each variable for grouping is a column in an Excel table. For example, grouping by project and task in the template file could look like this:


lTjD5T.png


Export of report data with this template would look like this:


HKW9YW.png


Go To