# Pigment

> Knowledge base documentation for Pigment.

## v1

- [Get Started](https://kb.pigment.com/docs/get-started-pigment.md): Welcome to Pigment! Explore our flexible planning tools, learn key terms, and start building Applications, Boards, and Blocks for your business success.
- [How Pigment’s product documentation supports your work](https://kb.pigment.com/docs/welcome-2.md)
- [Access the Pigment Workspace](https://kb.pigment.com/docs/access-pigment-workspace.md): Learn how to access the Pigment Workspace, sign in to your account, and navigate your Workspace once you’re logged in.
- [Sign In to Your Pigment Workspace](https://kb.pigment.com/docs/pigment-workspace-signin.md): Learn how to sign in to your Pigment Workspace, troubleshoot issues, and access your Applications with our step-by-step guide.
- [Navigate your Pigment Workspace](https://kb.pigment.com/docs/pigment-workspace-navigation.md): Master Pigment navigation with this guide to the Workspace homepage, sidebar tools, and efficient management of Boards and Blocks.
- [Pigment Academy](https://kb.pigment.com/docs/pigment-onboarding.md): Enhance your skills at Pigment Academy with courses on modeling, data integration, security, and certification to become a Pigment pro!
- [Pigment Applications Guided Tour: Resource Center](https://kb.pigment.com/docs/pigment-applications-guided-tour-resource-center.md): Explore Pigment Applications through an interactive tour. Use the Resource Center to learn layout, features, and how to get started.
- [Get Started in Pigment: Model Builder](https://kb.pigment.com/docs/get-started-pigment-model-builder.md): Get started in Pigment with this beginner-friendly guide for model builders. Discover key setup steps to launch your first model fast.
- [Get Started in Pigment: Business User](https://kb.pigment.com/docs/get-started-pigment-business-user.md): Discover how to get started in Pigment as a business user. Explore models, Boards, and planning tools to drive smarter decisions.
- [Learning Path: From Process to Experience: UX Design Journey](https://kb.pigment.com/docs/learning-path-from-process-to-experience-ux-design-journey.md): Optimize your Pigment Boards design process with our learning path, enhancing stakeholder collaboration and data visualization for efficient planning.
- [Pigment Basics](https://kb.pigment.com/docs/pigment-basics.md): Discover how to use Pigment Blocks, Dimensions, Transaction Lists, and Views to organize data and create clear, actionable insights.
- [Pigment Blocks in Block Explorer](https://kb.pigment.com/docs/pigment-blocks-block-explorer.md): Master Pigment Blocks with the Block Explorer: create, filter, and organize your Blocks efficiently for a streamlined application experience.
- [Understand Pigment Blocks](https://kb.pigment.com/docs/understand-pigment-blocks.md): Understand Pigment Blocks and their role in modeling. Learn about block types and how to structure data effectively in Pigment.
- [Understand Dimension and Transaction Lists](https://kb.pigment.com/docs/understand-dimension-transaction-lists.md): Learn how Dimension Lists and Transaction Lists are used in Pigment, and understand how they enhance data analysis and organization.
- [Data Types in Pigment](https://kb.pigment.com/docs/data-types-in-pigment.md): Understand the different data types in Pigment, such as Text, Number, Boolean, and more. Learn how to use them to structure your models efficiently.
- [Delete Items in a Dimension or Transaction List](https://kb.pigment.com/docs/delete-items-dimension-transaction-list.md): Learn how to remove items from a Dimension or Transaction List in Pigment, including single and multiple deletions with the right permissions.
- [Create Your First Application](https://kb.pigment.com/docs/create-first-pigment-application.md): Learn how to create your first Pigment Application from scratch, the first step in organizing, analyzing, and visualizing your data.
- [Secure Your Application with App Lock](https://kb.pigment.com/docs/secure-your-application-app-lock.md): Secure your Application in Pigment using App Lock. Learn how to  manage user access, safeguard sensitive data, and ensure secure collaboration.
- [Duplicate an Application](https://kb.pigment.com/docs/duplicate-pigment-application.md): Learn how to accurately duplicate an application in Pigment, and to efficiently reuse structure and data in other Applications.
- [Manage Workspace Storage](https://kb.pigment.com/docs/manage-workspace-storage.md)
- [View Usage Across Workspaces](https://kb.pigment.com/docs/view-usage-across-workspaces.md): Review and compare Workspace usage, including cells, AI credits, and file storage, all in one overview without opening each Workspace.
- [Work with Block Information in Block Explorer](https://kb.pigment.com/docs/work-block-information-block-explorer.md): Explore Block data using Block Explorer in Pigment. Learn key Block information like formulas, inputs, and dependencies for better model insights.
- [Views in Pigment](https://kb.pigment.com/docs/pigment-views.md): Learn how Views in Pigment help you visualize, pivot, and customize data using grids, charts, filters, and layouts to analyze insights from any angle.
- [Work with Views in Pigment](https://kb.pigment.com/docs/work-views-pigment.md): Explore how to customize Views in Blocks for effective data visualization, including public and personal options, to enhance your data interpretation.
- [Change Views with Pivot](https://kb.pigment.com/docs/change-views-pivot-pigment.md): Discover how to adjust your data layout with Pivot in Pigment by changing axes and rearranging fields for better insights.
- [Files in Pigment](https://kb.pigment.com/docs/files-in-pigment.md): Learn how to store and manage files in Pigment Applications, control file access with permissions, and monitor file storage usage across your Workspace.
- [Manage Files in an Application](https://kb.pigment.com/docs/manage-files-in-an-application.md): Learn how to upload, find, download, rename, and delete files in a Pigment Application, and understand the permissions required to manage files.
- [Manage File Storage Limits](https://kb.pigment.com/docs/manage-file-storage-limits.md): Manage your Workspace file storage effectively with limits based on your Pigment plan. Learn to view and delete files to optimize usage.
- [Pigment Support](https://kb.pigment.com/docs/pigment-support.md): Access Pigment's online support portal for product inquiries, ticket submissions, and community resources to enhance your experience.
- [Do I contact Support or Community?](https://kb.pigment.com/docs/contact-pigment-support-vs-community.md): Find out whether Pigment Support or the Community is best for your issue. Use the right path and get answers more efficiently.
- [Pigment Supported Browsers](https://kb.pigment.com/docs/pigment-supported-browsers.md): Find out which web browsers are supported by Pigment for the best performance and compatibility across all features and platforms.
- [Pigment Community](https://kb.pigment.com/docs/pigment-community.md): Join the Pigment Community to connect, share ideas, and access resources that enhance your skills and shape the future of Pigment together!
- [Welcome to Ideas!](https://kb.pigment.com/docs/welcome-pigment-ideas.md): Explore Pigment Ideas. Share your thoughts, vote on features, and stay updated on what the Pigment Community wants next.
- [Pigment Compared to Excel](https://kb.pigment.com/docs/pigment-vs-excel-comparison.md): Explore the key similarities and differences between Pigment and Excel, focusing on data organization, formulas, and the benefits of using Blocks.
- [Create a Metric similar to TODAY() in Excel](https://kb.pigment.com/docs/create-a-metric-akin-to-today-in-excel.md)
- [Modeling and Formulas](https://kb.pigment.com/docs/models-formulas.md): Learn the core concepts needed to build effective Pigment applications, including Metrics, Dimension Lists, Scenarios, and Versions. This section covers Pigment syntax, iterative calculations, dependent dropdowns, and performance optimization, giving modelers the foundations to structure data, run simulations, and create scalable, high-performance planning models.
- [Model with Metrics](https://kb.pigment.com/docs/model-metrics.md): Learn about Metrics in Pigment, their structure, data types, and how to create, edit, and delete them for effective data reporting and calculations.
- [Block settings for Metrics](https://kb.pigment.com/docs/block-settings-for-metrics.md): Explore data input options in Metrics, including formula overrides, converting results to values, and impacts on Scenarios for seamless data management.
- [Clone Data in Metrics](https://kb.pigment.com/docs/clone-metric-data.md): Learn how to clone data in Metrics between list items, duplicating products or initializing country data, with important security considerations.
- [Delete User Inputs](https://kb.pigment.com/docs/delete-user-inputs.md): Learn how to delete manual input overrides in Pigment Blocks to restore formula results for accurate Metrics and streamline your data management.
- [Make a mapping Metric](https://kb.pigment.com/docs/make-a-mapping-metric.md)
- [Work with Tables to Summarize Information](https://kb.pigment.com/docs/tables-summarize-information.md): Analyze and compare data effortlessly with Tables. Combine Metrics like Revenue and Costs for insightful P&L reports and project analysis.
- [Block settings for Tables](https://kb.pigment.com/docs/block-settings-for-tables.md): Explore Block settings for Tables, including data input options, Metrics management, and duplication features to enhance your application's structure.
- [Forecasting Approaches in Pigment](https://kb.pigment.com/docs/forecasting-approaches-in-pigment.md)
- [Model with Lists](https://kb.pigment.com/docs/model-lists.md): Explore the essential types of Lists in Pigment, including Dimension and Transaction Lists, and learn how they structure your data effectively.
- [Block settings for Transaction and Dimension Lists](https://kb.pigment.com/docs/block-settings-transactions-dimension-lists.md): Explore block settings for Transactions and Dimension Lists, including configuration options, access rights, and data management in your application.
- [Set up your Calendar](https://kb.pigment.com/docs/set-up-calendar.md): Set up your Calendar in Pigment to define fiscal years and time dimensions, ensuring accurate data tracking for your organization’s needs.
- [Extend Your Calendar](https://kb.pigment.com/docs/extend-your-calendar.md)
- [Set up Properties in Lists](https://kb.pigment.com/docs/set-up-properties-in-lists.md): Learn about Properties in Pigment, their types, and how to set them up for effective data management and analysis in your lists.
- [List Item History Properties](https://kb.pigment.com/docs/list-item-history-properties.md)
- [Move a List to another Application](https://kb.pigment.com/docs/move-list-to-another-application.md): Learn how to move lists between applications while maintaining governance and access rights, enhancing your workspace's efficiency and organization.
- [Automatically Generate Unique IDs for List Items](https://kb.pigment.com/docs/automatically-generate-unique-ids-list-items.md): Enable Automatically generated unique IDs in your lists to maintain a continuous count of items, ensuring IDs remain unchanged even if reordered.
- [Substitute a List with another List](https://kb.pigment.com/docs/substitute-list.md): Learn how to effectively use Move and Substitute for Dimension Lists in Distributed Planning architecture to enhance governance and simplify management.
- [How to Use List Subsets](https://kb.pigment.com/docs/use-list-subsets.md): Track creation and edits with List Item History Properties to improve data management and keep your application organized and reliable.
- [FAQs: List Management](https://kb.pigment.com/docs/faqs-list-management.md): Explore List Management FAQs, troubleshoot issues, and learn about permissions, adding items, and more to optimize your Lists effectively.
- [Versions and Scenarios](https://kb.pigment.com/docs/versions-scenarios.md): Understand when to use Versions versus Scenarios in Pigment to model different planning realities. Learn how Scenarios support fast what-if simulations, while Versions enable structured, repeatable, and auditable planning for budgets, forecasts, and long-term analysis.
- [Understand Versions in Pigment](https://kb.pigment.com/docs/understand-versions-in-pigment.md)
- [Implement Versions and plans in Pigment](https://kb.pigment.com/docs/managing-versions-in-pigment.md)
- [Get started with Scenarios in Pigment](https://kb.pigment.com/docs/get-started-scenarios.md): Explore how Scenarios enhance your planning process by allowing comparisons of different data inputs and formulas for optimal decision-making.
- [Create and edit Scenarios in Pigment](https://kb.pigment.com/docs/create-edit-scenarios.md): Learn how to create, edit, and delete Scenarios while managing permissions and access rights effectively in your Application.
- [How to view and compare Pigment Scenarios](https://kb.pigment.com/docs/compare-scenarios.md): Explore the powerful Compare Scenarios functionality to manipulate data, configure views, and easily compare multiple Scenarios side-by-side.
- [Edit formulas within Scenarios](https://kb.pigment.com/docs/edit-formulas-within-scenarios.md): Learn how to create and manage Formula Groups in Scenarios, allowing unique formulas for each Scenario to enhance your data analysis.
- [Copy Inputs Between Scenarios](https://kb.pigment.com/docs/copy-inputs-between-scenarios.md): Easily copy inputs between Scenarios for flexible planning. Adjust data without creating new Scenarios, ensuring efficient Metric management.
- [Work with Model Data](https://kb.pigment.com/docs/work-with-model-data.md)
- [Restore a Block from Backup](https://kb.pigment.com/docs/restore-block-from-backup.md): Restore Blocks from backups effortlessly with Block Restore, ensuring data integrity and resolving errors in your Application. Learn how to manage restored Blocks!
- [Recover an Application From Backup](https://kb.pigment.com/docs/recover-an-application-from-backup.md)
- [Explore Your model with the dependency diagram](https://kb.pigment.com/docs/explore-your-model-dependency-diagram.md): Explore the Dependency Diagram in Pigment to see model structure, access rights, and Block connections for enhanced model understanding.
- [Drill to data source](https://kb.pigment.com/docs/drill-data-source.md): Uncover the source data behind calculated cells with the Drill to data source feature, revealing insights from Metrics, Transactions, and Dimensions Lists.
- [Drill Down into your data](https://kb.pigment.com/docs/drill-down-into-your-data.md): Explore the Drill Down feature to analyze data correlations, decompose formulas, and understand aggregated values in detail for better insights.
- [Deactivate Autosave to Combine Updates](https://kb.pigment.com/docs/deactivate-autosave.md): Learn about the new Autosave functionality in Pigment, enabling efficient data updates and synchronization across Blocks for seamless collaboration.
- [Introduction to Formulas](https://kb.pigment.com/docs/introduction-formulas.md): Kickstart your formula writing in Pigment with this guide, comparing syntax and operations to Excel for seamless data management.
- [Analyze and optimize formulas with the Formula Playground](https://kb.pigment.com/docs/analyze-optimize-formulas-formula-playground.md): Explore the Formula Playground tool to test formulas in Auto and Custom modes, troubleshoot metrics, and understand data dimensions effortlessly.
- [Use the Formula Bar Menu](https://kb.pigment.com/docs/use-the-formula-bar-menu.md): This menu beside the formula bar provides options to help you understand, manage and optimize your Metrics’ formulas in Pigment.
- [Filter data in formulas](https://kb.pigment.com/docs/filter-data-in-formulas.md): Learn how to use the FILTER and EXCLUDE modifiers in Pigment to effectively filter data based on specific values and enhance your analysis.
- [Troubleshoot Your Formulas](https://kb.pigment.com/docs/troubleshoot-your-formulas.md): Troubleshoot your formulas effectively with tips on identifying errors, checking data sources, and ensuring Dimension alignment for accurate results.
- [Align Block Structures for Effective Formula Operations](https://kb.pigment.com/docs/align-block-structures-effective-formula-operations.md): Master complex planning with step-by-step guidance on structuring metrics, filtering dimensions, and validating formulas for effective data analysis.
- [How Pigment Handles Blank Cells](https://kb.pigment.com/docs/how-pigment-handles-blank-cells.md): Learn how Pigment's sparse engine handles blank cells in formulas, enhancing computation speed and affecting operator behavior in data analysis.
- [Keyboard shortcuts](https://kb.pigment.com/docs/keyboard-shortcuts.md): Explore essential Pigment keyboard shortcuts for QWERTY and AZERTY layouts, enhancing your workflow with commands for data input and grid navigation.
- [IFBLANK Use Cases](https://kb.pigment.com/docs/ifblank-use-cases.md): Learn how to efficiently use IFBLANK to automate data completion, merge columns, and enhance performance in your datasets with practical examples.
- [Manage Model Performance](https://kb.pigment.com/docs/model-performance.md): Learn how to analyze and optimize Pigment Application performance with Performance Insights, scoped calculations, and profiling tools.
- [Dimensionality Hints](https://kb.pigment.com/docs/dimension-alignment-indicator.md): Learn about the Dimension alignment indicator, automatic adjustments, and how discrepancies in formula outputs affect your Metric structure.
- [Explanatory Hints](https://kb.pigment.com/docs/explanatory-hints.md)
- [Performance Improvement Hints](https://kb.pigment.com/docs/performance-hints.md)
- [Leverage sparsity for optimal performance](https://kb.pigment.com/docs/leverage-sparsity-for-optimal-performance.md)
- [Use Profiling to Optimize Calculation Paths in your Application](https://kb.pigment.com/docs/profile-calculation-paths.md): Optimize your model's performance by profiling calculation paths in Pigment, identifying slow Blocks, and enhancing efficiency for better results.
- [Optimize Formulas with Scoped Calculations](https://kb.pigment.com/docs/optimize-formulas-scoped-calculations.md): Optimize your Pigment model with scoping to minimize recalculations and enhance performance management for efficient data computation.
- [Use Performance Insights to Optimize your Application](https://kb.pigment.com/docs/use-performance-insights.md): Optimize your model's performance by identifying slow Metrics and using insights from Block Explorer for improved speed and maintenance.
- [Iterative Calculations in Pigment](https://kb.pigment.com/docs/iterative-calculations-in-pigment.md): Learn how to handle iterative calculations in Pigment without causing circular dependency errors. This section explains how Pigment evaluates formulas, how to identify and debug circular references, and when to use PREVIOUS and PREVIOUSOF functions to safely model time-based and dependent calculations.
- [Iterative Calculations within a Block using PREVIOUS](https://kb.pigment.com/docs/iterative-calculations-using-previous.md): Learn how to use Pigment's PREVIOUS function for iterative calculations, avoiding circular dependencies and optimizing performance in your models.
- [Iterative Calculations across multiple Blocks using PREVIOUSOF](https://kb.pigment.com/docs/iterative-calculations-using-previousof.md): Learn to optimize multiple Block iterative calculations in Pigment while avoiding circular dependencies that can cause infinite loops.
- [Iterative Calculations across multiple Blocks using PREVIOUSBASE](https://kb.pigment.com/docs/iterative-calculations-using-previousbase.md): Learn to optimize multiple Block iterative calculations in Pigment while avoiding circular dependencies that can cause infinite loops.
- [Aggregate Data in Formulas](https://kb.pigment.com/docs/aggregate-data-in-formulas.md): Learn how to perform complex data aggregations and allocations in Pigment using modifiers and the powerful BY keyword for effective analysis.
- [Use Cases of Aggregation and Allocation](https://kb.pigment.com/docs/use-cases-aggregation-allocation.md): Master data aggregation and allocation with key relationships between Dimensions to optimize your Metrics.
- [Modifiers in Modeling](https://kb.pigment.com/docs/modifiers-in-modeling.md): Learn how to use and combine Pigment modifiers to transform data in formulas, aligning dimensions with metrics for effective data manipulation.
- [Use the Formula Wizard to Master the BY Modifier](https://kb.pigment.com/docs/formula-wizard-by-modifier.md): Master the BY modifier with the Formula Wizard! Follow our step-by-step guide to transform and aggregate your data effectively in the Formula Playground.
- [Map Source to Target Dimensions: When and How to Use Modifiers](https://kb.pigment.com/docs/map-source-to-target-dimensions.md): Learn about Dimensions in formulas, source to target mapping in Pigment, and how modifiers adjust data for accurate calculations.
- [Dependent Dropdowns](https://kb.pigment.com/docs/dependent-dropdowns.md): Learn about dependent dropdowns in Lists, which filter options based on selections, enhancing user experience in data management.
- [Create a Dependent Dropdown on a List](https://kb.pigment.com/docs/create-dependent-dropdown-on-list.md): Learn to set up dependent dropdowns in Lists with our configuration Metric wizard, ensuring seamless connections between your dropdown Properties.
- [Create a Dependent Dropdown on a Table](https://kb.pigment.com/docs/create-dependent-dropdown-on-table.md): Learn to create dependent dropdowns in Table Views to filter Metrics based on Dimensions, enhancing data accuracy and usability.
- [Functions and Dimension modifiers](https://kb.pigment.com/docs/functions.md): This section lists all Pigment's functions within categories.
- [Most used Functions](https://kb.pigment.com/docs/most-used-functions.md): Discover the top-used Pigment functions and how to apply them effectively in your models for better planning and analysis.
- [Data type conversion Functions](https://kb.pigment.com/docs/data-type-conversion-functions.md): Convert text, numbers, dates, and booleans easily using Pigment’s powerful data type conversion functions.
- [Dimension modifiers](https://kb.pigment.com/docs/dimension-modifiers.md)
- [Aggregation and allocation methods](https://kb.pigment.com/docs/aggregators-and-allocators.md)
- [ADD modifier](https://kb.pigment.com/docs/add-modifier.md): Learn to use the ADD modifier in Pigment to add one or more Dimensions to a Block and allocate data flexibly.
- [REMOVE modifier](https://kb.pigment.com/docs/remove-modifier.md): Learn how to use the REMOVE modifier in Pigment to exclude multiple Dimensions and keep your data Blocks streamlined.
- [KEEP modifier](https://kb.pigment.com/docs/keep-modifier.md)
- [FILTER modifier](https://kb.pigment.com/docs/filter-modifier.md): Learn to apply the FILTER modifier in Pigment to display only relevant data from a Block using conditions and associated Items.
- [EXCLUDE modifier](https://kb.pigment.com/docs/exclude-modifier.md): Learn to use Pigment’s EXCLUDE modifier to refine data sets by excluding Items or cell values in your Blocks.
- [BY modifier](https://kb.pigment.com/docs/by-modifier.md): Learn how to aggregate or allocate data using Pigment’s BY modifier, defining relationships between Dimensions for effective data transformation.
- [SELECT modifier](https://kb.pigment.com/docs/select-modifier.md): Learn how the SELECT modifier in Pigment lets you manipulate Metrics—filtering, aggregating, or shifting data by Dimension.
- [TOPARENTLIST modifier](https://kb.pigment.com/docs/toparentlist-modifier.md)
- [TOSUBSET modifier](https://kb.pigment.com/docs/tosubset-modifier.md)
- [Mapping and Reference Functions](https://kb.pigment.com/docs/dimensional-functions.md): This section covers functions and modifiers that allow you to transform and change Dimension data.
- [ITEM function](https://kb.pigment.com/docs/item-function.md): Learn how Pigment's ITEM function searches a unique Property in a Dimension List and returns the corresponding item or BLANK.
- [MATCH function](https://kb.pigment.com/docs/match-function.md): Learn how to use the MATCH function in Pigment to search values in a Dimension List and return the first matching Item or BLANK if none exist.
- [FILLFORWARD function](https://kb.pigment.com/docs/fillforward-function.md)
- [TIMEDIM function (Dimensional)](https://kb.pigment.com/docs/timedim-function-dimensional.md): Learn to transform raw dates into structured time data using the TIMEDIM function in Pigment for smarter calendar-based planning.
- [SHIFT function](https://kb.pigment.com/docs/shift-function.md): Learn to use the SHIFT function to move Dimension List Items by a positive or negative offset in Pigment for dynamic modeling.
- [Logical Functions](https://kb.pigment.com/docs/logical-functions.md): This section documents logical functions that simplify complex formulas and often share behavior with counterparts in Excel.
- [ANYOF function](https://kb.pigment.com/docs/anyof-function.md): Learn to use Pigment's ANYOF function to remove Dimensions and verify if at least one Boolean cell is TRUE in a Block.
- [SWITCH function](https://kb.pigment.com/docs/switch-function.md): Learn to use the SWITCH function to compare expressions against conditions and return the first match or a default result in Pigment.
- [AND function](https://kb.pigment.com/docs/and-function.md): Learn to use the AND function in Pigment to test if multiple conditions are met. Includes syntax, use cases, and clear examples.
- [OR function](https://kb.pigment.com/docs/or-function.md): Learn to simplify conditional logic in Pigment with the OR function. Check if one or more conditions are true in your formulas.
- [NOT function](https://kb.pigment.com/docs/not-function.md): Learn to use the NOT function to invert the results logical expressions, enhancing your model’s logic and data accuracy.
- [IF function](https://kb.pigment.com/docs/if-function.md): Learn to use the IF function to test conditions in Pigment and return values based on TRUE, FALSE, or BLANK logic.
- [TRUE function](https://kb.pigment.com/docs/true-function.md): Learn to use the TRUE function to return a logical TRUE value in Pigment formulas and simplify your condition-based modeling.
- [ISBLANK function](https://kb.pigment.com/docs/isblank-function.md): Learn to use ISBLANK to check for empty values in Pigment. Returns TRUE if the value is BLANK, FALSE otherwise.
- [ISNOTBLANK function](https://kb.pigment.com/docs/isnotblank-function.md): Learn to use the ISNOTBLANK function in Pigment to identify non-empty values and improve data validation.
- [ISDEFINED function](https://kb.pigment.com/docs/isdefined-function.md): Learn to enhance model efficiency in Pigment by using ISDEFINED to return BLANK for undefined values and avoid max cardinality issues.
- [IN function](https://kb.pigment.com/docs/in-function.md): Learn to simplify validations in Pigment with the IN function by checking if values are in a List or fall within a specified range.
- [IFBLANK function](https://kb.pigment.com/docs/ifblank-function.md): Learn to apply the IFBLANK function to fill empty cells in a Block by pulling non-blank values from another Block.
- [FALSE function](https://kb.pigment.com/docs/false-function.md): Learn to return the boolean value FALSE in Pigment by using the FALSE function for clean logical operations.
- [IFDEFINED function](https://kb.pigment.com/docs/ifdefined-function.md): Learn to use the IFDEFINED function to fill defined values in your expressions with a specified value in Pigment.
- [Numeric Functions](https://kb.pigment.com/docs/numeric-functions.md): The numeric functions include the transformative mathematical functions such as EXP (exponent), SIN (sine) and LN (natural logarithm).

They also include useful functions such as CUMULATE, TEXT (convert to text) and RANK (order).
- [SQRT function](https://kb.pigment.com/docs/sqrt-function.md): Learn to use the SQRT function to calculate the square root of a Number in Pigment with practical examples and syntax tips.
- [SIGN function](https://kb.pigment.com/docs/sign-function.md): Learn to apply the SIGN function in Pigment to identify number signs easily. Returns 1 for positive, 0 for zero, and -1 for negative.
- [EXP function](https://kb.pigment.com/docs/exp-function.md): Learn to calculate exponential values using the EXP function in Pigment—essential for modeling growth and natural logs.
- [LN function](https://kb.pigment.com/docs/ln-function.md): Learn to use the LN function to return the natural logarithm of a number using base e—essential for financial and statistical modeling.
- [LOG function](https://kb.pigment.com/docs/log-function.md): Learn to apply the LOG function in Pigment for base-10 logarithmic calculations and streamline numeric analysis.
- [SIN function](https://kb.pigment.com/docs/sin-function.md)
- [COS function](https://kb.pigment.com/docs/cos-function.md)
- [MIN function (Numeric)](https://kb.pigment.com/docs/min-function-numeric.md): Learn to use the MIN function in Pigment to return the smallest numeric value across multiple inputs.
- [MAX function (Numeric)](https://kb.pigment.com/docs/max-function-numeric.md): Learn to apply the MAX function in Pigment to return the highest value across multiple inputs, whether numbers or dates.
- [MOD function](https://kb.pigment.com/docs/mod-function.md): Learn to apply the MOD function in Pigment to simplify division-based calculations and return remainders efficiently.
- [QUOTIENT function](https://kb.pigment.com/docs/quotient-function.md): Learn to use the QUOTIENT function to return only the integer portion of a division, excluding the remainder. Ideal for financial modeling.
- [POWER function](https://kb.pigment.com/docs/power-function.md): Learn to master the POWER function in Pigment to raise a number to a specified power and optimize your data analysis.
- [ROUND function](https://kb.pigment.com/docs/round-function.md): Learn to use the ROUND function to round numbers to a specified number of digits in Pigment and simplify your data formatting.
- [ROUNDDOWN function](https://kb.pigment.com/docs/rounddown-function.md): Learn to use the ROUNDDOWN function to round numbers down to a specific number of digits with precision in Pigment models.
- [ROUNDUP function](https://kb.pigment.com/docs/roundup-function.md): Learn to use the ROUNDUP function to round numbers up to a specific number of digits in Pigment with clear examples and syntax tips.
- [TRUNC function](https://kb.pigment.com/docs/trunc-function.md): Learn to use TRUNC to limit decimal digits in Pigment and simplify number formatting for cleaner data presentation.
- [CEILING function](https://kb.pigment.com/docs/ceiling-function.md): Learn to use the CEILING function in Pigment to round numbers up to the nearest integer and streamline your data modeling.
- [FLOOR function](https://kb.pigment.com/docs/floor-function.md): Learn to use the FLOOR function in Pigment to round numbers down to the nearest integer and streamline your data modeling.
- [RANK function](https://kb.pigment.com/docs/rank-function.md): Learn to use the RANK function to determine a value’s position in a List or Metric, based on its size relative to other values.
- [SPREAD function](https://kb.pigment.com/docs/spread-function.md): Learn to master the SPREAD function in Pigment to allocate numeric values across ordered items dynamically and efficiently.
- [CUMULATE function](https://kb.pigment.com/docs/cumulate-function.md): Learn how to use the CUMULATE function to aggregate data by Dimensions and change accumulation order with the ON operator for effective inventory management.
- [DECUMULATE function](https://kb.pigment.com/docs/decumulate-function.md): Learn to use DECUMULATE to calculate differences between values and their previous item in Pigment for advanced time-based analysis.
- [ABS function](https://kb.pigment.com/docs/abs-function.md): Learn to use the ABS function to return the absolute value of a Number in Pigment — perfect for handling negative values in your models.
- [TEXT function](https://kb.pigment.com/docs/text-function.md): Learn to use the TEXT function to convert numbers or integers into text in Pigment for better formatting and reporting flexibility.
- [Text Functions](https://kb.pigment.com/docs/text-functions.md): Included in this section is documentation on Pigment's functions to concatenate text fields, find characters, switch case (upper or lower case) through a formula, and much more.
- [CONTAINS function](https://kb.pigment.com/docs/contains-function.md): Learn to use the CONTAINS function to check if one text string exists within another in Pigment. Ideal for data validation and filtering.
- [STARTSWITH function](https://kb.pigment.com/docs/startswith-function.md): Learn to use the STARTSWITH function to check if a Text begins with specific characters, allowing you to validate and organize Text entries in Pigment.
- [ENDSWITH function](https://kb.pigment.com/docs/endswith-function.md): Learn to use the ENDSWITH function to check if a Text ends with specific characters, allowing you to validate and organize Text entries in Pigment.
- [LEN function](https://kb.pigment.com/docs/len-function.md): Learn to use the LEN function to calculate the number of characters in text fields in Pigment.
- [LEFT function](https://kb.pigment.com/docs/left-function.md): Learn to apply the LEFT function to extract a specific number of characters from the start of a text value in Pigment.
- [MID function](https://kb.pigment.com/docs/mid-function.md): Learn to apply the MID function in Pigment to extract a specific number of characters from any text field, starting at your chosen position.
- [RIGHT function](https://kb.pigment.com/docs/right-function.md): Learn to apply the RIGHT function to extract a specific number of characters from the end of a text value in Pigment.
- [LOWER function](https://kb.pigment.com/docs/lower-function.md): Learn to use the LOWER function in Pigment to convert text values to lowercase for consistent formatting in your datasets.
- [UPPER function](https://kb.pigment.com/docs/upper-function.md): Learn to use the UPPER function in Pigment to convert text values to uppercase for consistent formatting in your datasets.
- [TRIM function](https://kb.pigment.com/docs/trim-function.md): Learn to use the TRIM function in Pigment to clean up text by removing leading, trailing, and extra spaces between words.
- [VALUE function](https://kb.pigment.com/docs/value-function.md): Learn to use the VALUE function in Pigment to transform text representing numbers into numerical values.
- [PROPER function](https://kb.pigment.com/docs/proper-function.md): Learn to clean and format text with the PROPER function, capitalizing first letters and converting the rest to lowercase.
- [FIND function](https://kb.pigment.com/docs/find-function.md): Learn to apply the FIND function to identify the first occurrence of a string inside another string in Pigment. Returns position or BLANK.
- [& function](https://kb.pigment.com/docs/ampersand-function.md): Learn to simplify text operations in Pigment by using the & function to join strings across your datasets.
- [SUBSTITUTE function](https://kb.pigment.com/docs/substitute-function.md): Learn to use SUBSTITUTE to replace one or all instances of a text string with a new value.
- [Time and Date Functions](https://kb.pigment.com/docs/time-and-date-functions.md): The functions described in this section measure and calculate time periods in your Metrics. Use MONTHTODATE, QUARTERTODATE and YEARTODATE to accumulate data as time periods are added, with various aggregation methods available. PREVIOUS and PREVIOUSOF allow iterative calculations and let you populate blank cells from an initial Item. MOVINGSUM and MOVINGAVERAGE allow you to set a window of Items and optionally an offset to be used in a sum or average calculation.
- [MAX function (Time & Date)](https://kb.pigment.com/docs/max-function-timedate.md): Learn to apply the MAX function in Pigment to return the highest value across multiple inputs, whether numbers or dates.
- [DATE function](https://kb.pigment.com/docs/date-function.md): Learn to use the DATE function to create a date from specified year, month, and day values.
- [DATEVALUE function](https://kb.pigment.com/docs/datevalue-function.md): Learn to use DATEVALUE to convert text into a specified date format, with examples and supported format types.
- [EOMONTH function](https://kb.pigment.com/docs/eomonth-function.md): Learn to use EOMONTH to return the last day of a month before or after a given date in Pigment.
- [MIN function (Time & Date)](https://kb.pigment.com/docs/min-function-timedate.md): Learn to use the MIN function in Pigment to return the smallest date value across multiple inputs.
- [STARTOFMONTH function](https://kb.pigment.com/docs/startofmonth-function.md): Learn to use the STARTOFMONTH function to return the first day of a month relative to a given date in Pigment.
- [WEEKDAY function](https://kb.pigment.com/docs/weekday-function.md): Learn to use the WEEKDAY function to return the day of the week from a specified Date value in Pigment models.
- [DAY function](https://kb.pigment.com/docs/day-function.md): Learn to apply the DAY function to return the calendar day from a given Date, useful for reporting and time-based logic.
- [MONTH function](https://kb.pigment.com/docs/month-function.md): Learn to apply the MONTH function to return the calendar month from a given Date, useful for reporting and time-based logic.
- [MONTHDIF function](https://kb.pigment.com/docs/monthdif-function.md): Learn to calculate time intervals with MONTHDIF by finding the number of months between two Dates.
- [YEAR function](https://kb.pigment.com/docs/year-function.md): Learn to apply the YEAR function to return the calendar year from a given Date, useful for reporting and time-based logic.
- [DAYS function](https://kb.pigment.com/docs/days-function.md): Learn to calculate time intervals with DAYS by finding the number of days between two Dates.
- [NETWORKDAYS function](https://kb.pigment.com/docs/networkdays-function.md): Learn to use NETWORKDAYS to calculate working days between two dates, excluding weekends and optional holidays or specific weekdays.
- [INPERIOD function](https://kb.pigment.com/docs/inperiod-function.md): Learn to use the INPERIOD function to check if a date falls within a specified time period in Pigment.
- [DAYSINPERIOD function](https://kb.pigment.com/docs/daysinperiod-function.md): Learn to calculate the number of days in specific time periods using the DAYSINPERIOD function in Pigment.
- [PRORATA function](https://kb.pigment.com/docs/prorata-function.md): Learn to use the PRORATA function to calculate the number of prorata days per period in a time range, based on start and end dates.
- [TIMEDIM function (Time & Date)](https://kb.pigment.com/docs/timedim-function-timedate.md): Learn to transform raw dates into structured time data using the TIMEDIM function in Pigment for smarter calendar-based planning.
- [MONTHTODATE function](https://kb.pigment.com/docs/monthtodate-function.md): Learn to use the MONTHTODATE function to cumulate values by day and reset totals at the start of each month in Pigment.
- [QUARTERTODATE function](https://kb.pigment.com/docs/quartertodate-function.md): Learn to use QUARTERTODATE to cumulate Metrics by Day or Month, resetting the total at the start of each quarter.
- [YEARTODATE function](https://kb.pigment.com/docs/yeartodate-function.md): Learn to use YEARTODATE to cumulate Metrics by Day or Month, resetting the total at the start of each year.
- [MOVINGAVERAGE function](https://kb.pigment.com/docs/movingaverage-function.md): Learn to use the MOVINGAVERAGE function to calculate rolling averages over a Dimension List using fixed or dynamic windows, while ignoring blanks.
- [MOVINGSUM function](https://kb.pigment.com/docs/movingsum-function.md): Learn to use the MOVINGSUM function to calculate a sum over a Dimension List using fixed or dynamic windows, while ignoring blanks.
- [EDATE function](https://kb.pigment.com/docs/edate-function.md): Learn to use the EDATE function to add or subtract months from a date value and manage time-based calculations in Pigment.
- [PREVIOUS function](https://kb.pigment.com/docs/previous-function.md): Use PREVIOUS to return a previous cell value in a iteration Dimension of the base Metric. You can create single Metric iterative calculations.
- [PREVIOUSOF function](https://kb.pigment.com/docs/previousof-function.md): Use PREVIOUSBASE to return a previous cell value in a iteration Dimension of the base Metric. You can create multi-Metric iterative calculations.
- [PREVIOUSBASE function](https://kb.pigment.com/docs/previousbase-function.md): Use PREVIOUSBASE to return a previous cell value in a iteration Dimension of the base Metric. You can create multi-Metric iterative calculations.
- [Security Functions](https://kb.pigment.com/docs/security-functions.md): This section covers the ACCESSRIGHTS and RESETACCESSRIGHTS functions. Use these to generate access rights and to remove access rights inheritance.
- [RESETACCESSRIGHTS function](https://kb.pigment.com/docs/resetaccessrights-function.md): Learn to use RESETACCESSRIGHTS to remove inherited access rules while retaining directly mapped permissions in Pigment models.
- [ACCESSRIGHTS function](https://kb.pigment.com/docs/accessrights-function.md): Learn to use ACCESSRIGHTS to return access control values based on read and write Booleans in your Pigment model.
- [Aggregation Functions](https://kb.pigment.com/docs/aggregation-functions.md): The functions described in this section help users count Items under specific conditions, and find highest, lowest and other values within your Blocks.
- [COUNTOF function](https://kb.pigment.com/docs/countof-function.md): Learn to use the COUNTOF function to count non-BLANK values across Dimensions in a Block in Pigment.
- [COUNTALLOF function](https://kb.pigment.com/docs/countallof-function.md): Learn to use COUNTALLOF to count all Dimension values in a Block, even when using multiple Dimensions.
- [COUNTBLANKOF function](https://kb.pigment.com/docs/countblankof-function.md): Learn to apply the COUNTBLANKOF function to identify empty cells in a Pigment Block, returning a numeric count.
- [COUNTUNIQUEOF function](https://kb.pigment.com/docs/countuniqueof-function.md): Learn to use COUNTUNIQUEOF to return the number of unique non-BLANK Items related to a specific Dimension in your Block.
- [SUMOF function](https://kb.pigment.com/docs/sumof-function.md): Learn to calculate totals with SUMOF by summing numeric data across Dimensions or filtered subsets in Pigment.
- [AVGOF function](https://kb.pigment.com/docs/avgof-function.md): Learn to use AVGOF for calculating the average of a Block’s numbers, including syntax and practical usage tips.
- [MINOF function](https://kb.pigment.com/docs/minof-function.md): Learn to use the MINOF function for to retrieve a Block's lowest value in Pigment, with practical use case examples.
- [MAXOF function](https://kb.pigment.com/docs/maxof-function.md): Learn to use the MAXOF function for to retrieve a Block's highest value in Pigment, with practical use case examples.
- [Forecasting and Smoothing Functions](https://kb.pigment.com/docs/forecasting-smoothing-functions.md)
- [FORECAST_ETS function](https://kb.pigment.com/docs/forecast-ets-function.md): Learn to use the ETS function to forecast time series with trend and seasonality using an additive Holt-Winters model in Pigment.
- [FORECAST_LINEAR function](https://kb.pigment.com/docs/forecast-linear-function.md): Learn to build simple linear models in Pigment with the FORECAST.LINEAR function, using ordinary least squares to fit data.
- [SIMPLE_EXPONENTIAL_SMOOTHING function](https://kb.pigment.com/docs/simple-exponential-smoothing-function.md): Learn to use SIMPLE_EXPONENTIAL_SMOOTHING to compute exponentially smoothed values across a ranking Dimension in Pigment.
- [DOUBLE_EXPONENTIAL_SMOOTHING function](https://kb.pigment.com/docs/double-exponential-smoothing-function.md): Learn to use DOUBLE_EXPONENTIAL_SMOOTHING to compute double exponentially smoothed values across a ranking Dimension in Pigment.
- [SEASONAL_LINEAR_REGRESSION function](https://kb.pigment.com/docs/seasonal-linear-regression-function.md): Learn to use SEASONAL.LINEAR.REGRESSION to compute a linear trend with seasonality adjustments in Pigment for time-based data analysis.
- [Finance Functions](https://kb.pigment.com/docs/finance-functions.md): Use the functions descibed in this section to determine net present value and internal rate of return in Pigment's Metrics.
- [NPV function](https://kb.pigment.com/docs/npv-function.md): Learn to use XNPV to calculate net present value from regular cashflows and specific dates in Pigment.
- [XNPV function](https://kb.pigment.com/docs/xnpv-function.md): Learn to use XNPV to calculate net present value from irregular cashflows and specific dates in Pigment.
- [IRR function](https://kb.pigment.com/docs/irr-function.md): Learn to use IRR to calculate the internal rate of return for evenly spaced future cashflows where NPV equals zero.
- [XIRR function](https://kb.pigment.com/docs/xirr-function.md): Learn to use the XIRR function to calculate the internal rate of return from irregular cashflows and specific dates in Pigment.
- [Statistical Functions](https://kb.pigment.com/docs/statistical-functions.md): This section covers the Pigment functions providing standard normal distributions.
- [STANDARD_NORMAL_DISTRIBUTION function](https://kb.pigment.com/docs/standard-normal-distribution-function.md): Learn to use STANDARD_NORMAL_DISTRIBUTION to calculate Z-scores with a mean of zero and standard deviation of one in Pigment models.
- [STANDARD_NORMAL_DISTRIBUTION_CUMULATIVE function](https://kb.pigment.com/docs/standard-normal-distribution-cumulative-function.md): Learn to use the STANDARD_NORMAL_DISTRIBUTION_CUMULATIVE function to return the cumulative standard normal distribution with mean zero and standard deviation one.
- [Reporting and Data Visualization](https://kb.pigment.com/docs/report-data-visualization.md): The documentation in this section includes guidance on Pigment Board design and formatting, styling, language settings, reporting charts and more.
- [Sequences](https://kb.pigment.com/docs/sequences.md): Learn how to build Sequences in Pigment to create guided input flows across Boards for structured planning workflows.
- [Create a Sequence for Input Flows](https://kb.pigment.com/docs/create-sequence-input-flows.md): ​Guide Pigment Members through structured data input flows using Sequences, enhancing financial, workforce, and sales planning processes.
- [Branding and Locale Settings](https://kb.pigment.com/docs/format-style.md): The documentation in this section helps you use logos, images and date and time settings to make the most of Pigment. It also provides guidance on switching language settings. Only English and French are supported currently.
- [Change display language](https://kb.pigment.com/docs/change-display-language.md)
- [How to Add a Company Logo](https://kb.pigment.com/docs/add-company-logo.md): Enhance your organization's identity by adding a logo to your Workspace and Board headers with our step-by-step guide for admins.
- [Date and Number Local Format](https://kb.pigment.com/docs/date-number-local-format.md): Manage Pigment Members effortlessly: invite, modify, and deactivate accounts while tracking their status and contributions in your workspace.
- [Format date and time using Locale date time](https://kb.pigment.com/docs/format-using-locale-date-time.md): Learn how to display UTC time data in local time zones using Pigment's Locale date time setting for Text data types. Adjust your browser for accuracy.
- [Create a Custom Workspace Color Palette](https://kb.pigment.com/docs/create-custom-workspace-color-palette.md): Build a custom Color Palette in Pigment to align charts, widgets, and Dimension Items with your brand using up to 24 distinct colors.
- [Approved Domains for Images](https://kb.pigment.com/docs/approved-domains-for-images.md): Display images in Pigment Grids and Org Charts by approving domains to avoid broken links and ensure smooth image rendering across reports.
- [Data Format and Style](https://kb.pigment.com/docs/data-format-style.md): Use Pigment’s formatting features to style data in Lists, Metrics, and Tables for better readability and impactful presentation in every View.
- [Apply Static Formatting to Define Different Views](https://kb.pigment.com/docs/apply-static-formatting-different-views.md): Apply static formatting in Pigment to customize how Metrics, Lists, and Tables appear across views for better data clarity and presentation.
- [Apply Conditional Formatting to Highlight Data Changes](https://kb.pigment.com/docs/conditional-formatting-highlight-data.md): Learn how to apply conditional formatting to highlight data changes instantly and improve data analysis with easy, actionable steps.
- [Apply Conditional Formatting Based on Another Metric](https://kb.pigment.com/docs/apply-conditional-formatting-metric.md): Drive flexible visual insights in Pigment by formatting Metrics based on values from another Metric for clearer, data-driven decisions.
- [Apply Default Formatting Across All Instances of a Metric](https://kb.pigment.com/docs/apply-default-formatting-all-instances-metric.md): Apply default formatting in Pigment to ensure consistent Metric styles across all Views without manual updates each time.
- [Displaying images in Metrics and List properties](https://kb.pigment.com/docs/displaying-images-metrics-list-properties.md): Learn how to display images in Pigment Metrics and List properties using approved domains for smooth, visual integration across your Boards.
- [Format Text Data Types with Rich Text](https://kb.pigment.com/docs/format-text-data-types-rich-text.md): Enable rich text formatting in Metrics and Lists with bold, italics, and more. Learn how to enhance your text data for better presentation.
- [Create and Manage View Templates](https://kb.pigment.com/docs/create-and-manage-view-templates.md): Streamline your grid formatting with View Templates in Pigment. Apply consistent styles quickly and adapt as your data evolves for polished results.
- [Data Reporting](https://kb.pigment.com/docs/data-report.md): The documentation in this section provides guidance on essential concepts in Pigment's data management functionality, including data slices and item variables.





Data Slices



Mapped Dimensions
- [Compare Data with Data slices](https://kb.pigment.com/docs/compare-versions-with-data-slices.md)
- [Group data dynamically with mapped Dimensions](https://kb.pigment.com/docs/mapped-dimensions.md): Learn how to use mapped Dimensions to dynamically group data in Views, enhancing performance without redesigning your model.
- [Filter Data in Pigment](https://kb.pigment.com/docs/filter-data-pigment.md): Learn to filter Views in Pigment using Metrics and Dimensions to tailor data for Boards and Charts and improve clarity in your data analysis.
- [Sort Data in Pigment](https://kb.pigment.com/docs/sort-data-pigment.md): Organize your data in Pigment by sorting Metrics, Lists, and Tables to simplify analysis and enhance data clarity across your Workspace.
- [Compare Data with Calculated Items](https://kb.pigment.com/docs/compare-data-calculated-items.md): Create and manage Calculated Items in Pigment to compare data, customize metrics, and enhance analysis with flexible, user-defined calculations.
- [Customize Data Display with Show Values As](https://kb.pigment.com/docs/show-values-as.md): Learn how to use the Show Values As feature for effective metric comparisons, including configuration options and practical examples.
- [Reorder Calculations in Pigment](https://kb.pigment.com/docs/reorder-calculations-pigment.md): Learn how to manage Calculated Items and Show Values As in Pigment, including viewing and reordering calculations for optimal data analysis.
- [Customize the Layout of Your Views](https://kb.pigment.com/docs/customize-layout-views.md): Customize your Pigment Views with Tabular or Tree mode, adjusting row height, headers, and totals for clearer, more flexible data visualization.
- [Understanding the Loader Icon](https://kb.pigment.com/docs/understanding-loader-icon.md): Learn what the Loader icon means in Pigment and how to identify Imports, Inputs, and Formula updates during data processing.
- [Set up Totals in the Aggregator Panel](https://kb.pigment.com/docs/totals-aggregator-panel.md): Use Pigment’s Aggregator Panel to add totals and subtotals, customize Views, and save configurations for clear, reusable data analysis.
- [How to use Sheet View](https://kb.pigment.com/docs/how-to-use-sheet-view.md): Explore Sheet View in Pigment, a spreadsheet-style display for Metrics and Tables, featuring data input, formulas, and customizable options.
- [Use Cell Status Indicators for Better Grid Interaction](https://kb.pigment.com/docs/cell-status-indicators.md): Activate Pigment’s Cell Status Indicators to easily identify Inputs, formulas, and overrides across Boards and Views for faster, clearer data analysis.
- [Break down your Metrics data directly from the grid](https://kb.pigment.com/docs/break-down-metrics-grid.md): Use the Break down by feature in Pigment to explore Metric data by Dimension directly in Tables and gain deeper insights into your analysis.
- [How to Use Item Variables](https://kb.pigment.com/docs/use-item-variables.md): Enhance your Pigment Application with Item Variables to enable flexible filtering, efficient Workflows, and tailored data views.
- [Practical Examples and Best Practices for Changeable Static Variables](https://kb.pigment.com/docs/practical-examples-and-best-practices-for-changeable-static-variables.md): Leverage Item Variables in Pigment for dynamic reporting, enabling easy comparison of forecast versions against actuals and budgets. Maximize your variance analysis!
- [Get Started with Reporting Charts](https://kb.pigment.com/docs/get-started-report-charts.md): Visualize data trends with various chart types like bar, line, and pie charts. Customize settings for effective pigment reporting and analysis.
- [Bar Chart](https://kb.pigment.com/docs/bar-chart-options.md): Customize Bar Charts in Pigment with label, color, and layout options to highlight trends, compare data, and improve visual clarity in Boards.
- [Line Chart](https://kb.pigment.com/docs/line-chart-options.md): Customize Line Charts in Pigment to visualize trends, compare metrics, and adjust colors, markers, and axes for clearer, data-driven storytelling.
- [Combined Chart](https://kb.pigment.com/docs/combined-chart.md): Learn how to configure Combined charts in Pigment, including bar and line settings, labels, axes, legends, and chart display option
- [Pie Chart](https://kb.pigment.com/docs/pie-chart.md): Learn how to configure Pie charts in Pigment, including labels, legends, inner radius, corner radius, and chart display settings.
- [Waterfall Chart](https://kb.pigment.com/docs/waterfall-charts.md): Learn how to create and configure Contribution and Variation Waterfall charts to visualize changes between values effectively.
- [Map chart](https://kb.pigment.com/docs/set-up-map-chart.md): Visualize geolocated data in Pigment with Map Charts, including Areas, US ZIP codes, and states, to enhance reporting across regions and territories.
- [Customize Chart Colors](https://kb.pigment.com/docs/customize-chart-colors.md): Learn to customize chart colors using themes, Dimension Item colors, and series colors for bar, line, pie, and waterfall charts in your reports.
- [Create and Manage Org Charts](https://kb.pigment.com/docs/org-charts.md): Set up and customize Org Charts in Pigment to visualize hierarchies, navigate teams, apply filters, and add interactive actions.
- [How to set up an Org Chart](https://kb.pigment.com/docs/set-up-an-org-chart.md): Create and configure Org Charts in Pigment to visualize hierarchies using Tables, Metrics, and custom settings for clear team structures.
- [How to navigate an Org Chart](https://kb.pigment.com/docs/navigate-org-chart.md): Explore Org Charts in Pigment to visualize team hierarchies, navigate relationships, and interact with cards for deeper organizational insights.
- [Add Action Buttons to an Org Chart](https://kb.pigment.com/docs/add-action-buttons-org-chart.md): Add Action buttons to Pigment's Org Chart to enable members to add Items directly from cards, facilitating efficient management and tracking.
- [Add Filters to an Org Chart](https://kb.pigment.com/docs/add-filters-org-chart.md): Highlight specific criteria in your Org Chart with Org Chart filters. Learn to set up and apply multiple filters to enhance data visibility and relevance.
- [Create and Manage Widgets](https://kb.pigment.com/docs/widgets.md): Enhance Pigment Boards with widgets for actions, text, images, and KPIs to create interactive, user-friendly layouts.
- [Add Action Buttons to Grid Headers](https://kb.pigment.com/docs/add-action-buttons-to-grid-headers.md): Learn how to add, edit, or remove Action buttons in grid header cells in Pigment—linking Items to Boards or Sequences with current page filters carried through seamlessly.
- [How to Use Text Widgets](https://kb.pigment.com/docs/how-to-use-text-widgets.md): Learn how to use text widgets on Boards to add context, instructions, and formatting options for enhanced user interaction and clarity.
- [How to Use Image Widgets](https://kb.pigment.com/docs/image-widgets.md): Learn to use Image Widgets in Pigment Boards to upload logos, adjust display settings, and enhance visual clarity across Boards.
- [How to Use Action Widgets](https://kb.pigment.com/docs/action-widgets.md): Use Action widgets on Pigment Boards to import data, add Items, link out, and navigate Sequences—streamline workflows and boost engagement.
- [How to Use a Dimensioned Text Widget](https://kb.pigment.com/docs/dimensioned-text-widget.md): Set up Dimensioned Text Widgets in Pigment to display editable text Metrics on Boards, adding dynamic notes and summaries by Dimension.
- [Display Performance Measurements with KPI Widgets](https://kb.pigment.com/docs/display-performance-kpi-widgets.md): Display KPIs in Pigment Boards with trend lines and formatting to track performance, highlight key Metrics, and gain clearer business insights.
- [Interacting with Widgets on a Board](https://kb.pigment.com/docs/interact-widgets-board.md): Interact with charts and grids on Pigment Boards by adjusting Views, saving changes, and exporting data for flexible reporting and analysis.
- [Customize Boards](https://kb.pigment.com/docs/customize-boards.md): Discover how to manage Board display settings in Pigment, including selectors, adaptive controls, homepage Boards, and PDF export.
- [Create a Sequence for Input Flows](https://kb.pigment.com/docs/create-a-sequence-for-input-flows.md): Streamline data input with Sequences in Pigment, guiding Members through structured processes for financial, workforce, and sales planning.
- [Use Selectors in Views and Boards](https://kb.pigment.com/docs/use-selectors-context-views-boards.md): Configure selectors in Pigment to enhance Boards and widgets, delivering tailored data views and a more intuitive user experience.
- [Hide and Minimize Board and Widget Selectors in Display Mode](https://kb.pigment.com/docs/hide-widget-selectors-display-mode.md): Customize board and widget views in Pigment by hiding or minimizing selectors for a more focused, streamlined user experience.
- [Export Boards to PDF](https://kb.pigment.com/docs/export-boards-to-pdf.md): Export Pigment Boards as PDF or PNG to share full Boards or individual widgets, making insights easy to capture, present, and distribute.
- [Trigger exports from a Board](https://kb.pigment.com/docs/trigger-exports-from-a-board.md)
- [Set a Homepage Board for Members](https://kb.pigment.com/docs/set-homepage-board-members.md): Create role-based homepage Boards in Pigment for streamlined access and a personalized user experience across your Workspace.
- [Application Snapshots](https://kb.pigment.com/docs/application-snapshots.md): Learn how to create and manage Snapshots, preserving your Application's data and settings at a specific point in time for future reference.
- [Manage Snapshots](https://kb.pigment.com/docs/manage-snapshots.md): Manage and organize Snapshots easily: rename, hide, delete, and import data while navigating through multiple Applications in the Snapshots panel.
- [Manage access and permissions in a Snapshot](https://kb.pigment.com/docs/manage-access-and-permissions-in-a-snapshot.md): Manage access in Snapshots with editable Security Blocks. Update permissions for Members while keeping calculations intact. Learn how to modify access effectively.
- [How to Use Compare to Snapshot](https://kb.pigment.com/docs/use-compare-to-snapshot.md): Use Scenarios with Compare to Snapshot in Pigment to view changes between live data and Snapshots side by side for accurate model comparisons.
- [Manage Application Snapshot Limits](https://kb.pigment.com/docs/application-snapshot-limits.md): Manage your Snapshot usage effectively in Workspace. Review limits, delete unnecessary Snapshots, and maintain optimal Workspace hygiene.
- [Member Access & Permissions](https://kb.pigment.com/docs/member-access-permissions.md): The documentation in this section gives guidance on how to manage your organization’s Members in Pigment, including advice on access rights, reassigning the primary owner account and audit history.
- [Account Types and Management](https://kb.pigment.com/docs/account-types-management.md): Understand Pigment’s account roles and permissions to manage your Workspace better. Includes Primary Owner, Security Admin, and Standard Member types.
- [Manage Member Accounts in Pigment](https://kb.pigment.com/docs/manage-member-accounts-pigment.md): Manage Pigment members with ease—invite, edit, and deactivate accounts to streamline access and keep your Workspace user management organized and secure.
- [Switch your Admin Account Type](https://kb.pigment.com/docs/switch-admin-account-type.md): Learn how to switch Admin account types in Pigment, including handling Primary Owner roles, API keys, and scheduled imports when an admin leaves your org.
- [Extract a list of Pigment Members](https://kb.pigment.com/docs/extract-list-pigment-members.md)
- [Pigment License Types](https://kb.pigment.com/docs/pigment-license-types.md): Learn about Pigment’s license types, including Explorer, Contributor, and Editor, with insights into included features and pricing plan options.
- [Pigment License Types \[Legacy v2\]](https://kb.pigment.com/docs/pigment-license-types-legacy-v2.md): Explore Pigment's legacy licensing plans, features, and permissions, and learn how to manage your current plan effectively.
- [Pigment License Types \[Legacy v1\]](https://kb.pigment.com/docs/pigment-license-types-legacy-v1.md): Explore Pigment’s legacy v1 licensing plans, including Modeler, Contributor, and Explorer, for context on historical access levels and user roles.
- [Pigment Access Rights Basics](https://kb.pigment.com/docs/pigment-access-rights-basics.md): Learn the basics of access rights in Pigment, including how to manage user permissions and secure data visibility across Applications and Workspace models.
- [About Roles, Permissions and Access Rights](https://kb.pigment.com/docs/roles-permissions-access-rights.md): Explore how Pigment uses roles, permissions, and access rights to control user access, maintain data integrity, and support secure workflows.
- [Introduction to Access Rights](https://kb.pigment.com/docs/introduction-access-rights.md): Learn about access rights in Pigment—key to managing user permissions, securing data, and ensuring proper interaction and visibility across your Workspace.
- [About Access Rights Metrics and Rules](https://kb.pigment.com/docs/access-rights-metrics-rules.md): Learn how to set up access rights in Pigment for better data security and workflow efficiency through clear permission rules and smart configuration tips.
- [Create an Access Rights Metric and Rules](https://kb.pigment.com/docs/create-access-rights-metric-rules.md): Set up access rights Metrics and rules in Pigment to manage data access in your model using Block Explorer or the wizard for enhanced security and control.
- [Use Board Permissions to Grant Board Access](https://kb.pigment.com/docs/board-permissions-grant-board-access.md): Learn how to use Board permissions in Pigment, understand permission levels, and assign access to Members for effective control within your Application.
- [Advanced Pigment Access](https://kb.pigment.com/docs/advanced-pigment-access.md): The guidance in this section focuses on managing access rights, covering inheritance and Dimension replacement, and provides answers to frequently asked questions on access rights configuration.
- [About Dimension replacement in access rights rules](https://kb.pigment.com/docs/about-dimension-replacement-access-rights-rules.md): Optimize access rights with Dimension replacement to enhance security, improve performance, and simplify management in complex datasets.
- [Understand Access Rights Inheritance](https://kb.pigment.com/docs/understand-access-rights-inheritance.md): Explore how to manage access rights inheritance in Pigment using the dependency diagram to view, adjust, and control permission configurations effectively.
- [Add or Remove Access Rights Inheritance](https://kb.pigment.com/docs/add-remove-access-rights-inheritance.md): Learn how access rights inheritance works in Pigment, including App-level options and best practices to manage security settings across your Applications.
- [Use the RESETACCESSRIGHTS Function](https://kb.pigment.com/docs/reset-access-rights-function.md): Use the RESETACCESSRIGHTS function in Pigment to reset access settings. Explore examples and best practices for maintaining secure data permissions.
- [FAQs: Access Rights Configurations](https://kb.pigment.com/docs/faqs-access-rights-configurations.md): Explore how to manage access rights in Pigment with answers to FAQs on roles, permissions, and inheritance for better security and user access control.
- [Groups and Role Management](https://kb.pigment.com/docs/groups-role-management.md): This section introduces the Pigment concepts of Groups and Roles and outlines how to manage Roles in your Application, and use Groups to assign Roles.
- [Manage Your Pigment Roles](https://kb.pigment.com/docs/manage-pigment-roles.md): Learn how to manage roles in Pigment by creating, editing, and assigning them to control access rights and maintain secure Application permissions.
- [Introduction to Groups](https://kb.pigment.com/docs/introduction-to-groups.md): Manage roles and permissions in Pigment with Groups, giving Security Admins a centralized way to control access across all Members and Applications.
- [Use Groups to Assign Roles](https://kb.pigment.com/docs/use-groups-assign-roles.md): Learn how to assign roles in Pigment with Groups, simplify access control using CSV uploads, and handle conflicts for clean, efficient user management.
- [Access Rights on Scenarios](https://kb.pigment.com/docs/access-rights-scenarios.md): Set up access rights for Scenarios in Pigment to manage member permissions, ensure data security, and maintain control across your planning environment.
- [Set Up Access Rights on Scenarios](https://kb.pigment.com/docs/setup-access-rights-scenarios.md): Manage access rights for Scenarios in Pigment to secure sensitive data and enable efficient team collaboration within your Workspace environment.
- [Auditing and Monitoring](https://kb.pigment.com/docs/audit-monitor.md): Track application changes and monitor Workspace activity in Pigment using update history and the Audit Logs API.
- [View and Track Application Update History](https://kb.pigment.com/docs/track-application-update-history.md): Track Application update history in Pigment, including changes to Dimension Lists, Transaction Lists, and Metrics made by Members for clear audit trails.
- [Monitor your Pigment Workspace with Audit Logs API](https://kb.pigment.com/docs/pigment-workspace-audit-logs-api.md): Monitor user activity and security with Pigment's Audit Logs API, ensuring compliance and detecting suspicious behavior in your Workspace.
- [Create an Audit Logs API Key](https://kb.pigment.com/docs/create-audit-logs-api-key.md): Learn how to create an Audit Logs API key in Pigment to track user activity, monitor events, and enhance Workspace security through automated log access.
- [Call the Audit Logs API](https://kb.pigment.com/docs/call-audit-logs-api.md): Monitor member activity and detect security issues using Pigment’s Audit Logs API. Learn how to track events and ensure secure authentication effectively.
- [Audit Logs API Events and Event Types](https://kb.pigment.com/docs/audit-logs-api-event-types.md): Explore Pigment’s Audit Log API to track user activity, understand event types, and manage your Workspace effectively with detailed event structures.
- [Security & Compliance](https://kb.pigment.com/docs/security-compliance.md): The documentation in this section outlines key security and compliance topics in Pigment, including trustless modeling, API key management and Single Sign-On (SSO) systems.
- [Use the Security Folder for Trustless Modeling](https://kb.pigment.com/docs/security-folder-trustless-modeling.md): Secure your Pigment Application by managing Modeler permissions and isolating sensitive formulas using the Security Folder for trustless modeling.
- [Manage API keys](https://kb.pigment.com/docs/manage-api-keys.md): Manage API keys in Pigment to enable secure integration, control access, and monitor usage across your Workspace with clear key management tools.
- [Configure an IP Allow List for API Keys](https://kb.pigment.com/docs/configure-ip-allow-list-api-keys.md): Learn to configure an IP Allow list for your API Keys in Pigment, enhancing security by restricting access to specific IP addresses.
- [Work With System for Cross-Domain Identity Management (SCIM) and Domain Restriction](https://kb.pigment.com/docs/manage-scim-domain-restriction.md): Use SCIM and domain restrictions in Pigment to manage identity, automate provisioning, and control member access across your Workspace securely.
- [Configure Multi-Factor Authentication (MFA/2FA)](https://kb.pigment.com/docs/configure-multi-factor-authentication-mfa2fa.md): Strengthen security with MFA 2FA configuration in Pigment. Learn how to enable multi-factor authentication, choose sign-in methods, and protect your data.
- [Configure Single Sign-On (SSO) with Pigment](https://kb.pigment.com/docs/configure-single-sign-on-sso-pigment.md): Set up Single Sign-On SSO with SAML 2.0 in Pigment to simplify access, centralize identity management, and enhance Workspace security for all users.
- [Define Essential Contacts for Urgent Notifications](https://kb.pigment.com/docs/define-essential-contacts-for-urgent-notifications.md): How to specify email addresses to receive notifications relating to data protection, legal issues and technical security.
- [Customer Guidance for using Pigment as a SOX-Compliant Environment](https://kb.pigment.com/docs/customer-guidance-pigment-sox-compliant.md): Discover how Pigment helps meet SOX requirements with tools for access management, change tracking, and audit logging to support secure governance.
- [Access Support](https://kb.pigment.com/docs/access-support.md): Troubleshoot access rights issues in Pigment. Get support to fix permission errors and ensure users have the correct roles and data access in your Workspace.
- [Use Impersonation to Review User Access and Experience](https://kb.pigment.com/docs/review-access-rights-with-impersonate.md): Explore how Pigment’s Impersonate feature helps validate user access rights and permissions for secure and accurate Workspace role management.
- [Grant Support Access to Your Environment](https://kb.pigment.com/docs/enable-support-access-pigment.md): Workspace Admins can grant or revoke Pigment Support access to your Application with clear, step-by-step instructions for secure and efficient troubleshooting.
- [Import & Export Data](https://kb.pigment.com/docs/import-export-data.md): Use this section to learn how to connect Pigment to external platforms and tools, covering native and non-native integrations, API and other import/export-related topics.
- [Import Data into Pigment](https://kb.pigment.com/docs/import-data.md): This documentation focuses on importing data, covering List-to-List and Metric-to-Metric importing, clearing Items prior to importing and how to set column-specific column definitions.
- [Set Up List-to-List Import](https://kb.pigment.com/docs/set-up-list-to-list-import.md): Learn how to configure List-to-List imports, mapping data types between Lists, and manage permissions for seamless data transfer in your application.
- [Choose Fixed or Latest File in Storage Connectors](https://kb.pigment.com/docs/fixed-most-recent-file-storage-connectors.md): Learn about storage connectors' import modes: Fixed file and Most recent file, including naming conventions and path setup for efficient data management.
- [How to Manually Run Imports](https://kb.pigment.com/docs/manually-run-imports.md): Learn how to import data into Pigment using CSV files or integrations, ensuring accurate configurations for seamless planning and data management.
- [How to Set Column-Specific Data Definitions in Imports](https://kb.pigment.com/docs/set-column-specific-data-definitions.md): Learn how to customize number and date formats in Pigment imports for accurate data mapping and seamless integration of your special formatted data.
- [Schedule Imports in Pigment](https://kb.pigment.com/docs/schedule-imports.md): Automate data imports in Pigment with our step-by-step guide on scheduling imports, ensuring timely updates and notifications for your application.
- [Clear Items prior to import](https://kb.pigment.com/docs/clear-items-prior.md): Learn how to use the Clear Items prior to import option in Transaction Lists and Metrics to manage and update your data imports.
- [How to Import Data Manually into Lists](https://kb.pigment.com/docs/import-manually-lists.md): Learn how to import data into Pigment using CSV files, ensuring proper permissions and file structure for seamless List updates and creation.
- [Metric-to-Metric Import](https://kb.pigment.com/docs/metric-import.md): Learn how to configure Metric to Metric importing for efficient data management, reducing recalculations and improving performance in your applications.
- [Apply Access Rights to Admins Importing Data](https://kb.pigment.com/docs/apply-access-rights-admins.md): Learn how Access Rights impact data imports in Metrics and Lists, ensuring Members with permissions can only import where they have Write access.
- [How to Generate an Import Configurations ID in Pigment](https://kb.pigment.com/docs/generate-import-config-id.md): Learn to generate an import configurations ID for connecting external data sources like Looker or Workday to Pigment in just three simple steps.
- [How to export data from Workday to Pigment](https://kb.pigment.com/docs/export-workday.md): Learn how to transfer data from Workday to Pigment with a three-step process, including custom reports and automated updates for seamless integration.
- [Data Actions & Flows](https://kb.pigment.com/docs/data-actions-flows.md): Learn how to automate imports and operations using Data Actions, Data Flows, and Parameters in Pigment. Create reusable workflows and run configurable imports from Boards.
- [Create and Manage Data Flows](https://kb.pigment.com/docs/create-and-manage-data-flows.md): Create and manage Data Flows to streamline Data Actions and simplify application management with automation and efficiency.
- [Customize Data Actions with Parameters](https://kb.pigment.com/docs/customize-data-actions-with-parameters.md): Learn to create and use Parameters for reusable Data Actions, enabling members to select values for imports and enhance data management efficiency.
- [Export Data from Pigment](https://kb.pigment.com/docs/export-data.md): This documentation describes downloading data from Pigment, exporting with APIs and filters, and sending data to other tools, including platforms such as Snowflake, Google Cloud Storage, Microsoft Azure, Amazon S3, Fivetran, and Salesforce.
- [How to export data from Pigment with APIs](https://kb.pigment.com/docs/export-data-with-apis.md): Learn how to export data from Pigment using the REST API, including setup, authentication, and output formats for Metric, List, and Table Blocks.
- [Export raw data from a Pigment Block](https://kb.pigment.com/docs/raw-data-block.md): Export raw data from Pigment's Lists, Metrics, and Tables Blocks using our REST API for scalable, efficient data management and CSV output.
- [How exportFilter works for Table and Metric exports](https://kb.pigment.com/docs/how-exportfilter-works-for-table-and-metric-exports.md)
- [Download your data from Pigment](https://kb.pigment.com/docs/download-your-data-from-pigment.md): Learn how to download data in Pigment as CSV or Excel, maintaining formatting and choosing separators for easy sharing and use in other applications.
- [Export Pigment data to Google Cloud Storage](https://kb.pigment.com/docs/export-google-cloud-storage.md): Transfer data from Pigment to Google Cloud Storage using our REST API and Python script. Schedule regular exports for seamless data management.
- [Export Pigment data to Snowflake](https://kb.pigment.com/docs/export-snowflake.md)
- [Export Pigment data to Fivetran](https://kb.pigment.com/docs/export-fivetran.md): Transfer data from Pigment to Fivetran using our REST API. Learn how to export your Views, Lists, Metrics, and Tables to your cloud server.
- [Export Pigment data to Microsoft Azure](https://kb.pigment.com/docs/export-microsoft-azure.md): Transfer your Pigment data to Azure Blob Storage or ADLS Gen2 using Azure Data Factory. Learn to set up linked services and create datasets efficiently.
- [Export Pigment data to Salesforce](https://kb.pigment.com/docs/export-salesforce.md): Transfer your Pigment data to Salesforce using Azure Data Factory. Learn to set up linked services, datasets, and automate your data pipeline efficiently.
- [Export Pigment data to Amazon S3](https://kb.pigment.com/docs/export-amazon-s3.md): Transfer Pigment data to Amazon S3 using our REST API and AWS Lambda. Follow our guide for seamless exports and scheduling with EventBridge.
- [API Management](https://kb.pigment.com/docs/api-management.md): This documentation section includes information on how to use APIs to trigger imports, retrieve metadata, and check status, as well as rate limits for the Pigment Public API, and REST Client sample API requests.
- [Rate Limits for Pigment Public API](https://kb.pigment.com/docs/rate-limits-for-pigment-public-api.md): Learn about rate limits for the Pigment Public API, including request thresholds, usage guidelines, and best practices to ensure reliable and efficient integration.
- [Connect Pigment with an External Service Through an API request](https://kb.pigment.com/docs/connect-service-through-api.md): Connect your Pigment app to external services using API requests, enabling real-time data updates and streamlined workflows with Action widgets.
- [REST Client Sample API Requests](https://kb.pigment.com/docs/rest-client-sample-api-requests.md): Explore Pigment's API sample collection, easily importable into REST clients, and learn to use environment variables for seamless integration.
- [Retrieve Entity Information With the Metadata API](https://kb.pigment.com/docs/retrieve-info-metadata-api.md): Access Pigment's metadata APIs for Applications, Blocks, and Import Configurations with user-friendly integration options and secure authentication.
- [Trigger an import and check status with APIs](https://kb.pigment.com/docs/trigger-import-apis.md): Automate your data import process with Pigment's API. Learn how to use the Import API, manage API keys, and check import status effectively.
- [Active Pigment Connectors](https://kb.pigment.com/docs/active-pigment-connectors.md): See guidance on Pigment's integrations and connectors all in one handy location
- [Integration Management](https://kb.pigment.com/docs/integration-management.md): This documentation provides guidance on editing Pigment integrations, non-sensitive versus sensitive data and connection testing.
- [Edit Pigment Integration Connections](https://kb.pigment.com/docs/edit-pigment-integration-connections.md): Edit your integration connections in Pigment easily while protecting sensitive data. Update non-sensitive fields without creating new connections.
- [Test Connection for Pigment Integration](https://kb.pigment.com/docs/test-connection-for-pigment-integration.md): Connection testing is an easy way to ensure your Pigment integrations are properly set up before using them to configure an import.
- [Native Pigment Integrations](https://kb.pigment.com/docs/native-pigment-integrations.md): Native Pigment integrations let you connect external applications and data sources and load data into Pigment for modeling planning and analysis.
- [Connect Pigment with Amazon Redshift](https://kb.pigment.com/docs/connect-amazon-redshift.md): Learn to connect Amazon Redshift with Pigment, configure users, and import data seamlessly using SQL queries for efficient data management.
- [Connect Pigment with AWS S3](https://kb.pigment.com/docs/connect-aws-s3.md): Learn to connect your Amazon S3 bucket to Pigment, enabling seamless CSV file imports with secure IAM user access and flexible file naming conventions.
- [Connect Pigment with Ashby](https://kb.pigment.com/docs/connect-ashby.md): Connect Ashby with Pigment to streamline applicant tracking, from job postings to data imports, enhancing your hiring process efficiently.
- [Connect Pigment with Azure Blob Storage](https://kb.pigment.com/docs/connect-azure-blob-storage.md): Learn to connect Azure Blob Storage to your Pigment Organization and import CSV files seamlessly into your Pigment Blocks with this step-by-step guide.
- [Connect Pigment with Azure SQL](https://kb.pigment.com/docs/connect-azure-sql.md): Learn to connect Azure SQL with Pigment, configure access, and import SQL query results seamlessly into your Pigment applications.
- [Connect Pigment with BambooHR](https://kb.pigment.com/docs/connect-bamboohr.md): Learn to connect BambooHR with Pigment to import report data seamlessly. Follow our guide for easy setup and integration steps!
- [Connect Pigment with Databricks](https://kb.pigment.com/docs/connect-pigment-with-databricks.md): Learn to connect Databricks Tables with Pigment using Delta Sharing for secure data sharing. Set up your integration and import data seamlessly.
- [Connect Pigment with Google BigQuery](https://kb.pigment.com/docs/connect-google-bigquery.md): Learn to connect Google BigQuery datasets with Pigment, configure connections, and import query results seamlessly into your Pigment blocks.
- [Connect Pigment with Google Cloud Storage](https://kb.pigment.com/docs/connect-google-cloud-storage.md): Learn to connect Google Cloud Storage with Pigment to import CSV files seamlessly, enhancing your data management and analysis capabilities.
- [Connect Pigment with Greenhouse](https://kb.pigment.com/docs/connect-greenhouse.md): Connect Greenhouse with Pigment to import Offers, Jobs, Openings, and Candidates data seamlessly. Learn how to set up your integration today!
- [Connect Pigment with HiBob](https://kb.pigment.com/docs/connect-hibob.md): Connect HiBob with Pigment to import report data seamlessly. Learn to configure connections and retrieve insights effortlessly!
- [Connect Pigment with Lever](https://kb.pigment.com/docs/connect-lever.md): Learn to connect Lever with Pigment to import Requisition and Opportunities data seamlessly, enhancing your data integration process.
- [Connect Pigment with Lucca](https://kb.pigment.com/docs/connect-lucca.md): Connect Lucca with Pigment to import Users and Remunerations data seamlessly. Learn how to set up the integration and configure your API key.
- [Connect Pigment with Netsuite](https://kb.pigment.com/docs/connect-netsuite.md): Integrate Pigment with NetSuite to access real-time Financial, Vendor, and Asset data effortlessly. Follow our guide for seamless configuration steps.
- [NetSuite Integration: Create Transaction Saved Searches](https://kb.pigment.com/docs/netsuite-integration-create-transaction-saved-searches.md): Learn to create and retrieve NetSuite Saved Searches for financial data in Pigment with this step-by-step guide, including tips and tricks for success.
- [NetSuite Integration: Troubleshoot Common Errors](https://kb.pigment.com/docs/netsuite-integration-troubleshoot-common-errors.md): Troubleshoot common Pigment-NetSuite integration errors with our guide, ensuring proper permissions and configurations for seamless connectivity.
- [NetSuite Integration: Pigment Role Permissions](https://kb.pigment.com/docs/netsuite-integration-pigment-role-permissions.md): Configure Pigment role permissions in NetSuite with our step-by-step guide to ensure proper data access for your saved searches.
- [Connect Pigment with Paylocity](https://kb.pigment.com/docs/connect-paylocity.md): Learn how to connect Paylocity with Pigment to import your data seamlessly. Follow our step-by-step guide for API access and configuration.
- [Connect Pigment with Personio](https://kb.pigment.com/docs/connect-personio.md): Learn to connect Personio with Pigment for seamless custom report integration. Follow our step-by-step guide to set up and import data effortlessly.
- [Connect Pigment with Intuit QuickBooks](https://kb.pigment.com/docs/connect-intuit-quickbooks.md): Learn how to connect QuickBooks with Pigment to import your data seamlessly and enhance your financial management. Step-by-step guide included!
- [Connect Pigment with Sage Intacct](https://kb.pigment.com/docs/connect-sage-intacct.md): Learn how to connect Sage Intacct with Pigment to import data seamlessly, ensuring secure access and efficient data management.
- [Connect Pigment with Salesforce](https://kb.pigment.com/docs/connect-salesforce.md): Connect Salesforce to your Pigment Workspace to import report data effortlessly. Learn to configure connections and use SOQL for custom queries.
- [Connect Pigment with SAP S/4HANA Public Cloud](https://kb.pigment.com/docs/connect-sap-s4hana-public-cloud.md): Seamlessly connect Pigment to SAP S/4HANA Public Cloud, load data via ODATA v2 APIs, and schedule synchronization with easy setup steps.
- [Connect Pigment with an SFTP server](https://kb.pigment.com/docs/connect-sftp-server.md): Learn to connect an SFTP server to Pigment for seamless CSV file imports, ensuring secure access with SSH key authentication and proper file naming conventions.
- [Connect Pigment with Snowflake](https://kb.pigment.com/docs/connect-snowflake.md): Learn how to connect Snowflake with Pigment for seamless data integration and query results retrieval in your applications.
- [Connect Pigment with Xero](https://kb.pigment.com/docs/connect-xero.md): Learn how to connect Xero with Pigment to import General Ledger data efficiently using filtering options for optimized performance.
- [Non-native integrations](https://kb.pigment.com/docs/non-native-integrations.md): Use non native integrations to connect additional applications and data sources to Pigment using external tools or connectors.
- [Pigment Connector for Excel](https://kb.pigment.com/docs/connect-excel.md): Connect Pigment Applications with Excel using the Pigment Connector to seamlessly push and pull data. Learn how to set up and manage connections effectively.
- [Troubleshooting Pigment Connector for Excel](https://kb.pigment.com/docs/troubleshoot-connector-excel.md): Troubleshoot Pigment’s Excel Connector issues, and restore your workflow with our step-by-step guide.
- [How to install Pigment's Connector for Google Sheets](https://kb.pigment.com/docs/install-gsheets-connector.md): Easily install the Pigment Google Sheet Connector to load saved views and push data between Pigment and Google Sheets, all with your Pigment credentials.
- [How to Troubleshoot not being able to sign in to GSheet connector](https://kb.pigment.com/docs/sign-in-gsheet-connector.md): Follow these simple steps if you are having trouble signing in to the GSheet connector
- [Load Data from Pigment into Google Sheets](https://kb.pigment.com/docs/load-data-gsheets.md): Load up to 50MB of data into Google Sheets from Pigment views with the Pigment Connector. Learn how to manage connections and refresh data easily.
- [Connect Pigment To Your Mulesoft Flows](https://kb.pigment.com/docs/connect-mulesoft-flows.md): Learn how to integrate Pigment API calls in Mulesoft for data import/export, enhancing your ETL processes with seamless connectivity and analysis.
- [Push data from Google Sheets Into Pigment](https://kb.pigment.com/docs/push-gsheets.md): Learn how to configure the Pigment Connector for Google Sheets to seamlessly push data into Pigment with easy installation and mapping steps.
- [How to Push Data From Looker to Pigment](https://kb.pigment.com/docs/push-data-looker-pigment.md): Export Looker data to Pigment via email, SFTP, or Webhook with options for one-shot or recurring deliveries while managing row limits effectively.
- [Connect Pigment with PowerBI](https://kb.pigment.com/docs/connect-powerbi.md): Learn to load Pigment data in PowerBI using the API. Follow simple steps to set up API credentials and import data seamlessly.
- [Connect Pigment with SAP](https://kb.pigment.com/docs/connect-sap.md): Learn how to connect SAP with Pigment using native connectors, CSV exports, and third-party solutions for seamless data integration and synchronization.
- [Pigment Connector for PowerPoint](https://kb.pigment.com/docs/pigment-connector-for-powerpoint.md): Integrate live Pigment Views into PowerPoint with the Pigment Connector. Easily insert charts and grids, and keep your slides updated with real-time data.
- [Collaborate in Pigment](https://kb.pigment.com/docs/collaborate.md): Collaborate in Pigment with notifications, workflows, automations, and tasks that keep teams aligned and work moving automatically.
- [Work with Notifications](https://kb.pigment.com/docs/notifications.md): Learn how to work with notifications in Pigment to stay informed with centralized alerts, automated notifications, and Slack integration.
- [Pigment's Notification Center](https://kb.pigment.com/docs/notification-center.md): Explore Pigment's Notification Center: understand notifications for conversations, workflows, imports, and tasks, and learn how to manage your preferences.
- [Set Up a Pigment Automated Notification](https://kb.pigment.com/docs/set-up-automated-notification.md): Learn to set up automated notifications in Pigment Automations using Metrics, ensuring you receive timely alerts tailored to your needs.
- [Pigment App for Slack](https://kb.pigment.com/docs/app-for-slack.md): Integrate the Pigment App with Slack to receive real-time notifications, enhancing your workflow and keeping you informed on tasks and conversations.
- [Work with Automations](https://kb.pigment.com/docs/automations.md): Learn how to automate workflows in Pigment with data-driven triggers, task assignments, and conditional routing to scale collaboration.
- [Automate your Pigment Applications](https://kb.pigment.com/docs/automate-applications.md): Streamline your workflow with Pigment Automations. Set Metrics to trigger notifications and tasks, enhancing efficiency and collaboration in your team.
- [Set Up a Pigment Automated Task](https://kb.pigment.com/docs/set-up-automated-task.md): Learn to set up automated tasks in Pigment Automations, manage triggers, and assign members for efficient collaboration and task management.
- [Interact with your Assigned Tasks](https://kb.pigment.com/docs/assigned-tasks.md): Learn how to manage your tasks in Pigment, receive notifications, and mark tasks as done efficiently. Get started with your task management today!
- [Set Up a Pigment Workflow](https://kb.pigment.com/docs/set-up-workflow.md): Learn how to set up Pigment Automations workflows, manage tasks, and notifications effectively as a workflow owner. Optimize your task management today!
- [Set up Conditional Recipients and Assignees](https://kb.pigment.com/docs/set-up-conditional-recipients-assignees.md): Learn to set up direct and conditional recipients and assignees in Automations for effective notifications and task management.
- [Troubleshoot Automations](https://kb.pigment.com/docs/troubleshoot-automations.md): Troubleshoot Automations and Notifications effectively by understanding success vs. incomplete executions, access rights, and rate limits.
- [Collaborate on Application Data](https://kb.pigment.com/docs/collaborate-app-data.md): This page introduces a documentation section offering guidance on using Boards, Libraries and Blocks when collaborating in Pigment.
- [Add Items to a List from a Board](https://kb.pigment.com/docs/add-items-to-list-from-board.md): Learn how to add Items to a Dimension List with various methods, enhancing user experience on your Board with customizable options and permissions.
- [Use Libraries to Share data between Applications](https://kb.pigment.com/docs/use-libraries.md): Access and share Blocks and Views in Pigment Libraries for efficient data collaboration across applications, ensuring accuracy and consistency in your organization.
- [Share Blocks Between Applications](https://kb.pigment.com/docs/share-blocks-between-applications.md): Share and reuse Blocks in Pigment for efficient collaboration across Applications, ensuring consistency in Metrics and Lists without duplication.
- [Display Views on Other Applications' Boards](https://kb.pigment.com/docs/display-views-other-apps-boards.md): Streamline collaboration by adding Views to Application Libraries in Pigment, enhancing data sharing without duplication across teams.
- [Create and Edit a Board in an Application](https://kb.pigment.com/docs/create-edit-board-application.md): Learn how to create and customize Boards with various widgets, icons, and colors for effective data interaction and organization.
- [Add Comments on a Board](https://kb.pigment.com/docs/add-comments-on-board.md): Learn how to comment, tag members, and manage private conversations on Boards to enhance team collaboration and data visualization.
- [Pigment AI](https://kb.pigment.com/docs/pigment-ai.md): Explore Pigment AI's tools like the Navigation, Data, and Documentation Assistants, Insights, and more.
- [Pigment AI Agents](https://kb.pigment.com/docs/pigment-agents.md): Learn about Pigment's Agentic workforce
- [Run the Modeler Agent](https://kb.pigment.com/docs/configure-and-run-the-modeler-agent.md)
- [Run the Analyst Agent](https://kb.pigment.com/docs/configure-and-run-the-conversational-analyst-agent.md)
- [Mission instructions for the Analyst Agent](https://kb.pigment.com/docs/write-prompts-for-the-analyst-agent.md): Craft clear, structured instructions for the Analyst Agent, specifying data, analysis steps, and output format for effective reporting and insights.
- [Edit and share Analyst Agent reports](https://kb.pigment.com/docs/edit-analyst-agent-reports.md): Learn to edit and share Reports using Rich Text functionality. Discover tips to optimize your Report editing and sharing process.
- [Build and Run Custom Agents](https://kb.pigment.com/docs/create-custom-agents.md): Create specialized AI Agents with Pigment to enhance data analysis and workflow efficiency, tailored to your team's unique needs and resources.
- [Run the Documentation Agent](https://kb.pigment.com/docs/configure-and-run-the-documentation-agent.md)
- [Attach files to AI Chats](https://kb.pigment.com/docs/upload-files-to-the-agents.md): Learn how to attach files to AI Chats with Pigment Agents, including supported formats, size limits, and security checks for safe uploads.
- [How Pigment AI handles your data](https://kb.pigment.com/docs/the-ai-behind-pigment-agents.md): Learn about the safeguards and care Pigment takes with data used by AI tools.
- [Machine Learning Forecasting](https://kb.pigment.com/docs/machine-learning-forecasting.md): Unlock accurate forecasting with Predictions, leveraging machine learning for improved accuracy, external factors, and user-friendly access within Pigment.
- [Choose your Prediction model](https://kb.pigment.com/docs/choose-prediction-model.md): Explore the Predictions tool's forecasting models, including AutoML, Prophet, and AutoETS, to enhance your data-driven decision-making.
- [Use External Factors in your Predictions](https://kb.pigment.com/docs/use-external-factors-predictions.md): Enhance your forecast accuracy by integrating external factors like weather and pricing changes. Learn best practices for effective predictions with Pigment.
- [Understand Predictions’ Accuracy Measures](https://kb.pigment.com/docs/accuracy-measures.md): Enhance your forecasting with Pigment's accuracy tests, comparing models and speeding up predictions while building trust in your data insights.
- [MCP Server](https://kb.pigment.com/docs/mcp-server-1.md)
- [Supported tools](https://kb.pigment.com/docs/supported-tools.md)
- [Connect common MCP Clients](https://kb.pigment.com/docs/connect-common-mcp-clients.md)
- [Connect custom MCP Clients](https://kb.pigment.com/docs/connect-a-custom-application.md)
- [Other Pigment AI features](https://kb.pigment.com/docs/other-pigment-ai-features.md)
- [AI credits](https://kb.pigment.com/docs/ai-credits.md): Learn about AI credits in Pigment, their consumption, management, and how they enable efficient use of AI features in your Workspace.
- [Frequently Asked Questions](https://kb.pigment.com/docs/ai-faq.md): Answer all your questions on Pigment AI's generative assistants in one handy page.
- [Test & Deploy](https://kb.pigment.com/docs/test-deploy.md): Test & Deploy lets you test model changes using sample data before deploying them with live, production data to a shared Workspace.
- [Introduction to Test & Deploy](https://kb.pigment.com/docs/introduction-test-deploy.md): Learn how T&D in Pigment enhances model testing across Dev, Test, and Prod environments, ensuring control and compliance in your workflow.
- [Considerations for Opting into Test & Deploy](https://kb.pigment.com/docs/test-deploy-opt-in-considerations.md): Evaluate if Test & Deploy in Pigment suits your needs with insights on managing changes, team readiness, and effective release management.
- [About Deploying Changes in Test & Deploy](https://kb.pigment.com/docs/deploy-changes-test-environment.md): Learn about deploying changes in T&D, including full and partial deployments, permissions, and managing boards for a seamless Prod environment transition.
- [Map Out Your Test & Deploy Environments](https://kb.pigment.com/docs/test-deploy-environment-mapping.md): Define your T&D scope and manage applications effectively in Pigment. Learn key considerations for Application management and dependencies.
- [What are Structural Changes in Test & Deploy?](https://kb.pigment.com/docs/structural-changes-test-deploy.md): Learn about structural changes in Dev and Prod environments, including permissions and management by T&D, to optimize your Pigment Application.
- [Manage Data Changes](https://kb.pigment.com/docs/manage-data-changes.md): Learn how to manage connected and disconnected data in Test & Deploy, including Dimension List Items and Metrics, when to keep data in sync and how deployments work.
- [Manage Data Changes in Dimension Lists](https://kb.pigment.com/docs/dimension-list-data-changes.md): Learn how to manage connected and disconnected Items in Dimension Lists for effective data synchronization across environments.
- [Manage Data Changes in Metrics](https://kb.pigment.com/docs/manage-data-changes-in-metrics.md): Manage your data effectively with connected and disconnected Metrics across Test & Deploy environments for operational and structural data synchronization.
- [Full and Partial Deployment in Test & Deploy](https://kb.pigment.com/docs/full-partial-deployment-test.md): Learn how to perform full or partial deployments from Dev to Prod, ensuring correct permissions and Application integrity in your Workspace.
- [Granular Deployment in Test & Deploy](https://kb.pigment.com/docs/granular-deployment-in-test-and-deploy.md): Learn how to use Granular Deployment in Pigment’s Test & Deploy to deploy specific structural changes between environments while automatically managing dependencies.
- [Understanding Local Deployment](https://kb.pigment.com/docs/understanding-local-deployment.md): Local Deployment enables flexible testing and deployment within a single Workspace, ensuring safer workflows and efficient production fixes.
- [Understand Test & Deploy for Pigment Features](https://kb.pigment.com/docs/understand-test-deploy-pigment-features.md): Explore T&D's feature breakdown in Pigment, covering managed vs. unmanaged Applications, environment changes, and security management for optimal performance.
- [Become a Pigment Pro](https://kb.pigment.com/docs/become-a-pigment-pro.md): The articles in this section are written for modelers within organizations that prepare and maintain Pigment for end-users. They cover topics such as how to make an easy-to-use Workspace, containing logical folder structure with optimized, accessible formulas.
- [Modeling Principles](https://kb.pigment.com/docs/modeling-principles.md): From folder structure to naming conventions, this section introduces key concepts and practices to level up your modeling game. It covers making your Application easy to navigate and your formulas easy to follow, as well as guidance on multi-dimensional, multi-application modeling.
- [Most commonly used folder structure](https://kb.pigment.com/docs/most-commonly-used-folder-structure.md): Learn how to structure application folders effectively, enhancing organization and flexibility in your Revenue Planning and data management processes.
- [Why should you use a Library folder when sharing Metrics?](https://kb.pigment.com/docs/why-should-you-use-a-library-folder-when-sharing-metrics.md): Optimize your Pigment applications with library folders for better data sharing, clarity, and security across teams. Streamline your metrics today!
- [Naming convention for Pigment](https://kb.pigment.com/docs/naming-convention-for-pigment.md)
- [How to make your formulas easier to understand](https://kb.pigment.com/docs/how-to-make-your-formulas-easier-to-understand.md): Enhance your Pigment formulas with line breaks, tabulations, and comments for better readability and efficiency in data transformations.
- [Loading Data: Dimension, Transaction or Metric?](https://kb.pigment.com/docs/loading-data-dimension-transaction-or-metric.md): Learn the best practices for loading data into Pigment. Understand when to use Dimensions, Transactions, or Metrics to ensure accurate, scalable, and efficient modeling in your applications.
- [Multi-Application Architecture: Why and How?](https://kb.pigment.com/docs/multi-app-architecture-why-how.md): Explore Pigment's distributed planning for real-time business modeling, enabling seamless data sharing across apps for effective revenue forecasting and reporting.
- [Multi-Dimensional modeling](https://kb.pigment.com/docs/multi-dimensional-modeling.md): Master multi-dimensional modeling with Pigment. Learn to manipulate metrics, aggregate data, and optimize business processes effortlessly.
- [Design Pigment Boards](https://kb.pigment.com/docs/designing-pigment-boards.md)
- [Increase your end-users' adoption](https://kb.pigment.com/docs/increase-your-end-users-adoption.md): Enhance your application usability with effective design principles, user testing, and feedback to boost Pigment adoption and improve user experience.
- [Chapter 1: Defining your Board's content](https://kb.pigment.com/docs/chapter-1-defining-your-boards-content.md): Learn how to define your Board content effectively, focusing on user objectives and flows to enhance data visibility and decision-making in Pigment.
- [Chapter 2: The four principles of good visual design](https://kb.pigment.com/docs/chapter-2-the-four-principles-of-good-visual-design.md): Learn 4 essential design principles—hierarchy, symmetry, contrast, and consistency—to create visually appealing slide decks, websites, and boards.
- [Chapter 3: How to create simple information hierarchy](https://kb.pigment.com/docs/chapter-3-how-to-create-simple-information-hierarchy.md): Organize your content effectively with clear sections, alignment, and mindful design to enhance user experience and readability.
- [Chapter 4: How to use colors](https://kb.pigment.com/docs/chapter-4-how-to-use-colors.md): Optimize your visual identity with color in user-experience design. Learn to create harmonious palettes and enhance accessibility in Pigment Boards.
- [Chapter 5: How to format Grids, Charts and KPIs](https://kb.pigment.com/docs/chapter-5-how-to-format-grids-charts-and-kpis.md): Learn to create beautiful data visualizations with Pigment by mastering simple design, visual hierarchy, and consistent formatting for grids, charts, and KPIs.
- [Chapter 6: How to use actions and text widgets](https://kb.pigment.com/docs/chapter-6-how-to-use-actions-and-text-widgets.md): Enhance user navigation in your app with effective action and text widgets. Learn to create intuitive interfaces that guide users seamlessly.
- [Board inspiration](https://kb.pigment.com/docs/board-inspiration.md): Discover inspiring Board design examples to help you build beautiful, user-friendly dashboards and deliver outstanding end-user experiences.
- [Cookies Policy - Pigment Knowledge Base](https://kb.pigment.com/docs/cookies-policy.md)
- [Beta Features Policy](https://kb.pigment.com/docs/beta-features-policy.md): Learn about beta features in Pigment, their development stage, expectations, and how your feedback shapes their evolution before general availability.