Questions & Conversations

Hello community,I'm looking for a cumulate grouped by Qty. I have a first metric which indicates my need of Qtés per week, and I need a second metric able to detect the week when I exceed the minimum to order. In my example, I have a minimum order of 6. In Line 1 I calculate my requirement per week. (that's done)In Line 2 I want to trigger an order when I've reached at least my minimum order.If I have that, it's already good In an ideal world, I'd have to reduce this quantity to the 1st week, a bit like a moving sum function but with variable parameters. If anyone has an algo idea, I'd be grateful ^^. 

Hi team,  I am trying to cumulate the result for two different scenarios. Can you please help?[Blue] Cumulate in the last period. The result of this formula is in between Feb ‘23 ~ Aug ‘23. I would like to cumulate Feb ‘23~Aug ‘23 and show the total in Aug ‘23. -IF( Month < 'RSU Accounting Data'.'Term Month' AND Month < 'RSU Accounting Data'.'Vesting Month', (PRORATA(Month, 'RSU Accounting Data'.'Amortization Start Date', 'RSU Accounting Data'.'Vesting Date'+1) *'RSU Accounting Data'.'Expense Amortized Future' / 'RSU Accounting Data'.'Amortization # of Days' * DAYSINPERIOD(Month))) [BY:'RSU Accounting Data'.RSU#,'RSU Accounting Data'.EE,'RSU Accounting Data'.Vested?,'RSU Accounting Data'.'EE Active? (Incl. Future Term)','RSU Accounting Data'.'Client Grant ID','RSU Accounting Data'.Forfeit?,'RSU Accounting Data'.Type] [BY: 'Accounting Status'."Reversal"][BY SUM:SHIFT(Mon

Hi All, hoping you can help me here … I need to create a metric using just 3 accounts of the GL, I know I can use the filter option but this doesn't work as I need to sum this metric total to other totals from different metrics. Is there a way to pull my GL Actuals asking Pigment to exclude everything but these 3 accounts? 

Hello,I need help setting up an API request for UKG. Is there a solution or guide available? 

Hello! Could you help me with setting up the formula with the given metric/txn list below? Metric: 1.0 [Post Acq.] Amortization Schedule (Forfeit+Current)I created amortization metric for each grants by month. I confirmed this amort. distribution is correct. Transaction List: RSU Accounting DataBelow is the transaction list, providing the grant details for above metric (type, employee termed date, grant vesting month, employee original terminated month). Above metric is also based off this transaction list. With given two blocks, I am trying to show the actual P&L impact for each month. I’ve created the output ta

How can I filter a dimension dropdown in my table? I created a dependent dropdown but there is still the ability to select “all options”. I still need the user to have read access of all list members in because they are also viewing their previous budget but I want to limit the dropdown because some choices are now inactive. 

Hi everyone, I am working a logic where I need to Input P&L interest value line based on calculation which will refer to P&L Interest line again.  Below is example of same with Excel formula, how do I avoid error on P&L Interest line.   Thanks.

I am trying to recreate the below waterfall-type allocation and running into an issue having to use previous() functions across multiple dimensions. I created an example below to recreate what I am trying to accomplish. In the example, I have a certain amount of dollars to spend each month that I need to allocate across various items. I can’t spend more than the amounts on the column header and each item has a certain cost associated with it.  I am able to accomplish it with the formula using excel below but when I try to do it in Pigment, I having to use previous on both the month dimension and the item dimension in order to ensure I don’t go over the capped quantity/cost. Anyone have any suggestions?   

My team has been experiencing issues with the Excel connector lately, receiving this error sometimes when trying to pull data into Excel:“An error occurred (Data pull). Please try again later or contact us”.  Does anybody know why this error occurs? Is there a row or data limit when pulling into Excel that we should be aware of? 

Hi everyone,I’m designing an approval dashboard and need end‑to‑end visibility on every step of the workflow. When a user clicks “Mark as Done,” I’d like to capture: Who completed the task and at which workflow level Which tasks are still pending and the personas responsible Overall progress and potential bottlenecks across the entire process Can Pigment’s built‑in Workflow feature surface this information (e.g., through metrics, status boards, or conditional formatting)? If so, what’s the recommended setup to track these states in real time?Thanks for your guidance!

I have a list on a board. I noticed that when I filter directly in the list, there doesn’t seem to be a way to remove the filter from the board view. I have to expand the the list and go directly to the block in order to remove the filter. Is there another way to remove list/table filters when I right click? Currently, it allows me to keep adding filters but not way to remove or edit filters already in place.The example below has a filter on a text column. I do know that if this was a dimension I could add it to page selector but in this case, we have it as text by design.  

Hi everyone,I’m trying to export data using the endpoint https://pigment.app/api/export/view/<view_id> via PowerShell. Despite using a valid API token and correct view ID, I get DNS or connection errors.I’ve tried: PowerShell, Postman, and curl Changing DNS to 8.8.8.8 Running from mobile hotspot and cloud environments Swagger UI — but after authorization, all actions are locked and I cannot trigger export None of these methods are working.Could you please confirm: Are these endpoints operational from India? Are there any region-based restrictions or settings required to enable export? Thanks,Spandan Talukdar

I am trying to identify the most recent date in the transaction list at the vendor, IS0, and Function level. I am using a MAXOF (date) formula and aggregating by desired dimensions. Any idea why this formula isn’t working? 

Hi Pigment Community,I want to calculate Growth Rates with the PREVIOUS function, but suddenly it doesn’t work as expected.This is my simple Test Metric:Calculating the Growth with PREVIOUS does not work:​​​​​​However, selecting the previous Year with SELECT does work:I would expect the PREVIOUS function to select exactly the same cell as the SELECT function. Am I doing something wrong here?

Hi All,I am working on requirement where the calculation involves a multiplier to be applied on previous years based on year for which it is calculated. Please see screenshot below.I want to achieve the result in B to be dynamic, so it can be calculated until whichever year user decides it needs to stop. Currently I have achieved this by manual multiplier & Select function on Year to offset, but this is limited to years based on offset I define in formula.'Metric A' + 'Metric A'[Select: Year-1]*2 +  'Metric A'[Select: Year-2]*3 + 'Metric A'[Select: Year-3]*4 + 'Metric A'[Select: Year-4]*5 Please advise, if there is a way to make this dynamic.Thanks

We use Rippling for HRIS and Payroll. There is no native connector. I am looking for specific guidance and best practices on how to integrate them. I will share this info with IT and my consultant. Thanks.

Hi everyone,Is there a way to add dynamic variable for scenarios. For example, I have 2 scenarios, Actual and Budget and for some boards after the user ticks a Boolean check-box metric I want to show them the budget scenario else the budget scenario will be hidden.Is there a way I can achieve this?Thanks & regards,Spandan

​​​​​​I have a metric called 'EE_Card_Employee Manager' with the following:Dimensions (2): ‘Employee’ & ‘Month’Data Type: Dimension ‘Employee’Currently the metric shows each employee’s manager each month. I would like to create a new metric that counts an employee’s # of direct reports by month. I am using the following formula which is not returning the correct result, can someone please advise?COUNTOF('EE_Card_Employee Manager') [by: -> 'EE_Card_Employee Manager'] [remove count: 'Employee']

Hi Pigment,I shared with our team the new dimension mapping capability but they can't use it, what access rights and permissions they should have in order to do it?https://community.pigment.com/reporting-data-visualization-83/group-data-dynamically-with-mapped-dimensions-3160Thank you,Omer.

Hi everyone,I want to lock the budget scenario after my actual date starts, for example till 31st Dec, 2024, I will allow users to make change but when the date goes to 1st Jan, 2025, I want the budget scenario to be locked.Is there a way I can achieve this?Thanks,Spandan

I have a metric that requires user input — it has a base scenario and a second scenario. I would like scenario 2 to initially default to the input for the base scenario but then have the ability override it and be a separate input from the base scenario.Is this possible? 

I have a Field /List Property in a Transaction list whose text I need to parse. How can I convert the dimension value to a text value so I can parse it?

Hi everyone,I’ve always appreciated the regular updates in Pigment and eagerly await them each day. However, I noticed that the recent addition of constant black borders around grids doesn’t align well with the overall formatting of the boards and the brand aesthetics of companies. It would be great if this could be reverted to the previous design, which felt more consistent and visually cohesive.Thank you!

I’m trying to calculate fee % on the total amount. Both metrics have the same 5 dimensions. However my output when I directly calculate it as a formula is different from when I use Calculations “show value as” in the table which is correct.Since both have the same dimensions, how do I get the correct % at all levels of the dimension?The first is from “show value as” and the second is from a metric. How do I get both of these to be correct and the same? 

Hi,When an holidays lands on a non working day NETWORKDAYS deduce twice the day. Is it normal ?Thanks