19 results about "Pivot table" patented technology

Provided are an information display method and apparatus, and an electronic device and a storage medium. The method comprises: displaying table data, wherein the table data comprises at least one data object and at least one piece of basic statistical information corresponding to the data object (S101); and in response to receiving a trigger instruction, generating conclusion information corresponding to the table data, and displaying same, wherein the conclusion information comprises text information and corresponding chart information, the chart information is a result of graphical processing corresponding to the text information, and the chart information at least comprises a chart and / or a pivot table (S102).

The present application provides a data query method, a data query device and an electronic device. The data query method includes: receiving a natural language question input by a user through a user terminal; determining a query statement fragment set based on the natural language question, wherein the query statement fragment set includes fragments of statements in a database query language; searching for target data based on the query statement fragment set; determining a target presentation method from a plurality of presentation methods according to the target data, wherein the plurality of presentation methods include a chart form, an ad hoc query table form and a pivot table form; and sending a query result including the target data and the target presentation method to the user terminal, so that the user terminal displays the target data according to the target presentation method. Determining the target presentation method of data based on the queried data can make the presentation of the data more reasonable, thereby facilitating user viewing. Performing data queries in this way can improve the user experience.

Embodiments of the disclosure disclose a method, apparatus and electronic device for data querying. The method includes: traversing data records of a target data source; for each target data record, obtaining, based on an aggregation basis dimension of the target data source, a target aggregation basis path corresponding to the target data record, and updating, based on dimension types and dimension values of the target data record in aggregate computation dimensions, summarized values, corresponding to a plurality of summary types, of the target aggregation basis path in the aggregate computation dimensions in a data pivot table of the target data source; and after the data records of the target data source are traversed, performing a data pivot service of the target data source based on the data pivot table.

The application discloses a kind of based on RPA realization Excel data pivot table pickup method, including RPA robot, including the following steps: S1, application RPA robot reads the data pivot table in original Excel;S2, data pivot table is set event listening;S3, return to original Excel and click data pivot table relevant area, obtain the entire data pivot table of this sheet, then determine the data pivot table object selected currently;S4, according to data pivot table object, the encoding information of data pivot table is loaded into the program of RPA robot;S5, using RPA robot, the pivot table setting rule corresponding to encoding information is applied to current Excel object.The present application can obtain existing data pivot table configuration information, and then be applied to other arbitrary Excel by RPA robot, improve the automation execution efficiency of RPA.

The present disclosure provides a method, device, equipment and medium for visualizing a pivot table, the method comprising: obtaining a pivot table, the pivot table having one numerical field and at least two row and column fields; generating a corresponding data cross table according to the row and column fields; generating a source data table of a visual analysis result of the pivot table according to the data cross table; determining a recommended chart type corresponding to the source data table according to table data of the source data table; generating a chart conclusion of the source data table according to a first quantity value of a series in the source data table; and outputting the visual analysis result of the pivot table according to the source data table, the recommended chart type and the chart conclusion.

An enhanced user experience is disclosed herein that provides for gesture-based configuring of pivot tables. In various implementations, a pivot table includes query areas associated with fields of a data table being summarized by the pivot table. Gestures made with respect to an area of the pivot table drive changes in the association of the fields of the data table with the query areas of the pivot table. As user input is received with respect to an area of the pivot table, relevant fields are identified, and new associations are made between the query areas and the fields. The pivot table may then be updated accordingly based on the new associations.

The application discloses a processing method and device of a pivot table, electronic equipment and a readable storage medium, and the method comprises the following steps: acquiring a pivot table, wherein the pivot table has one numerical field and at least two row and column fields; generating a corresponding data cross table according to the row and column fields; and generating a source data table of a visual analysis result of the pivot table according to the data cross table.

The disclosed technology creates a range of manual to automated ways of setting up and verifying the correct joining of data sets for use generating spreadsheet pivot tables. Handling pairing of data sets and then chaining / sequencing of joins resulting in joins of three or more data sets. Limiting joins to keys with matching data types and matching data values. Limiting joins, as desired, to data value matching criteria and data modelling cardinality requirements. Allowing the qualification of the data sets for joining to be done within or before spreadsheet pivot input panel. Making the qualified joinable data sets available in situationally intelligent data field / range selection lists for use populating the pivot table inputs. Availing those joined data fields / ranges to be used to generate spreadsheet pivot tables.

This invention relates to graphical user-interactive analysis of data, including in particular, mass spectrographic data analysis, as well as methods and software for generating and using such. One aspect provides user-customizable reports, including methods and apparatuses for generating customizable pivot tables and graphs specific to mass spectrographic data.

Described are systems and methods for rendering a three-dimensional (3D) pivot table that can be embedded in a spreadsheet. A data structure underlying the 3D pivot table contains raw data organized in arrays that can be depicted as two-dimensional (2D) tables. A rendering system combines some or all of the 2D tables into a 3D rendering of a pivot table in which each of the combined sides represents a visible face of the 3D pivot table. A user can split the rendered 3D pivot table along one or three axes to expose internal data elements for viewing or editing. Changes to the values of internal data elements impact values presented in the visible faces of the 3D pivot table.

