Skip to main content

Explore the Community

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

926 Topics
Thu Mai
Thu MaiKeen Learner
asked in Questions & Conversations
Sparse Engine concept

Hi Pigmenteers!While I’m taking Pigment trainings and explore my personal application, I figure out that there is no information about the size of my application or total number of cells, etc.. and the reason behind is that Pigment is a sparse engine.Therefore, can you help explain to me more about the concept of sparse engine - what is a sparse engine, how does it actually work and what is the benefit compared to non-sparse engine?

3015
Thu Mai
A
Newly Minted Pigmenteer
AdelgoNewly Minted Pigmenteer
asked in Questions & Conversations
Widget Text Format

Hello,Is it possible to change the format of a text Widget ? → Background color→ Text Size→ Text Color→ Center the text in the boxIf not, when do you plan to develop this feature ? ThanksAdèle

1612
Sharon Conroy
Community Manager
abhilashsawla
abhilashsawlaPigment Academic
asked in Questions & Conversations
How to turn off Share Toggle in Scenarios

Hi, Please let us know how to turn of Shared Scenarios. 

19011
Sharon Conroy
Community Manager
Trever Leavenworth
Seasoned Pigmenteer
Trever LeavenworthSeasoned Pigmenteer
asked in Questions & Conversations
Modifiers not applying as expected

Hello! I’m attempting to aggregate my metrics into a full P&L with actual and forecast views. I have data coming from a Shared_IS_Actuals dimension, several Revenue and COGS dimensions already mapped, a Shared_WF_Plan dimension, and a Shared_Opex_Plan dimension. I’ve been able thus far to successfully have Actuals for all IS accounts pull in, and have Revenue, COGS, and WF (payroll, benefits, taxes) appear in a single metric. However, when I try to add my Shared_Opex_Plan data using the formula below, my Actuals stay, my revenue and cogs disappear, my WF_Plan stays, and my Opex_Plan disappears, leaving me with only the WF_Plan.  It’s like the first by modifier to map the WF_Plan to the CoA is applying to everything? What am I missing?  

1963
Sharon Conroy
Community Manager
Y
Newly Minted Pigmenteer
YaejisNewly Minted Pigmenteer
asked in Questions & Conversations
Average If

Hi! Can you please help me to find average amount if the end of week month is same? Thank you!  

412
Y
Newly Minted Pigmenteer
Y
Newly Minted Pigmenteer
YaejisNewly Minted Pigmenteer
asked in Questions & Conversations
Week # of the Year

Hi!  I am trying to setup my report table to show Week # of the Year. I assume Week # needs to be created in the Week Dimension. Could you help me with the formula? I would like Monday-based weeks.  ​​​​ My final goal is to add Week # before Week property in the table.   ExampleThank you!

816
Y
Newly Minted Pigmenteer
E
Seasoned Pigmenteer
ElodieSeasoned Pigmenteer
asked in Questions & Conversations
Conditional formatting based on previous month

Hi everyone!I am trying to add a conditional formatting in my headcount metric in order to highlight when the number of employees increases or decreases from month to month. I cannot find any option in the conditional formatting that allows me to do so... Could you please help me finding the best solution if anyone has already faced this issue? 🤗Thanks!

2415
Sharon Conroy
Community Manager
Lehtohen
Budding Pigmenteer
LehtohenBudding Pigmenteer
asked in Questions & Conversations
YTD Calculations Wrong when Showing Values as %

Hello Community, I am struggling with YTD summaries for %-values. In image 1 I have lines for Revenue and Costs and then I have added metric “Costs” for a second time and I am showing the value as % of Revenue. Image 1When I add YTD calculations (Image 2), I have an issue that also the “% of Revenue (Costs)” seems to be cumulating when in fact it should be always calculated as Costs/Revenue. This means that for February YTD (ACT) shows -2.20 % (= -1.30 % + -0.90 %) instead of the calculated values, which should be -1.11 % (= -4 664 / 419 306). Image 2Is it possible to keep the YTD calculations for other metrics, but use a “formula”-calculation for the %-metrics? In case it is any help, here is also a image of how I have pivoted the data. Image 3 

2242
Sharon Conroy
Community Manager
agnar
Seasoned Pigmenteer
agnarSeasoned Pigmenteer
asked in Questions & Conversations
Change formatting of all rows in tables

In a table, the row headings (the pivoted fields that you can view either in Tabular or Tree layout) are by default formatted with dark grey font on a light grey background. But if I want it to make it *pop* I can’t think of other way than to go row-by-row and go through the menu:Is there a better way?

2354
Sharon Conroy
Community Manager
I
Newly Minted Pigmenteer
Ivan SenkinNewly Minted Pigmenteer
asked in Questions & Conversations
Filter timescale by day and month in one grid

