Skip to main content

Questions & Conversations

Got a question about your models? Want to start a discussion? It's here!

  • 841 Topics
  • 2,266 Replies
841 Topics
Ola
Seasoned Pigmenteer
OlaSeasoned Pigmenteer
asked in Questions & Conversations
Link to a prefiltered board

When you apply a filter to a board you can see that the url is updated to include the current filter. The problem is just that the url only includes a GUID. Is there any way to find these guids in Pigment? For example when filtering on a specific employee in my employee dimension I can see that []=df7ce50d-304b-472e-a8e0-f448d960e8de is added to the url, and I would expect that each employee is related to a unique guid, so question is just how to get from dimension value to a guid. My use case is that I am having a grid view with a list of employees. For each employee I would like to link to another board with details about each employee and I would like this board to automatically be prefiltered based on which row I clicked on the first board. 

1585
Andrea
Community Manager
V
Budding Pigmenteer
venitiavBudding Pigmenteer
asked in Questions & Conversations
Intern to permanent contract - formula for end date

Hi,Do you have a best practice to recommend on how to manage interns who are converted to permanent contracts (=CDI in France) in Pigment?Let’s take an example :In my transaction list, I have Employee1 which is intern with an end date on Dec, 31st 2024. He comes back as a permanent contract starting January 1st 2025 (with no end date). In my FTE calculation metric, the term date metric is calculated with :if(isnotblank('Employee Transactions'.'Term Date'[by last:'Employee Transactions'.'[Pigment] Name','Employee Transactions'.'Load Month']),'Employee Transactions'.'Term Date' [by last:'Employee Transactions'.'[Pigment] Name','Employee Transactions'.'Load Month'],previous(Month))The last load concerning employee1 does not have a load date, as he is a permanent contract. However, as I have  “previous month” in my formula, it takes into account an end date. So my Employee1 is counted as 0 on January. Would you have some formulas to advise for this case ? ThanksVenitia

991
Stef
Employee
G
Newly Minted Pigmenteer
Gali BaramNewly Minted Pigmenteer
asked in Questions & Conversations
Dates exported incorrectly through gsheet connector

I’m running into an issue with the dates getting mixed-up when I load data from Pigment to google sheets (see the formula bar in the screenshot, the date ). The issue is that the title which is a text field appears as the header, and gets translated to a date incorrectly. I tried switching the header in Pigment, but the start/end date fields aren’t listed as options. Did anyone else encounter this? Any suggested solutions? 

691
D
Newly Minted Pigmenteer
Spandan98
Seasoned Pigmenteer
Spandan98Seasoned Pigmenteer
asked in Questions & Conversations
Concatenate Dimension Type Metrics - Convert Dimension type metrics to text type

Hello Pigment Community,I need help converting dimension-type metrics into text and concatenating them into another metric.For example, in the screenshot I provided, I want the "Concat" metric for Row A to display "Asste1Con1".How can I achieve this? Any guidance would be greatly appreciated.Thanks in advance!  

1832
Min Li Bright Point
F
FPA
asked in Questions & Conversations
syncing context pages across multiple tabs

Hi, we have users that work on multiple boards at the same time that share common pages selectors.The challenge here is that when we switch from one dimension element to another on the page selector in one tab, we need to go through each other tab to adjust the page to the newly selected element. As people here work with like 10 tabs in parallel, that s a lot of clicks to update boards and have them being synced.Do you people encounter those kind of usage / challenge ?Are there ways to make this work in pigment and how if you experimented it ?I was thinking maybe using a custom user defined variable ?

331
W
Employee
M
Newly Minted Pigmenteer
mmcgrathNewly Minted Pigmenteer
asked in Questions & Conversations
Remove a dimension from a chart while maintaining the calculated item from that dimension

Hello, I have created a calculated item cumulating totals by week for a month. I would like to show the cumulative total of each week on a chart, without showing that week’s individual total. In the example below, I would like to remove the lighter blue “Jan 25” value, and keep the calculated item - the cumulative total by week. Is there a way I can do this?  Thank you!   

852
M
Newly Minted Pigmenteer
G
Newly Minted Pigmenteer
geoff_chovazNewly Minted Pigmenteer
asked in Questions & Conversations
Unshare block

Is there a way to unshare a block if it hasn’t been used yet? I accidentally shared a block I didn’t want to, and in the block settings->library the share toggle is greyed out. It says it’s being used somewhere else, but also says “Not Used” beside it. 

693
Min Li Bright Point
Misbah
Seasoned Pigmenteer
MisbahSeasoned Pigmenteer
asked in Questions & Conversations
Dynamic Variable not Updated Page Selectors

Is there a bug in Dynamic variable?I have a metric with Year format and This year populates the actual months. When I apply this variable it doesn’t update variable in page selectors instantaneously. Instead I have to wait for a minute or two to see it get applied Or we need to refresh the browser url or application in order for it to make work. Is this the intended behaviour or Am I missing anything?Appreciate your responses!  Thanks,Misbah  

2564
Hugo Delaby
Community Manager
Thu Mai
Thu MaiKeen Learner
asked in Questions & Conversations
Ability to add multiple metrics with same dimensions at the same time

Hi Pigmenteers 🤗I have an input table with 10 input metrics (same dimensions, serve the same purpose). I know how to create them 1 by 1 directly from the table (more convenient), but I’m curious whether there is a way in Pigment we can create them all at the same time? 🤔

2233
Sharon Conroy
Budding Pigmenteer
M
Budding Pigmenteer
MohanBudding 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

3214
Sharon Conroy
Budding Pigmenteer
C
Just Arrived
Charlotte BJust Arrived
asked in Questions & Conversations
New application

I can find the blue buttom “New application”

841
Min Li Bright Point
I
Just Arrived
Idris BUIJust Arrived
asked in Questions & Conversations
Pre-fill item creation form with filters

Hello everyone, when creating a new item in a P&L, is it possible to pre-fill the item creation form with the filters applied on the page ? (for instance Entity / Current budget phase)

411
oliverlee
Seasoned Pigmenteer
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?

3125
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

1722
Sharon Conroy
Budding Pigmenteer
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. 

19211
Sharon Conroy
Budding Pigmenteer
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?  

2013
Sharon Conroy
Budding Pigmenteer
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!  

482
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!

836
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!

2905
Sharon Conroy
Budding Pigmenteer
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 

2262
Sharon Conroy
Budding Pigmenteer
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?

2414
Sharon Conroy
Budding Pigmenteer
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?

2206
Sharon Conroy
Budding Pigmenteer
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! 😊

1132
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
Budding Pigmenteer
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 !

592
M
Newly Minted Pigmenteer

Badge winners

  • Read and Interpret Formulas Certified
    OAbozkhas earned the badge Read and Interpret Formulas Certified
  • Innovator
    Lauri Sulonenhas earned the badge Innovator
  • Pigment Modeling Fundamentals Certified
    nicktroiahas earned the badge Pigment Modeling Fundamentals Certified
  • Read and Interpret Formulas Certified
    estellezhanghas earned the badge Read and Interpret Formulas Certified
  • Pigment Like a Pro
    mweinzimhas earned the badge Pigment Like a Pro
Show all badges
Terms & ConditionsCookie settings