--- title: "Customize the event table | Darwinium" slug: "query-data-table" description: "Customize the Darwinium event table, choose displayed attributes, and work with the data returned by an investigation query." updated: 2026-10-16T02:27:22Z published: 2024-09-30T05:44:55Z canonical: "docs.darwinium.com/query-data-table" --- > ## Documentation Index > Fetch the complete documentation index at: https://docs.darwinium.com/llms.txt > Use this file to discover all available pages before exploring further. # Customize the event table The data table is a component found in Query and Journey tabs. It is a tabular view into the event storage database for investigations and analytics purposes. ### Columns Displayed All attributes in Darwinium on events form a hiearchy. See [Attribute Reference](/v1/docs/attribute-reference) for dictionary of these. New columns can be added to the data table by: 1. Ticking them in the column selection pane. Ticking a group heading will include all attributes within. 2. Drag and dropping attributes from column selection pane into the Data Table ![](https://cdn.document360.io/db6f7316-640d-4099-b5a1-b01b4dbd17fc/Images/Documentation/image-1657119682467.png?sv=2026-02-06&spr=https&st=2026-11-22T23%3A16%3A47Z&se=2026-11-23T00%3A16%3A47Z&sr=b&sp=r&sig=slmCB0kRxymF5Y54qS3FHXMH3Nqm8fevu4NcApCLc0s%3D) ### Column Order, Sort, Pinning , Width, Order: Column headings can be drag and dropped to change column order. Order defaults to that in column selection pane. Sort: The rows in Data Table can be sorted by clicking on any column header ![](https://cdn.document360.io/db6f7316-640d-4099-b5a1-b01b4dbd17fc/Images/Documentation/image-1657121458061.png?sv=2026-02-06&spr=https&st=2026-11-22T23%3A16%3A47Z&se=2026-11-23T00%3A16%3A47Z&sr=b&sp=r&sig=uGBuc6fkBj5NgY%2FF7K%2BnAFVWuCRlkfw%2F7jMzwg4f3lA%3D) Pinning: Columns can be pinned when past the dividing line on either side when scrolling data horizontally. Size: Any column width can be adjusted by 1. Holding and dragging the dividing line between column headings 2. Autosizing through the column header's menu ![](https://cdn.document360.io/db6f7316-640d-4099-b5a1-b01b4dbd17fc/Images/Documentation/image-1657120656568.png?sv=2026-02-06&spr=https&st=2026-11-22T23%3A16%3A47Z&se=2026-11-23T00%3A16%3A47Z&sr=b&sp=r&sig=4kqvK1ork6UrW1e2CKFXXq0daP%2Bkntxcn2ye0PG9H5g%3D) ![](https://cdn.document360.io/db6f7316-640d-4099-b5a1-b01b4dbd17fc/Images/Documentation/image-1657120707836.png?sv=2026-02-06&spr=https&st=2026-11-22T23%3A16%3A47Z&se=2026-11-23T00%3A16%3A47Z&sr=b&sp=r&sig=3T0ffenEWNM21Igdj0ALxl34dFTNZzUs%2Fo0n%2FBtX1SU%3D) Pin and Width options available in column header menu ### Virtual Columns - A virtual column allows you to apply a custom expression to manipulate data on existing attributes #### Steps create and view a Virtual Column - Click on Virtual Columns tab on the far right of the grid view. This will take you to the section to see all virtual columns ![](https://cdn.document360.io/db6f7316-640d-4099-b5a1-b01b4dbd17fc/Images/Documentation/image(196).png?sv=2026-02-06&spr=https&st=2026-11-22T23%3A16%3A47Z&se=2026-11-23T00%3A16%3A47Z&sr=b&sp=r&sig=78T13q2%2FMnTxt83d2xewE%2FhSPxRR35Dpvy7wQStZlnc%3D) - To create a new Virtual Column click on “Add New” button ![](https://cdn.document360.io/db6f7316-640d-4099-b5a1-b01b4dbd17fc/Images/Documentation/image(197).png?sv=2026-02-06&spr=https&st=2026-11-22T23%3A16%3A47Z&se=2026-11-23T00%3A16%3A47Z&sr=b&sp=r&sig=QBfYqev1ymVUi9s4aV90Op6NU6mzhHEfbrBLbqUP1mk%3D) - Give the virtual column a name in the “Name” box, input your expression in the “Expression” box & press the “Save” button ![](https://cdn.document360.io/db6f7316-640d-4099-b5a1-b01b4dbd17fc/Images/Documentation/image(198).png?sv=2026-02-06&spr=https&st=2026-11-22T23%3A16%3A47Z&se=2026-11-23T00%3A16%3A47Z&sr=b&sp=r&sig=y9cXaY0AnQIcoxEjsprezEGDVlDlrLmT1dsPAamG9n8%3D) - To view the Virtual column in the grid click on Columns tab on the far right of the grid & then select the Virtual Attribute/s you are interested from the Virtual group heading ![](https://cdn.document360.io/db6f7316-640d-4099-b5a1-b01b4dbd17fc/Images/Documentation/image(200).png?sv=2026-02-06&spr=https&st=2026-11-22T23%3A16%3A47Z&se=2026-11-23T00%3A16%3A47Z&sr=b&sp=r&sig=m6KzxhnvCgyuIdoSKgWcbF9hNswQ1oW%2Fx2gjAZAfDEw%3D) ### Column Color Formatting The palette color of columns and cells in Data Table can be changed according to conditional rules ![](https://cdn.document360.io/db6f7316-640d-4099-b5a1-b01b4dbd17fc/Images/Documentation/image-1657121825248.png?sv=2026-02-06&spr=https&st=2026-11-22T23%3A16%3A47Z&se=2026-11-23T00%3A16%3A47Z&sr=b&sp=r&sig=iBore76RX%2FZ%2BSLSy0UZ7Qjsn2IGvr5cihdE0kkj2IlM%3D)Selecting an attribute and Add Rule opens up the conditional formatting editor. #### Single Color Apply color based on boolean rule conditions. ![](https://cdn.document360.io/db6f7316-640d-4099-b5a1-b01b4dbd17fc/Images/Documentation/image-1657121898702.png?sv=2026-02-06&spr=https&st=2026-11-22T23%3A16%3A47Z&se=2026-11-23T00%3A16%3A47Z&sr=b&sp=r&sig=apICLmRI85YeerdLIkj0ldB5PZQppP%2Bs1hlNqy2%2BLgI%3D) - Apply palette to: - Grid ticked, formatting will apply to all attributes - Unticked, will just apply to the column attribute - If Attribute: Logic applied to the value of the attribute to determine if should be colored ![](https://cdn.document360.io/db6f7316-640d-4099-b5a1-b01b4dbd17fc/Images/Documentation/image-1657122190774.png?sv=2026-02-06&spr=https&st=2026-11-22T23%3A16%3A47Z&se=2026-11-23T00%3A16%3A47Z&sr=b&sp=r&sig=wp7WsDl0DD6EX%2FFDMIUL4Oyq6gAkL1q%2Fz6FONkIC1Zs%3D) - Color: Color to apply. Can be selected from color picker or input as hex color code #### Color scale Apply color based on continuous value. Best for numeric attributes. ![](https://cdn.document360.io/db6f7316-640d-4099-b5a1-b01b4dbd17fc/Images/Documentation/image-1657122790752.png?sv=2026-02-06&spr=https&st=2026-11-22T23%3A16%3A47Z&se=2026-11-23T00%3A16%3A47Z&sr=b&sp=r&sig=nfGl%2FhpowDGpMgFWYNjX%2BuKanpIjPI5jyoJq2DTFgr8%3D) - Preview: Shows color distribution that will be applied - Min/Mid/Max points: Define anchor points for color scale 1. Min/Max Value: Automatically detect and use min/max value of attribute 2. Number: Manually assign attribute value dictating color 3. Percent: Assign color point based on % of max value of attribute ### Template A template can be stored of the columns present, width, size, pinning, custom colors ![](https://cdn.document360.io/db6f7316-640d-4099-b5a1-b01b4dbd17fc/Images/Documentation/image-1657132404778.png?sv=2026-02-06&spr=https&st=2026-11-22T23%3A16%3A47Z&se=2026-11-23T00%3A16%3A47Z&sr=b&sp=r&sig=6t5em%2BSQjSQ9zRtozwtJ3f%2Byv07UEsx%2BZ9zVbhxqQTA%3D) Selecting the template will restore the view of the data table ![](https://cdn.document360.io/db6f7316-640d-4099-b5a1-b01b4dbd17fc/Images/Documentation/image-1657132424694.png?sv=2026-02-06&spr=https&st=2026-11-22T23%3A16%3A47Z&se=2026-11-23T00%3A16%3A47Z&sr=b&sp=r&sig=UIu44YL95XaOhBtudpENuNz3%2F%2BxqsPCKU52lWyspVcY%3D)