Hi community! I need to filter grid in board by days and month. I have a boolean metric “Show days?” and when it is TRUE I want to see in grid only days, when its FALSE I want to see only months. How can I do it?

2126
Sharon Conroy
Community Manager
Spandan98
Seasoned Pigmenteer
Spandan98Seasoned Pigmenteer
asked in Questions & Conversations
Dynamic selection of time period and aggregating data based on that.

Hello Pigment Community,I want to dynamically aggregate my data based on the selected time period—whether by month, quarter, or year—using a Boolean metric.Expected Behavior:If Month is selected (TRUE), the data should display only monthly values. If Quarter is selected (TRUE), the data should aggregate and display only quarterly totals. If Year is selected (TRUE), the data should aggregate at only the yearly level.How can I achieve this functionality efficiently? Any guidance would be appreciated!Thanks in advance! 😊

942
oliverlee
Seasoned Pigmenteer
A
Newly Minted Pigmenteer
AdelgoNewly Minted Pigmenteer
asked in Questions & Conversations
Block Scenarios for a business contributor

Hello,I know it is possible to block a scenario, but when it is blocked, this apply for all users.Is it possible to block a scenario for a contributor, but not for an admin ? If not, when do you plan to develop this feature ?ThanksAdèle

3342
Sharon Conroy
Community Manager
M
Newly Minted Pigmenteer
msoussNewly Minted Pigmenteer
asked in Questions & Conversations
Select Total Aggregator

Hello, I have a metric “MD02 - Quel macro composant ?” which displays elements from the list “macro composant” and its total. The dimensions are “Composants” and “macro composants”.  I also have a second metric where I want to display the total with the only dimension “Composants” :  Do you know which formula I must use in this second metric please ?Thank you very much !

492
M
Newly Minted Pigmenteer
V
Budding Pigmenteer
venitiavBudding Pigmenteer
asked in Questions & Conversations
KPI with no value = 0

Hello,I have a KPI on the headcount planning board for budget owners showing the number of open positions. When there is no open positions, i would like the metric to show 0 instead of “nothing to display”. I tried putting a ifblank is my formula but i have an error message saying it is taking too long to calculate. Is there any way to show 0 ? ThanksVenitia

293
V
Budding Pigmenteer
Isabella Leslie-Miller
Community Manager
Isabella Leslie-MillerCommunity Manager
published in Company News
🚨 Important Update: Pigment Email Domain Change 🚨News

Hi EveryoneHeads up: starting February 8, 2025, all Pigment email addresses will transition from @gopigment.com to @pigment.com.Please take a moment to update your records to ensure smooth communication moving forward.If you have any questions, feel free to reach out. Thanks for your attention to this change! 

220
Isabella Leslie-Miller
Community Manager
MARCO_BMG
Budding Pigmenteer
MARCO_BMGBudding Pigmenteer
asked in Questions & Conversations
Auto calculated switchover dates

Hi Pigment Community,we have a use case in a project where we need to combine 2 special cases in the area of Switchover dates. We have multiple switchover dates for multiple data sources, as some supplier report only monthly and some other quarterly. So we need our Forecast calculation to start at different months for different data. We want to auto calculate the switchover date, by the last available data in the Actuals data set. I haven’t found a solution on how to automatically calculate the last Actuals month. For 1. I just created a multiple dimension metric with switchover dates for all data layers, which works fine for manually setting the month for the switchover dates.I then created second metric to calculate the last month with Actual data and this formula gives me the output for the last available month:'ACT_REV_Euro (in k)' [REMOVE LASTNONBLANK: Month] However, I was not able to transform or extract the Month value from the metric. Any formula like “MONTH()” or “TIMEDIM()”

633
Min Li Bright Point
M
Newly Minted Pigmenteer
MaxenceGoigNewly Minted Pigmenteer
asked in Questions & Conversations
Impact of Data Import Modifications on Pigment

Hi,I have a transaction list where data is imported daily from NetSuite into Pigment.Some modifications will be made to the NetSuite search where the data comes from, including the addition of new columns.I’m am not sure how this change will impact the import process in Pigment?Additionally, when I go to Import Data → Set Up Import, the data mapping does not open—it just keeps loading indefinitely. Does it mean I will have to recreate an import from scratch?Thanks in advance for your guidance!Best regards,

571
M
Newly Minted Pigmenteer
T
Newly Minted Pigmenteer
Ta-WingNewly Minted Pigmenteer
asked in Questions & Conversations
Pigment AI

Tried enabling pigment AI but when I ask a simple question like “What’s the revenue in 2024?”, it is giving me a total Revenue that isn’t filtered, i.e. before drilling into FX25 or 24, Live & Stage version combined, 0+12 to 12+0 versions combined? 

