Skip to main content

Questions & Conversations

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

  • 784 Topics
  • 2,132 Replies
784 Topics
A
Just Arrived
AshishpJust Arrived
asked in Questions & Conversations
How Can I create a subset of Dimension list ?

For further calculation, I am trying to exclude a few members from the dimensions list items. Could anyone help me find the best approach to do that?

2954
O
Employee
G
Newly Minted Pigmenteer
geoff_chovazNewly Minted Pigmenteer
asked in Questions & Conversations
Issue with (unwanted) date conversion in CSV import

I have a CSV file with a column indicating  the month dimension. It is “Jan 25”, “Feb 25”, etc. On the initial import screen it looks correct,however, as soon as I map it to the Pigment property (Month dimension type) it shows in the preview as My imported data is all loaded into the wrong months. I want it to just take the exact value in my CSV as the name for the Month dimension instead of converting a date. I tried double-quoting the field in the CSV, that didn’t help. Loading it into a regular text property works fine so it doesn’t appear to be an issue with the source data itself.  

81
Min Li Bright Point
A
Seasoned Pigmenteer
A_GarneriSeasoned Pigmenteer
asked in Questions & Conversations
What is the maximum number of cells that a table can display?

Hello Pigment Team,I’ve been testing various tables with large amounts of data to determine the maximum number of cells allowed. In my experiments, I’ve created tables with 1,000 metrics, 500 metrics, and 200 metrics, each dimensioned by weeks (208) and lists (5,000 records). Initially, I aimed to create a table with 5,000 metrics dimensioned by 208 weeks and a list of 1,048,576 records, but this did not work as expected.I’ve noted that applying “Dynamic Filters” doesn’t resolve the issue. Even when my dynamic filter shows only one selection, no data appears and I receive the error message: “Unable to load content for the current view. If the error persists, please contact technical support.”Is it more challenging to handle a larger number of metrics compared to a larger number of records in a dimension list? Do dynamic filters account for the “hidden” data they contain? What are the capabilities of Pigment in this context?Thank you for your assistance.

3552
Matt D
Employee
F
Newly Minted Pigmenteer
FranckLPNewly Minted Pigmenteer
asked in Questions & Conversations
Launch multiple imports at once

Hello,I’ve created a Pigment app connected to a NetSuite environment. All my master data and figures are coming from this system. As of today, I need to update the dimension and transaction lists one by one by launching the related import task.Is there as way to create like a master import that launch everything at once to ease the maintenance of the app ?Thank you

192
F
Newly Minted Pigmenteer
S
Newly Minted Pigmenteer
SHeckhuisNewly Minted Pigmenteer
asked in Questions & Conversations
ITEM() does not find data from Dimension

I am looking to normalise some Country data from different sources in different formats (e.g. some countries have full name others ISO codes). I have been using the ITEM() function to map all correct countries to our Master Country dimension.I was now planning on doing something similar by pulling in the ISO code dimension which is also linked to the Country dimension. However, the ITEM() function does not seem to return any values which confuses me. Ultimately, I am planning to then pull in the Country dimension from the ISO code and combine the two country fields via IF sentences. 

553
S
Newly Minted Pigmenteer
A
Newly Minted Pigmenteer
Aayush BatraNewly Minted Pigmenteer
asked in Questions & Conversations
Multiple level breakdown - G-sheet integration fails

If I break a metric by mutilpe break downs in a table in Pigment, at the time of exporting to g-sheet using Pigment connector, i don’t see any breakdown. i only see one row of data w/o any breakdown by dimensionsis this a product limitation or a bug ?

295
F
Employee
A
Employee
Adrien LEmployee
asked in Questions & Conversations
Key shortcut

Are any Key shortcuts in Development?A shortcut from Editing to User mode in Board would be helpful, and one for aligning Widget might be great. 

1192
X
Newly Minted Pigmenteer
P
pigment_enthusiastKeen Learner
asked in Questions & Conversations
Different AR on a same metric based on different application

Is it possible to apply different Access Rights on a same metric based on different applications ?i.e. Metric A should have rule configuration of AR 1 (if metric A is used in App 1)and if the same metric A is getting used in other App (App 2 - by turning the sharing On), this metric should have access rights AR 2 AR 1 and AR2 are security metricsIs there any alternative solution for this?

152
P
C
Newly Minted Pigmenteer
CalvinNewly Minted Pigmenteer
asked in Questions & Conversations
Transaction List Lookup Formula Help

Month Seat Worker Future_Worker Future_Worker_Current_Seat Month Dimension Seat Dimension Worker Dimension Worker Dimension Seat Dimension Mar 25 POS-000100 Employee 1     Mar 25 POS-000200 Open Position Employee 1 ???  Looking for some help writing a formula. I have a transaction list called EE_Load_HRIS. I’m looking to write a formula that will return the Seat (POS-000100) in the Future_Worker_Current_Seat property where the Month matches Month and the Worker matches Future_Worker.

