Questions & Conversations

Is there a way to filter from the view all metrics in 1 filter to exclude zero values from a table? If there is a table with a lot of data & we want to connect it to a gsheet, having many rows with zero values slow down things. 

Without Round Up we were getting the value as 6.40 in june 23 in Black (Dimension list item) after round up we are getting 8 in june 23 but the value should come as 7. This is one example we are showing here but there are multiple errors. we are attaching the screenshot for the same

Does pigment.app have an api documentation, regarding the usage of api key .i am looking for full api doc that will help me to understand the endpoints and using those with cURL requests

We have a few spaces left for the next Customer Connect - Servicing Executive Stakeholders in Pigment!Next Monday we’re talking about servicing stakeholders in Pigment. Whether it’s investors, the C-Suite, or an executive sponsor, we want to discuss how you’re approaching this in Pigment. One of our Solution Architects will prepare some questions to help guide the conversation, but it’s an opportunity for you to share your own insights, and get some to help you better serve your own stakeholders.Are you a customer who wants to share and learn from your peers on this topic? Sign up now! 

Hello !I would like to duplicate a board for our German team (I have currently created a sales reporting for our French and Belgian team). However, if I duplicate this board and apply “Germany” in my Country dimension page, it also applies this country to my other board (for France and Belgium)… Do you know how I can unlink the 2 boards so that when I select a country, it doesn’t change the country in the other board?Thanks!!Elodie

I have a metric containing data that I would like to associate to a dimension list property, the LASTNONBLANK formulae is not working.

Plan

Hello community :) I have a dimension with all my employee and their packages (with historization). For example: one personn who received a salary increase have 2 rows:first row with start end date of previous package second row with start date as end date of the previous packageWould it be possible to create a formula which allows to have a filter in page which ables to select only the last value in the dimension for each employee (ie the last up to date package)? Thanks a lot!

Hello community,I contact you regarding an issue of indirect costs allocation to several list items.I have (fictive number) 10K€ of indirect costs categorized as “No checkout ID” which i want to allocate to each item of my item lists based on an allocation key.To do so i’ve created 2 metrics based on 2 unique dimensions :1. “Id_checkout” (Item list to which the direct costs and indirect costs are to be allocated)2.  “Month” (because the allocation is based on a monthly basis)First metric - Checkout level test - Consolidation of indirect costs→ Filter on Indirect costs (“No checkout Id”)→ Dimensions : Date (Month), Id_Checkout  

I have a transaction list that I want to move to a different application. The list is updated automatically using an API key. If I move the transaction list to its new application, will I need to update anything on the source system side or will the API key continue to work?

Hi everyone!I would like to know which encoding is recommanded when importing a document containing € signs. I usually pick the “Western European (ISO)” encoding but the € signs are not compatible:Could you please help me understand if this comes from the encoding or if I should adjust another parameter when importing data?Thanks! 🤗Elodie

I have a boolean metric with three dimensions: Position, Version and Month. Position Version Q1 Q2 Q3 Q4 001 Forecast ☑️ ☑️ ☑️ ☑️ 001 Plan ☑️ ☑️ ☑️   002 Forecast ☑️ ☑️ ☑️

Hello,I have a metric (dimensions Month and Employee) where I have the Country of an Employee by Month (for example : from Jan 22 To Jun 22 → France, From Jul 22 to Dec 22 → UK).I have a Transaction with financial accounts with columns of Month and Employee ID.I need to get the Country of the Employee in the Transaction, according to the Month. How can I do that ? Thanks,Alexandre

Hello Pigment Community, I am trying to calculate the quarterly bonus of my employees and shift it by one month to simulate the payout on the first month after the quarter end.I will detail below the steps of my calculation and where I am stuck:My bonus expenses are by month. I was able to sum the quarterly amount with a [BY SUM: Month.Quarter] modifier. I want to add again the “Month” dimension and put this quarterly amount on the last month of the quarter only (or first month of the quarter, it doesn’t matter). This is where I am stuck. If I use a [BY CONSTANT: Month.Quarter] - the amount is written on all months of the quarter, and then I am unable to filter only on the first or last month of the quarter. The last step will be to SHIFT this amount by 1