1521
Min Li Bright Point
F
FPA
asked in Questions & Conversations
does test and deploy allow disconnected scenarios ?

Hi,I d like to know whether the scenarios under deployed applications (test n deploy) can be set to "disconnected" (except the default scenario(s)) ?The need here is to have basic scenarios with predefined rules to calculate baseline projections while alowing users to add scenarios with ad hoc simulations formulas.  

381
Julien
Community Manager
N
Budding Pigmenteer
NachoBudding Pigmenteer
asked in Questions & Conversations
Comparison of different scenarios

We’ve created two scenarios for the BP on 24: Target and BudgetThese two scenarios are items belonging to the dimension “Version”.In the attached table, we want to add two new comparative columns, one being "Target bp 24/FY23" and the other "Budget bp 24/FY23". However, it does not allow us to add this calculated item because we cannot compare different dimensions (version and year).How can we do this comparison? it is crucial to be able to compare as many scenarios as we want with the previous year's figures  

9509
K
Budding Pigmenteer
J
Newly Minted Pigmenteer
Juned.husainNewly Minted Pigmenteer
asked in Questions & Conversations
How to do Unique Count?

Hello Everyone. I am a beginner in Pigment and I am trying to replicate my excel model within pigment. My current excel model will take a unique count of my order number (order number replicates due to multiple sku in one order) and mark the order as 1 and the duplicate as 0. Example: (if A2=A1,0,1). This gives me the unique number of  orders in my transaction list. I cannot reference a cell directly using the if formula in pigment as compared to excel. Is there a an easier way to do this in pigment?  

1636
Nathan
Employee
J
Newly Minted Pigmenteer
Juned.husainNewly Minted Pigmenteer
asked in Questions & Conversations
Missing data after upload

Hello All,I accidently changed the data type for the column ‘order number’ from Text to number which resulted in the data being deleted. I changed the data type back from Number to text and tried reimporting the data back but it still does not shows the original data. Any help is appreciated  

351
oliverlee
Seasoned Pigmenteer
V
Budding Pigmenteer
venitiavBudding Pigmenteer
asked in Questions & Conversations
Add a metric in a dimension list from another source

Hello,I created a new metric named "EmpData-Allocation" (with dimensions "employee" and "month") filtering only the existing employees, that I fill each month manually with a dimension named "allocation". How can I add this metric by employee to the dimension list "employee" ?  example :My employee transaction list is an import from Workday. In this transaction list, I have a new employee named “Employee1”.In my dimension list “Employee”, I have all the info for Employee1 coming from this employee transaction list. In the metric "EmpData-Allocation", I put Allocation1 for Employee1. I would like to have this Allocation1 next to Employee1 in the Employee dimension list. Can you please advise ?  Thanks

642
V
Budding Pigmenteer
Spandan98
Seasoned Pigmenteer
Spandan98Seasoned Pigmenteer
asked in Questions & Conversations
Restricting Input Based on Conditional Formatting in Pigment Metrics

Hello Pigment Community,I hope you're all doing well!I’ve created a table with the following metrics:Month Amount Blended Interest(Please refer to the attached screenshot for reference.)Currently, I have a checker metric set up for conditional formatting, which highlights a month in red if it is greater than the closing period.Here’s what I’m trying to achieve:If a month entered is greater than the closing period, I want the Amount and Blended Interest metrics to become non-editable so users cannot input data in these fields. If a month entered is less than or equal to the closing period, users should be able to input data as usual in these metrics.Could anyone guide me on how to set this up in Pigment? Your assistance would be greatly appreciated!Thanks in advance!    4o

481
W
Employee
B
Newly Minted Pigmenteer
Bryan BauerNewly Minted Pigmenteer
asked in Questions & Conversations
Changing Data Types of a Metics and Removing the Current Value

I have a metric that includes three dimensions—DimA, DimB, and DimC—along with a corresponding dollar amount for each intersection. I’d like to create a new metric where DimA and DimB remain as dimensions, but DimC becomes the result instead of a dimension for each of the intersections in the first metric. In doing this, I also want to drop the numeric data type and just have it as a dimension data type What would be the best way to achieve this in Pigment?

753
B
Newly Minted Pigmenteer

Badge winners

  • Pigment Like a Pro
    JeffHhas earned the badge Pigment Like a Pro
  • Pigment Modeling Fundamentals Certified
    JeffHhas earned the badge Pigment Modeling Fundamentals Certified
  • Innovator
    Noemihas earned the badge Innovator
  • Read and Interpret Formulas Certified
    Alejandrohas earned the badge Read and Interpret Formulas Certified
  • Bug Hunter
    Malt DEhas earned the badge Bug Hunter
Show all badges
Terms & ConditionsCookie settings