Explore the Community

Connect with other users, discuss how you're using Pigment, and get inspired

659 Topics

Jared DolichSeasoned Pigmenteer

Best Practice Question: List Property or Metric?

When mapping to address mismatched dimensions between source and target is there a best practice to use a list property or metric? Seems to me the list property is the better choice since it’s the obvious place to look which prevents creating duplicates, which of course, can easily become out of sync. If list property is the way to go are there any downsides? Thoughts?

40 minutes ago

RebeEmployee

posted in Community Welcome Guide

Pigment Community Guidelines

Welcome to the Pigment Community! We are so happy to have you here! We are here to create a space where Pigment users can share knowledge, learn, collaborate and connect with one another. These Community Guidelines should not only help you understand how to act within the community but also help you understand what to expect from others in this space.Your participation here is subject to these Guidelines. Be RespectfulWe are ALL Pigmenters! All of us come from diverse backgrounds and we welcome that here in this forum, with that being said please be committed to treating your fellow Pigmenters with the utmost kindness and respect. This is a welcoming community of users (most importantly human beings) and we must make it a priority to keep this forum a safe space where everyone feels comfortable. No name-calling, offensive behavior, or bullying is allowed EVER. Engage with the Community Our moderators will post helpful content but we really want to learn and hear from you! Take a look

1 hour ago

Weining BenSeasoned Pigmenteer

asked in Questions & Conversations

User-dependant dropdown list on Table

Hi,We have a table, as below, used for assigning departments to employees. Additionally, we have an ARM_department metric for managing users’ department access right.I want users to see only the departments to which they have access in the dropdown list (rather than all departments) to avoid mistakes. I know that something can be set for Department dimension, but this would affect the entire workspace, right? Is there a way to restrict it only in this table?Thanks for any advice,Weining

2 hours ago

MukulBudding Pigmenteer

asked in Questions & Conversations

How to dynamically setup historical period based on current date?

I have created a metric. Based on current date it will fetch the current month. I have another metric for defining Historical period. I am trying to drive this by above grid. However I am getting an error while applying the formula. What is that I am missing or doing wrong. Please suggest the right logic

5 hours ago

Dastan S.Just Arrived

asked in Questions & Conversations

Finding the specific text inside a text, but in a reverse order

I am trying to create a logic to extract part of a text. For example, here:“41111 Revenue : Subscription : Platform”I want to transform the above text as: “41111 - Platform”. The issue is, when I use FIND function to find “:” symbol, it only returns the position if the first occurrence. But, I want to return the position of the first occurrence from the end. I could use nested IFs to find the first occurrence, slice the text, and find first occurrence from the sliced text. However, some accounts have 3 and more “:” symbols:51111 Cost of Revenue : Subscription : Allocation In - Subscription : Allocation In - Sales & MarketingIs there a way to locate the last occurrence of the text, instead of the first?

6 hours ago

CindyJust Arrived

asked in Questions & Conversations

Search Update History by block and GL?

The update history is a fantastic feature. Recently my team had asked me to find who changed something and it was very cumbersome having to comb through the block when I’m looking for changes that ultimately impacted just one GL account. Is there anything on the pipeline that would allow us to search by block by also by GL?

12 hours ago

Isabella Leslie-MillerCommunity Manager

published in Community Welcome Guide

Pigment Community Rank System🎖️

On this page we outline how you can obtain specific ranks 🥇Our ranks are designed to award different kinds of contributing to the Community. We want to ensure our members receive recognition for their activity and have something to show for their efforts.Ranks are awarded automatically, with the most prestigious rank you qualify for, being your rank. Name Criteria Just Arrived 1 Log-in Newly Minted Pigmenteer 1 Reply / 1 Post Budding Pigmenteer 5 Replies, 1 Like Received, 1 Post Seasoned Pigmenteer 10 Replies, 5 Likes Received, 3 Posts Advanced Pigmenteer 50 Replies, 20 Likes Received, 10 Posts Expert Pigmenteer 100 Replies, 50 Likes Received, 25 Posts Occasional Observer 25 Log-ins, 5 Likes Given Frequent Reader 50 Log-ins, 10 Likes Given Keen Learner 100 Log-ins, 25 Likes Given Pigment Academic 250 Log-ins, 100 Likes Given Pigment Professor 500 Log-ins, 250 Likes Given Genius 100 Replies, 15 Answers, 20 Posts Mastermind 200 Replies, 30

1571

23 hours ago

gozseker1Just Arrived

asked in Questions & Conversations

Conditional Number Formatting

Looking to toggle between whole $ numbers and %’s for budget driver values - I would like to be able to set up any value between 0 and 1 to show up as e.g. 5% vs 0.05, but the same metric also has $20,0000 type direct annual input amounts. Is this possible?

2 days ago

KevinSeasoned Pigmenteer

asked in Questions & Conversations