Systems and methods of user-interactive analysis of analytical data, such as mass spectrographic data and chromatography data. One aspect provides user-customizable reports, including methods and apparatuses for generating customizable pivot tables and graphs specific to the analytical data.

The present disclosure provides a data processing method, device and electronic equipment, a specific embodiment of the method includes: obtaining a plurality of filtering conditions for filtering data in a target data table and a logical relationship between the plurality of filtering conditions; determining a first value corresponding to each filtering condition in the plurality of filtering conditions, the first value corresponding to any filtering condition being determined by at least one first record obtained according to the filtering condition; performing a logical operation based on the first value and the logical relationship between the plurality of filtering conditions to determine a target record to generate a pivot table. This embodiment can simplify the process of generating a pivot table and improve the speed of generating a pivot table.

This invention relates to graphical user-interactive analysis of data, including in particular, mass spectrographic data analysis, as well as methods and software for generating and using such. One aspect provides user-customizable reports, including methods and apparatuses for generating customizable pivot tables and graphs specific to mass spectrographic data.

Methods, systems, and devices for integrating a pivot table in a logical-to-physical mapping of a memory system are described. The memory system may receive a read command and read a first entry of a first subset of mapping and a second entry of a second subset of mapping. The second entry may include at least a portion of a pivot table associated with physical addresses of a non-volatile memory device. The memory system may retrieve data from a physical address identified in the pivot table, rather than access a different portion of the logical-to-physical mapping. The memory system may transmit, to a host system, the data retrieved from the physical address identified in the pivot table.

The invention provides a real-time perspective table generation method and system based on dynamic dimension constraint in the technical field of perspective table generation, and the method comprises the steps: S1, reading dimension data and index data from a database, and displaying the dimension data and the index data in a tree structure in a data source region; s2, dragging the dimension data or the index data of the data source area to a data display area for display; s3, carrying out attribute configuration on the dimension data and the index data in the data display area; s4, performing data analysis operation on the dimension data and the index data in the data display area to obtain a data analysis result; s5, configuring the operation authority of the perspective table; and step S6, rendering the dimension data, the index data and the data analysis result in the data display area by the perspective table configuration interface, and outputting and displaying the generated perspective table. The method has the advantages that the efficiency, the flexibility and the real-time performance of perspective table generation are greatly improved.

The invention discloses a data perspective table processing method and device. The method comprises the following steps: summarizing and displaying to-be-displayed data in a data perspective table according to a plurality of dimension fields; classifying the to-be-displayed data according to data contents to obtain a plurality of dimension fields; the display area of the data perspective table is divided into a row field, a column field, a screening field and a data field; the data field is used for displaying the value of the dimension field and statistical summary; when an adjustment instruction of a user for any dimension field is monitored, displaying a data perspective table adjustment result in real time according to the adjustment instruction; the adjustment instruction is used for carrying out interactive data operations such as dragging, sorting and screening on a data perspective table; the method can be realized only through a front end. The perspective table adjustment result can be displayed in real time according to adjustment of a user, the operation complexity is reduced, the user experience is improved, and the data analysis efficiency is improved.

The invention relates to the technical field of data filling and reporting, in particular to a data filling and reporting method and a data filling and reporting system applying the same, and the data filling and reporting method comprises the following steps: S1, initializing the data filling and reporting system; s2, creating a report by calling a database table, a model and a data set according to the business condition, making a perspective table through source data in the report, pulling corresponding dimensions according to the business condition to perform screening, and generating a template and a corresponding search condition through combination of columns, rows and values; s3, performing batch filling and reporting of multi-dimensional data for corresponding role personnel according to the divided templates and the corresponding search conditions; s4, after the role personnel complete filling and reporting, the filled and reported data is transmitted back to the database table; and S5, splitting and analyzing the returned data by the data filling and reporting system. The method is high in self-definition degree and compatibility, high in real-time performance, convenient to improve filling efficiency and cooperation efficiency, high in safety coefficient and capable of reducing labor intensity of operators.

The invention discloses a method, a device and equipment for converting a perspective data table and a general data table, and relates to the technical field of spreadsheets. The specific implementation scheme comprises the steps of receiving a first range; determining that the first range comprises the table cells of the general data table, and generating structured data according to the table cell data of the first range, the target header field and the target data area field; determining a rendering tree according to the structured data, a preset row title field, a preset column title field and a preset data area field; generating a data perspective table and a mapping relation according to the rendering tree; and / or determining that the first range comprises cells of the data perspective table, and generating a general data table according to the rendering tree corresponding to the data perspective table and the mapping relation. According to the method and the device, the calculation amount when the data perspective table is generated can be reduced, the efficiency is improved, the function of re-converting partial content in the generated data perspective table into a general data table is realized, and the user experience is improved.

Methods, systems, and devices for integrating a pivot table in a logical-to-physical mapping of a memory system are described. The memory system may receive a read command and read a first entry of a first subset of mapping and a second entry of a second subset of mapping. The second entry may include at least a portion of a pivot table associated with physical addresses of a non-volatile memory device. The memory system may retrieve data from a physical address identified in the pivot table, rather than access a different portion of the logical-to-physical mapping. The memory system may transmit, to a host system, the data retrieved from the physical address identified in the pivot table.