Questions & Conversations

Hi Pigment Community!  I wasn’t able to find a prior thread on this: What’s the best practice to show Months of Actuals and Forecast together based on the Switchover Date? e.g. I have 6 months, and 4 of them are actuals. I want to show the month and period type in the column titles, then my data:                  Sep 23                Oct 23               Nov 23              Dec 23                Jan 23                   Feb 23                 Actual                 Actual                Actual               Actual                Forecast                ForecastRow 1        ###                   ###                     ###                  ###                    ###                          ###Row 2Row 3etc.

Hi everybody, I’m sure, I’m not the only one, who wants to export reports sometimes.Options:Boards are good candidates for it, but there is no export functionality (why?). Metrics/views are good too, but you cannot export multiple views to one Excel or PDFWhat are you ways to export reports to files? Please share your ideas.

Dear community, I hope this you’re all well. This is the metric I want to fill my dimension property with:My quest is: I want it to give me the last client type filled before January 23My metricCan you please help me with this?

Dear community, is there any way I can bring values from a metric’s property to another property in a dimension that takes a value from a line all while specifying the property not to go beyond to make sure it takes the one before the current month? P.S: I tried to use Remove LASTNONBLANK and it didn’t solve what I wanted. 

I would like to be able to show Aggregate (aka SUM or AVERAGE) values in charts on Tables or Metrics. When creating an aggregate field in Pigment on the Grid View, you can see Totals or when using Show Value As you can see items like Revenue per customer (Revenue and # of Customers are two separate metrics). However, when moving to Chart View the aggregate values are not visible in the Chart View

I’m trying to create a template where people can introduce cost by supplier.How can I insert new lines for a preset table or metric? I tried to do so in the spreadsheet functionality bet it’s greyed out. Thanks in advance,G 

Sometimes the data that you upload in Pigment just isn't perfect. And that's ok, because nobody is perfect!In this article, I want to show you how you can convert a numeric date format (usually from Excel) to a date in Pigment. This date can then be used to convert to another time dimension like a month, a quarter or a year. All credit to @Remi for coming up with this methodology.Maybe you recognize this format below from your work in Excel, sometimes your date shows as a number.Example from Excel When your import file contains this number formatted date, there is an easy way to convert it in Pigment without first going back to Excel. As the number format in Excel is basically a calculation of a set start date (1-1-1900) + a number of days, we can use this same calculation to retrieve the date from the number. Use the Date formula to calculate your result as in the example below.  Date(1900,1,1) + Date Formatted Number -2 Date conversion example (dates in MM-DD-YYYY) The reason for the

Hi Pigment team! I’m trying to set up some cohort modeling for launches. I have an input metric, of dimensions [Partner] and [Cohort Month], where Cohort Month is a 0-indexed integer list. The inputs are the number of live clients in that month (it’s chunky, usually a piecewise rollout for the first 3-6 months). Let’s say partner A’s launch is coming up. Launch month is Cohort Month 0:                             0           :           1           :             2          :          etc.            Partner A           100                   500                    1000                  etc. I want to know when to switch from this manual input metric to my growth curve assumption for the forecast, so I have to map these cohort months to calendar months. I think the best way to do this is to have a mapping metric which returns the lastnonblank [Cohort Month] as an integer from the input metric outlined above. I can then use TIMEDIM to add that number of cohort months out from the launch m

Hello, In my Transaction List, I have a column called EUR CST that I calculate from a variable FX column. However, this EUR CST is associated with rates for the year 2022.We have just received the first figures for 2023, but we are now using a different rate (the rates are in a transaction list, with two columns: rate 22 and rate 23).What is the best way/best practice to switch to rate 23 for the 2023 figures?However, I would like to avoid doing this every year (in 2024, it would be nice if it automatically switched to the 2024 rate). Is there a way to do this? Because all my metrics depend on this column.Thank you,Alexandre

Hello ! Sorry my question might be really easy here but I am just a beginner. When trying to map my imported CSV, I have the error message “A Dimension List must have a unique Property".Do you know which error I have made? 

Hi Team,What is the IP for pigment servers that are used to send requests to Snowflake. Our snowflake is gated with IP addresses and we need this to allow access to the pigment tool.

Hi! For creating filtering views, why aren’t some dimensions allowed to be filtered by properties? For example, I have a dimension in my data hub for balance sheet accounts and some additional properties within that dimension, but I’m unable to filter by those properties. What I can do instead is add BS_Accounts → Property as a filter on the right-side bar, and restrict it to what I want to filter Filtering View unable to select “Property” for Dimension “BS_Accounts”: Filtering “BS_Accounts” Via Pages in Sidebar and Restricting Dropdown List: 

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  Second metric - Allocation Key Fees Test - Indirect cost allocation Key→ Logic is to divide the direct costs allocated to each item list by the total cost of the month1. Checkout level test - Direct cost per item - 2 dimensions (ID_checkout, Month)2. Checkout level Fees for allocation key - Total cost per month - 1 dimension (Month)→ It will give to each item lis

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 ☑️ ☑️ ☑️ ☑️ Positions can be a part of different teams over time. I have another metric, *Position Mapping* which is of type Team with the same dimensions as the boolean. Position Version Q1 Q2 Q3 Q4 001 Forecast Team A Team A Team A Team A 001 Plan Team A Team B Team B   002 Forecast Team X Team X Team Y Team Y  Now I want to add the Team dimension into the first metric. I have tried doing it like this:‘My boolean’ [by: → ‘Position Mapping’]Team Position Version Q1 Q2 Q3 Q4 Team A 001 Forecast ☑️ ☑️ ☑️ ☑️ Team A 001 Plan ☑️       Team B 001 Plan   ☑️ ☑️   Team X 002 Forecast ☑️ ☑️     Team Y 002 Forecast     ☑️ ☑️  This achieves the goal except for one thing. Wh

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