# Pigment

> Knowledge base documentation for Pigment.

## v1

- [How Pigment’s product documentation supports your work](https://kb.pigment.com/docs/welcome-2.md)
- [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 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.
- [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)
- [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.
- [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.
- [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.
- [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.
- [Create a Metric similar to TODAY() in Excel](https://kb.pigment.com/docs/create-a-metric-akin-to-today-in-excel.md)
- [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): Learn what Tables are in Pigment and what you can do with them.
- [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)
- [Block settings for Transactions 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.
- [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.
- [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.
- [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.
- [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 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.
- [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.
- [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.
- [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.
- [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.
- [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)
- [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.
- [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.
- [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.
- [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.
- [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.
- [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.
- [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.
- [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.
- [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.
- [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.
- [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.
- [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.
- [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!
- [Bar Chart Options](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 Options](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.
- [Waterfall Charts](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.
- [How to set up a 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.
- [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.
- [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.
- [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 to Customize Context 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.
- [Adaptive Display Controls in Page Selectors](https://kb.pigment.com/docs/adaptive-display-controls-page-selectors.md): Explore adaptive display controls for dropdowns in Metrics, Boards, and Widgets, enhancing user experience with dynamic and dependent selections.
- [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.
- [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 Pigment Snapshot limits to free up space, stay within your plan, and optimize Workspace storage for better performance and efficiency.
- [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 \[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.
- [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.
- [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.
- [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.
- [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.
- [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.
- [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.
- [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.
- [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.
- [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.
- [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.
- [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.
- [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.
- [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.
- [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.
- [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
- [Loading Data from Pigment into Google Sheets (Gsheet)](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.
- [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.
- [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.
- [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.
- [Run the Modeler Agent](https://kb.pigment.com/docs/configure-and-run-the-modeler-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)
- [Run the Documentation Agent](https://kb.pigment.com/docs/configure-and-run-the-documentation-agent.md)
- [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.
- [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.
- [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)
- [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.
- [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 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.
- [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.
- [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.
- [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)