反馈已提交

网络繁忙

You are viewing 5.1 help doc. More details are displayed in the latest help doc.

Crosstab component style

  • Recent Updates: April 26, 2022
  • 1 Overview

    1.1 Version

    FineBI versionJAR package versionFunction changes
    5.1.52020-08-04Show/hide total rows in the group
    Style type increased list display
    Row and column summary name display optimization
    5.1.52020-09-02Optimized aggregate method/interactive attribute display
    5.1.82020-12-04Title setting entry changes
    5.1.102021-02-05Converting dimensions into indicators  and calculating indicators using the COUNTD_AGG function, when setting the "Total Method", the default is "Sum"
    5.1.112021-04-02Adjust the setting "Whether the title is displayed" entry
    5.1.12-The total rows/columns in the group supports custom setting of the total dimension
    5.1.14-Extract the data version "number of records", use  COUNT_AGG , COUNTD_AGG to  get the calculated fields, when setting the "total method", the default is "automatic"

    1.2 Application scenarios

    When the user needs to adjust the appearance and font of the table, the table component can be used.

    1.3 Function introduction

    The crosstab can set styles for the table font, Table Row height, style, Total Rows/Columns, format, background, and Interaction Properties, as shown in the following figure:

    1.png

    Setable crosstab component style itemsCorresponding function document
    Table fontTable font
    Table Row heightTable Row height
    StyleStyle
    Total rows/columnsSee Chapter 2 of this article for details
    FormatSee Chapter 3 of this article for details
    backgroundbackground
    Interaction PropertiesInteraction Properties

    2. Table title display

    Click "Component Style", you can first set whether to display the component title. If you uncheck this box, the component title will not be displayed, as shown in the following figure:

    2.png

    If you need to modify the content of the component title, please refer to: Component Title.

    3. Total rows/columns

    Click the total rows/columns drop-down box and then the user can customize total rows/columns. Custom selection of which dimensions need to display the total rows/columns is supported, as shown in the following figure:

    3.png

    The total rows setting is the same as the group table. For details, please refer to: Total Rows.

    In the crosstab, the functions of displaying and setting the position of the total columns are added and the usage of the total columns is similar to that of the total row, as shown in the following figure:

    4.png

    4. Format

    Click the format drop-down box, you can set up the number of pagination lines, number of pagination columns and display serial number, expand row header node, expand list head node, freeze table dimensions of crosstab.

    5.png

    Among these, the ways of setting up number of pagination lines, displaying serial number, expandding row header node, freezing table dimensions are consistent with that of group table, please refer to the format for details. 

    4.1 Number of Page Columns

    Number of pagination columns is used to set how many columns are displayed on each page of the table in addition to the dimension field column and the total column.

    For example: set the number of paging columns to 3 and then only 3 columns of data are displayed on each page, as shown in the figure below:

    Note: When there is only one page in the table data, the page number information at the bottom will not be displayed. When there is more than one page, the page number information and the page turning button are displayed normally.

    6.png

    4.2 Expand the head node of the list

    When there is more than one column dimension, you need to expand column dimensions to see all nodes. Check "expand list head node", as shown below:

    Attachment List


    Theme: Build Charts and Analyze data
    Already the First
    Already the Last
    • Helpful
    • Not helpful
    • Only read

    售前咨询电话

    400-811-8890转1

    在线技术支持

    在线QQ:800049425

    热线电话:400-811-8890转2

    总裁办24H投诉

    热线电话:173-1278-1526

    文 档反 馈

    鼠标选中内容,快速反馈问题

    鼠标选中存在疑惑的内容,即可快速反馈问题,我们将会跟进处理。

    不再提示

    10s后关闭