352
C
Newly Minted Pigmenteer
M
Seasoned Pigmenteer
mmusabSeasoned Pigmenteer
asked in Questions & Conversations
Circular Reference in 3 way statement

Hi CommunityI am reaching out to broader pigment users to how they solve these kind of issues in 3 way income statements?  ThanksMusab

1101
F
Employee
S
Newly Minted Pigmenteer
Santhosh KumarNewly Minted Pigmenteer
asked in Questions & Conversations
[NEED HELP] Connect Pigment with an External Service Through an API request

I am currently testing an external API integration in Pigment to retrieve a response and display it within the platform. Setup Details: I configured an API connection in Pigment. On the Action board, I added a card with a button to trigger the API call. When I click the button, the API call is successfully triggered. Issue: Although the API call is being made, I am not receiving any JSON response within Pigment. The response does not seem to be captured or displayed. Questions: Is Pigment’s external API setup only meant for POST requests, or can it also handle GET requests and return responses? Can I retrieve the API response and manipulate or display it within Pigment? If yes, what is the proper way to map or use the response JSON in Pigment? ​@Julien | ​@Igor P | ​@CDALMAY | ​@Thu Mai | ​@Jared Dolich 

352
S
Newly Minted Pigmenteer
B
Newly Minted Pigmenteer
BasNewly Minted Pigmenteer
asked in Questions & Conversations
How to link variables together?

Hello,I made a subset in my Month dimension list, in order to create a boolean metric that has Months in rows and columns. I named this subset ‘MonthTimeIntel’. Basically I wanted to create a boolean that checks what the trailing twelve months are for each month. Something like this:So far, so good. I then use this metric as a filter for my charts and graphs where I only want to show the last twelve months. Also: so far, so good. But lastly - I don't want another page selector on my dashboards. Because now the page selector for ‘MonthTimeIntel’ shows up on my dashboards, but I don't want that. Is there a way so that the MonthTimeIntel page selector moves in unison with my Month selector and so I can hide the MonthTimeIntel selector? I understand that they are two different dimensions, but it would be great if they can somehow come together.I hope my question is clear :-) Thanks for helping me out!Best, Bas 

261
Nathan
Employee
ankitgoyal01
Newly Minted Pigmenteer
ankitgoyal01Newly Minted Pigmenteer
asked in Questions & Conversations
Embedding Pigment in an external application

Can we embed Pigment in an existing application so that user does not require to change interface? Is there any SDK that can be made available to partners to embed in a proprietary application?

1292
ankitgoyal01
Newly Minted Pigmenteer
R
Just Arrived
Raman BansalJust Arrived
asked in Questions & Conversations
The dynamic variable is not updating according to the metrics.

Hello Pigment Community,I have created a variable for each metric, and in the table, I have applied the individual variables to their corresponding metrics. I then pivoted the table so that the metrics are in the page selector. The issue I'm encountering is that when I apply a variable to one metric and then try to apply a different variable for another metric, it doesn't update as expected. I need variables to be updated as according to my selection. For example, I have two P&L metrics: Salary Cost and Expense. I’ve set individual variables for both metrics. However, when I apply these variables to different selections on the board, it shows the same variable for both metrics, even though I recently applied different variables for each.Could anyone assist with this? 

161
T
Employee
B
Budding Pigmenteer
BenedikteBudding Pigmenteer
asked in Questions & Conversations
API key Workday stopped working

Hi,I have an issue where the Workday api key stopped working and the data is not longer pushed from workday to Pigment. The Key in specific is called “Workday HCM People Planning” and is an important metrics for us in people planning. The Api key is still active in terms of expiration date 2026-01-01. Can someone please help me with this issue?Kind regards,Benedikte 

213
Stef
Employee
Spandan98
Seasoned Pigmenteer
Spandan98Seasoned Pigmenteer
asked in Questions & Conversations
Nest related dimensions into a single page selector with hierarchies

Hi Pigment Community,Can anybody kindly tell me if this feature is published for Pigment or are there any ways I can achieve this?Thanks!Please click on the link below:  

351
N
Employee
abhilashsawla
abhilashsawlaPigment Academic
asked in Questions & Conversations
Timeout Issue during import

Hi,I would like to know when we get timeout issue during Data import and how to solve it. 

1879
N
Budding Pigmenteer
J
Seasoned Pigmenteer
Justin GrooverSeasoned Pigmenteer
asked in Questions & Conversations
Combine MOVINGAVERAGE and PREVIOUS functions for run rate planning