Assigning Dimension to Metric Calculation

I have various forecasts and weights that are derived in different models and need to piece together a daily forecast. Long story short, what I have below is the daily forecast but is set up by the date the week starts and the day of the week. I need to “convert” that all into one metric with just the day dimension.I have created another metric that has the same dimensions but the result is itself the day dimension.And so what I want to do is somehow assign the values in the first metric to the day dimension in the second metric. The block is fully aligned but I am not sure how to code this properly. I’ve played around with the BY modifier but I just can’t seem to get this working.I10[BY CONSTANT: I11]Any sort of modifiers I throw on just give me one row for the day of the week. Any tips you have would be greatly appreciated.Thank you

3 days ago

matt.tafesseJust Arrived

asked in Questions & Conversations

Add 'previous' function to equation

Hello - I’m looking to add a previous function to the below equation“if('Is Forecast?',('Go Forward Cohort'[select:'Go Forward LTV Driver'."Borrower Retention"][BY:->'Map to Cohort Month']),(('2.002 Cohort View - Borrower Retention Lookup')))”I believe this formula works similar to excel where the data is either coming from the ‘Go Forward Cohort Metric’ or the ‘Cohort View Metric’ depending on the ‘Is Forecast’ boolean. I want the previous function to pull the last row of data thats a result of the if statement. Thanks in advance

5 days ago

NipsaJust Arrived

asked in Questions & Conversations

Version Locking

Hi Team,We have a requirement of locking our Versions for any more inputs. Do we have Version Locking capability or Cellular Level Access restriction capability in Pigment?Any leads will be appreciated.Thanks,Nipsa

6 days ago

abhilashsawlaPigment Academic

asked in Questions & Conversations

How create current date matric, which fetch current date automatically?

I want same feature like Today() in Excel.

7 days ago

OlaBudding Pigmenteer

asked in Questions & Conversations

Issues with time aggregations

I have a board with year as a filter on top of the board and it is possible to select multiple years in this filter. On my board I also have a KPI that should show outgoing HC for the last month based on the selected years. When I look at my data with Years on the rows it looks like the picture below when I use “Last” as time aggregator.However when I remove years from the rows all values are blank. If I change the time aggregator to “Last Non Blank” it shows me values, but the problem is that “Last Non Blank” doesn’t always give me the values for dec in the last year, it returns the cells shown in the second picture below. It feels like a bug that the cells are blank when using “Last” as aggregator in this case or am I doing something wrong?

7 days ago

ChediNewly Minted Pigmenteer

asked in Questions & Conversations

Text function to remove multiple parents from a level 0 sub-account in GL metadata

Hi. I’m new to Pigment so hoping someone has solved this problem before.Has anyone been able to parse out the rightmost X number of characters that appear after any number of colons in a dimension member? e.g. [60001 Personnel Costs : XYZ : ABC: Salaries and Wages] should return [60001 - Salaries and Wages], where XYZ and ABC are illustrative of potential sub-accounts that need to be removed.

10 days ago

MukulBudding Pigmenteer

posted in Questions & Conversations

Bills of Materials Management in Supply Chain Use Case.

Hi , I am looking to figure out a solution for BOM Management in Pigment. Background:I have 2 columns in source data, one for parent and one for children.I want to create a hierachy using these 2 columns. The catch here is, parent can be a children or children can be a parent. Let me know if anyone is interested to work on this challenge with me.

11 days ago

KevinSeasoned Pigmenteer

asked in Questions & Conversations

Reader Role - Can't View Boards

I have created a group and have added members with access to a handful of applications. For the time being, I have assigned them the reader role. However, I can not get them to see the boards. The screenshot below is from me impersonating one of the users. I’m stuck on what to do next. Do I need to go through and change permissions to each of the boards? Or even each of the blocks? Is there a quick way to have them see the boards? Do I need to edit the reader role and change permissions there? I have read through several articles and I can’t match the instructions to my workspace. Any help or insights would be much appreciated.Kevin

12 days ago

connorsmithBudding Pigmenteer

posted in Questions & Conversations

SELECT Modifier with Dynamic Offset

