Skip to main content

Questions & Conversations

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

  • 904 Topics
  • 2,403 Replies
904 Topics
A
Author
A_GarneriAuthor
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.

4322
Matt D
Employee
F
Apprentice Author
FranckLPApprentice Author
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

812
F
Apprentice Author
Dmitrii
Master Trendsetter
DmitriiMaster Trendsetter
asked in Questions & Conversations
Autonumbering column in a Dimension?

I have a dimension with a few hundred elements. I would like to have a column which has an auto-numbering id for each element in the dimension. Is there a way to create such a column?

212
Benoit
Community Manager
JRRajavarman
Apprentice Author
JRRajavarmanApprentice Author
asked in Questions & Conversations
Import time format MMM FYYY (Jun FY25)

Is their a way we can import Month as Jun FY25 with Custom Mapping, i tried with some wildcard % but no luck MMM %FY%YY is not support, MMM %%YY pigment import spins infinity. Please note my target metric is dimensioned on Month.

271
Z
Employee
S
Apprentice Helper
SHeckhuisApprentice Helper
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. 

943
S
Apprentice Helper
A
Apprentice Author
Aayush BatraApprentice Author
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 ?

465
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. 

1352
X
Apprentice Trendsetter
Chahat
Master Author
ChahatMaster Author
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?

362
Chahat
Master Author
C
Author
CalvinAuthor
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.

872
C
Author
M
Wallflower
mmusabWallflower
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

1481
F
Employee
S
Apprentice Author
Santhosh KumarApprentice Author
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 

902
S
Apprentice Author
Bas
Master Author
BasMaster Author
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 

1031
Nathan
Employee
ankitgoyal01
Apprentice Author
ankitgoyal01Apprentice Author
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?

1782
ankitgoyal01
Apprentice Author
R
Apprentice Author
Raman BansalApprentice Author
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? 

281
T
Employee
B
Author
BenedikteAuthor
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 

1363
Stef
Employee
Spandan98
Master Author
Spandan98Master Author
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:  

521
N
Wallflower
abhilashsawla
Master Author
abhilashsawlaMaster Author
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. 

2229
N
Trendsetter
J
Master Trendsetter
Justin GrooverMaster Trendsetter
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?  

5182
E
Author
Neo
Author
NeoAuthor
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 :) 

591
Nathan
Employee
R
Author
Rockney_KPCAuthor
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,

462
R
Author
Chahat
Master Author
ChahatMaster Author
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?

734
Chahat
Master Author
K
Author
kevin_huangAuthor
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? 

1062
K
Author
V
Trendsetter
VikatzenTrendsetter
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? 

561
Nathan
Employee
R
Author
Rockney_KPCAuthor
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,

391
Min Li Bright Point
Master Helper
M
Apprentice Author
MukulApprentice Author
asked in Questions & Conversations
Import data from one list to another

Hi, is there a way to import list items of one list into another list?

2275
Julien
Employee

Badge winners

  • Read and Interpret Formulas Certified
    Hang Nguyenhas earned the badge Read and Interpret Formulas Certified
  • Pigment Modeling Fundamentals Certified
    Mr Philhas earned the badge Pigment Modeling Fundamentals Certified
  • Read and Interpret Formulas Certified
    KBOhas earned the badge Read and Interpret Formulas Certified
  • Pigment Modeling Fundamentals Certified
    Bhavna Karalehas earned the badge Pigment Modeling Fundamentals Certified
  • Read and Interpret Formulas Certified
    Sabielhas earned the badge Read and Interpret Formulas Certified
Show all badges
Terms & ConditionsCookie settings