I would like to write a formula where the intent is for the metric to calculate the average of the prior 3 months of the metric itself.I envisioned the syntax being something like the following, though it says MOVINGAVERAGE doesn’t support recursive mode.MOVINGAVERAGE(PREVIOUS(month),3)I understand that I could use MOVINGAVERAGE without PREVIOUS if the object being averaged was a separate metric, but the use case I have requires the formula to reference metric itself. Is there any solution or workaround for this?  

4682
E
Budding Pigmenteer
N
Newly Minted Pigmenteer
NeoNewly Minted Pigmenteer
asked in Questions & Conversations
Push data from Pigment to Looker

Hi CommunityHope you are well.I am wondering if anyone is using Google Looker as a dashboard/BI tool to report on data from Pigment and is there a way to push data from Pigment to Google Looker seamlessly? What I can find in Pigment documentation is pushing data from Looker to Pigment but not the other way around.The work around I’ve been using is pushing data from Pigment to GoogleSheet and from GoogleSheet to Looker but that requires manual refreshes and it’s not automatically synced (e.g daily) to share across the organisation with other users.ThanksNeo :) 

301
Nathan
Employee
R
Rockney_KPCFrequent Reader
asked in Questions & Conversations
Looking for a specific function

Hello,I’m looking for a specific function to make the calculation on this figure:  Can you please help me? Regards,

342
R
P
pigment_enthusiastKeen Learner
asked in Questions & Conversations
Run action button to clear a metric if a notification is sent

There’s a grid in which employees are assigned to a project.Metrics: initial project and final projectIf both these projects are different for a specific employee, notification in pigment is working fine i.e. If there’s a change in project, to notify the relevant team leader of projects (both initial and final) - P1 and P2.However, there’s a metric called : “Override Project” , which can also derive Final Project.If there’s already a change in project name for Employee ABC (from P1 to P2 project), and then override of ‘P3’ is done (Now, P1 to P3 project), notification should be sent to team leader of projects (both initial and final) - P1 and P3 [P3 Must].Currently, triggering metric for workflow notification is Change in Project? with employee dimension.How can I check the logic again?

494
P
K
Newly Minted Pigmenteer
kevin_huangNewly Minted Pigmenteer
asked in Questions & Conversations
Page selector sizing keeps changing back to default size

 In the dimension drop down, when I expand the size of the page selector it doesn’t save (so everytime when I click into this dimension input it goes back to the default size - any way I can save the size of the page selector? 

1002
K
Newly Minted Pigmenteer
V
Newly Minted Pigmenteer
VikatzenNewly Minted Pigmenteer
asked in Questions & Conversations
Pulling the last available value with BY ->

I have the formula below: (('EE_Comp_01_SabbaticalAccrual_P&L_ReAllocated'    * EE_BU_AllocationFinal    )[BY: -> EE_Card_Department,EE_Card_SalaryCurrency, 'EE_Card_P&L', 'EE_Card_Direct/Indirect'])The highlighted in red, assigned my employees to the department that they belong for each month based on that metric. INSTEAD, I would like to just assign them to the last department they belonged to for each version.  I tried inserting “BY LASTNONBLANK: → “  but it did not seem to resolve the issue. See screenshot for the stracture of the EE_Card_Department below:  Basically I want to adjust the formula above, to assign this employee only to department FBS Revenue.  Any ideas? 

201
Nathan
Employee
A
Budding Pigmenteer
AlinaBudding Pigmenteer
asked in Questions & Conversations
Sorting values in table with multiple dims

Hi community, I need to sort the values in the table from high to low but I need to pivot it to pivot x dims in columns (e.g. Country, Client, Opportunity). If I use the traditional Sorting function of Pigment, it will sort only within the last dimension (in my case Opportunity).Is there a way to sort values disregarding dimensions but still keep them in my pivot?Thanks!

502
A
Budding Pigmenteer
R
Rockney_KPCFrequent Reader
asked in Questions & Conversations
Specific calculation

Hello,I have this figure: and I need to make this calculation → Q1= (1,28+0,72)/3. But I don’t have this option in the calculated item. Can you please help me. Regards,

321
Min Li Bright Point

Badge winners

  • Pigment Modeling Fundamentals Certified
    PamPhas earned the badge Pigment Modeling Fundamentals Certified
  • Pigment Like a Pro
    PamPhas earned the badge Pigment Like a Pro
  • Read and Interpret Formulas Certified
    Chadhas earned the badge Read and Interpret Formulas Certified
  • Pigment Like a Pro
    Rhita Mediounihas earned the badge Pigment Like a Pro
  • Pigment Modeling Fundamentals Certified
    Rhita Mediounihas earned the badge Pigment Modeling Fundamentals Certified
Show all badges
Terms & ConditionsCookie settings