Hello! The SELECT modifier can be used to Offset a dimension (ex. SELECT: Month - 1), but is it possible to assign different Offset amounts based on one of a dimension of the Metric? Here is the example I am stuck at now: I am trying to assign specific Offset amounts to a metric (0. UFR - Live) based on the Customer Payment Term dimension (ex. For any data in the Net 30 → 1 month offset, Net 60 → 2 month offset, etc) Ideally I could assign an Offset Integer as a Property of the Customer Payment Term dimension and that would determine the Offset (ex. [SELECT: Month - ‘Customer Payment Term’.’Offset Integer’]Is there a better and more sustainable approach rather than a massive nested IF statement? Thank you!

13 days ago

MohanNewly Minted Pigmenteer

asked in Questions & Conversations

Extract Day from a date in text format

Hello,I have a Date field called “Delivery Date” (Ex : 10/06/2024). From here, I want to extract the day of the week in text format (Example :10/06/2024 is “Monday”) and my calculated field should show similar to the example here. I tried WEEKDAY(‘Delivery Date’) and it returns day of the week but in number format and I tried again TEXT(WEEKDAY(‘Delivery date”), again it does not work. How to convert weekday into Text format like Mon,Tue,etc…? thanksMohan

13 days ago

OlaBudding Pigmenteer

asked in Questions & Conversations

FORECAST_ETS vs SEASONAL_LINEAR_REGRESSION

Could anyone provide some guidance on when to use the function SEASONAL_LINEAR_REGRESSION over FORECAST_ETS? In our specific case we have a metric with a yearly seasonality and the overall trend for the metric is going slightly downwards. We would like to use our actuals data to automatically calculate values for all forecast months. I can see that both functions gives me reasonable values for my forecast, but FORECAST_ETS gives me a clearer trend downwards while SEASONAL_LINEAR_REGRESSION gives me more flat forecast. So my question is really, which one would make most sense to use in our case and why?

14 days ago

kristian.bartelNewly Minted Pigmenteer

posted in Questions & Conversations

Creating an Application Guide, Board/Block Structures

Hi all,Curious to see how people have approached (1) creating an application guide for new users (specifically something to quick start leaders that don’t necessarily have the time to go through more in-depth tutorials), and (2) board/block structure. I know there’s some documentation on board/block structure, but just curious to get some more context on how people approach it, particularly for revenue focused planning. Thanks!

16 days ago

YounesZNewly Minted Pigmenteer

asked in Questions & Conversations

Linear programming

Hello everyone,Is there a feature in Pigment similar to the Solver in Excel that involves solving equations based on many inputs and conditions to maximize or minimize an objective?Regards,

18 days ago

connorsmithBudding Pigmenteer

posted in Questions & Conversations

Table with Metrics the Use Different Scenarios

Hello! I am seeking to make 1 Table that has 2 metrics (image below). The metrics are “P&L” and “Commentary”.For the P&L metric I am seeking to show two different scenarios (“Actuals” and “Q2 Outlook”)For the Commentary metric I am seeking to show ONLY 1 scenario. Is there any way to achieve this? It seems like the Scenario page selectors apply to ALL metrics in a table.Curious if others have found get arounds for this?

18 days ago

RasagyaNewly Minted Pigmenteer

asked in Questions & Conversations

Scenario Order misplaced in Google Sheets export

Hi all - we are running into an issue with our Google Sheets connector where the order in which scenarios are selected in the saved view does not seem to get passed on to g-sheets. Explaining this in more detail below: We have added a screenshot below showing our list of scenarios. We want “Apr 24 Close / May 24 Reforecast” to be the first scenario and “FY24 Company Plan (Approved Changes)” to be the second scenario -- this is because we want Apr close to be on the left and FY24 company plan to be on the right hand side of our table. When we export this view using the Google Sheets connector, we are required to select the 2 scenarios again and their order seems to be reversed once we pull the data (see second screenshot below). Any thoughts on whether we’re doing something wrong or if there are any workarounds available for this?

18 days ago

matt.tafesseJust Arrived

asked in Questions & Conversations

IF statement determined by boolean

Hello - I am trying to update a formula based on a boolean that is determined by the latest date in a data upload. I believe the following equation is close to what I need.Formula: “if('Is Forecast?','Go Forward Cohort'[select:'Go Forward LTV Driver'."Borrower Retention"][BY:->'Map to Cohort Month'] , if('Is Actual?',('2.002 Cohort View - Borrower Retention Lookup')[remove lastnonblank: Month][remove lastnonblank: Cohort][ADD: Cohort]))”There are two issues:1. I want to add a previous function to the first part of the if statement. If there is no data to pull from the “go forward cohort metric” I want the function to pull the last data point there is2. When updating to the above formula my application will time out. Is there a more efficient formula that will prevent this? Thank you!

19 days ago

JV-55Newly Minted Pigmenteer

asked in Questions & Conversations

Combined Views

Hi, Is it possible to create 3 distinct views on 3 distinct metrics, and combine the metrics into 1 table that incorporates the 3 distinct views? Alternatively, say I have a table constructed from multiple rows that are each a metric. It would contain 3 sections (Revenue, COGS, and OPEX). Is there a way to have unique row pivot selections for each of the 3 sections and not having the row pivot selections impact all rows instead? Or will this require 3 unique tables, separating the 3 sections?

20 days ago

Page 1 / 27

Explore the Community

Badge winners

Sign up

Single Sign-On Need help?

Log into the Pigment Community

Single Sign-On Need help?

Scanning file for viruses.

This file cannot be downloaded