Wondering if there is a way to handle special characters that are present when dimensionalizing a text field where they are initially present.  In this example, the tilde over the “e” in cafe shows properly on the “Channel Name” of Type Text, but does not within the “Parent” field of type Dimension.  

Hi Pigment team,I need your help on creating a metric that reflects the values of prior period for a given metric, in a flexible way that allows me to change to quarters, months and doesn’t lose accuracy when aggregating.Thanks for your help :)

Hello Pigment Community, We are importing our General Ledger in a Transaction Table. In this Transaction Table, we have 2 key information that we are trying to rework:Document Number CC ID (= it’s the department ID) Our issue is that we have multiple lines for the same document number with multiple CC ID. Our objective is to get a unique list of document numbers with a unique CC ID attached to it. We know in advance that a specific list of CC IDs are not relevant and that we want to exclude them. If you look at the screenshot below, we have multiple lines for the Document Number “JOUFR12797”. We want to attach to this document number which CC ID it is flowing to. Our standard CC ID is

Hi Team,I just want to know is their any way by which pigment can automatically generate some number/code to a line item so that unicity remains in the list and once the code is allotted to a line item it can’t be changed even after the line item is deleted.   Thank you in advance 

Hi Community!Love our trace dependent feature for tracking interlinked metrics/data sources but I’m wondering if there is any way I can see from a dimension which metrics/applications it is being used in. Wanting to do some cleanup of our dimensions and prior to deleting I want to find a way to ensure I won’t break anything after deleting.Thanks!

Hello community! I’v created several boards with sames tables but for different stakeholders (Top management, Finance and People). However people should not see details of people department, Top management should not see top management department for confidentiality matters. How can i create access rights on a dimension ? In fact, all tables have the dimension “Direction” and I want to create access accoding to this dimension (ie people could not have access to people). Thanks a lot!

Hi Pigment team:I’m trying to format the formulas so I can make them easier to read.For instance, I have a formula that is an addition of 4 items and goes on for 5 lines (difficult to read), I’m looking to structure the formula in 4 lines (easier to digest):= Item 1 +Item 2 +Item 3 +Item 4 Is this something we can do? Thanks in advance :D

I think this is a simple problem, but it probably isn’t. I have a metric (Metric - Is locked) of type: Dimension (Locked) with only Yes or No as options. Dimension: Version Metric: Yes/No Actuals Yes Plan Yes Forecast No  Can I easily flip this around to show the inverse of the metric (here using firstnonblank)?Dimension: Locked Metric: Version Yes Actuals No Forecast  

Hello Pigment Community, I need your help on calculating merit increase for existing employees. To give you more context, our merit increase calculation is made of:1. The annual package of an employee → this is the basis for our calculation. 2. The merit increase % : it will be applied to the annual package and is cumulative through the years. 3. The merit increase eligibility: we calculate it based on the start date of the employee. 4. The timing / effective date of the merit increase: it is the month the merit increase will be effective.We are currently stuck on the last part, which is the timing of the merit increase.I will explain quickly each component below and will explain more in details why we are stuck on the effective date and what we try to achieve.  1 : The annual package of an employee.Let’s say we have an employee making 40,000 EUR a year.

Hi Pigment community, My case description:I have 3 Transaction List [TL], which have accounting transactions, I added to those list identical dimension.Then I have created a “Staging Metric” that’s adding up for 3 [TL] the column “USD Net value” (number property), on the following dimensions [by: Company, ‘Company and Account’, Month]Note: ‘Company and Account’ dimension is the lowest level and from where stem the Reporting dimensions (Level 1, Level 2, Level 3).The metric aggregates well, and adds up the transaction values at each reporting level and at each time level (month, year, quarter).Then I want to create a metric that does the cumulative for “USD Net value”, so I can get the values for the “Balance Sheet” cumulating on a monthly basis. I use the following syntax:Cumulate('Staging Metric'[Filter:'Company and Account’.Report = Report."Balance Sheet"],Month) Cumulate('Staging Metric',Month)

Hi Team, It would be a great help if you suggest some best practice to map dimensions in a dataset so that it consumes less space and time moreover data will look more clean and easy to read in pigment.  Thank You!!