Questions & Conversations

Can someone give me an example of when we should use previous VS previous on? Such as, previous(month) VSPREVIOUS(Month ON -RANK(Month.'Start Date')

Hello,I’m trying to sort by subtotal but I don’t succeed, can you please help ? I have a metric (grid) with 2 dimensions in my columns. I would like to sort by descending value order for the 1st dimension of my column, i’m unable to do that. Do you have any idea how to do it please ? Thanks 

Hi,I have two metrics with the same data type: dimension (Month) and the dimension structure for both is the same. The concept is that I have deadlines for different dimension items. I was to append these two metrics because one is the prior forecast deadlines and the other metric is the current forecast deadlines. I want the new metric to have both.  When I do metric1 + metric2 i get this error:“Arithmetic operators only accepts same type arithmetic inputs after implicit casting, received Dimension (Month) operands” Please help! Thank you! 

hello,I’d like to freeze some columns in a table so that they stay visible while scrolling. Is it possible ?

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!

Is there a way to allow a user to trigger an import configuration for a list in application A, from a board in application B?When I attempt to configure the button it is only showing me lists from application B. 

Hello Pigment team,we use the export API for almost one year, but we have suddenly got error 429 in our export job using the API. Not for every job, but it happens often. Did you change any rules for export API ? I haven’t found documentation about it.Thank you in advance for your answer Sincerely,Mickaël

Hello All, I’m currently trying to build an effective date for Merit increases and my input is as follows dimensioned by country and year. Right now, I’m trying to populate the table below with the month of the year e.g. FY23 should should December. I tried writing a formula TIMEDIM(ASM_Input_Merit Date, Month) and convert the data by Month.Month of the Year but it doesn’t work. Any suggestions on how I should write this formula?

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.  

Hello,As I start my pigment training and work through the formula exercises, I have a question regarding the order of using multiple modifiers within a single formula.I’ve read that the sequence is important when combining BY and FILTER. In the same way, are there any best practices or modeling guidelines that affect performance or functionality when using several modifiers and operators together in random sequence, such as BY, BY->, Select, Filter, Add, Remove, or Exclude?Below is one example from the formula exercises (it may be a simple formula but I am thinking about what sequence to follow for complex formulae):'EE_Calc_MonthlySalary_+increase'[BY SUM: -> EE_Data_Stand.Area][by: 'GL Account'."11100"][remove sum: Employee][by :-> MAP_Datatype] Thanks

Source metric: ‘test’ is having dimensionality City, Category, Personalized quarter, quarterTarget metric: ‘test2’ is having dimensionality: City, Category, quarterTarget metric formula is:test[BY SUM: ‘Personalised quarter’.mapQ]For Fruityburg city, Q1 2024 → it should return 1790, but it’s giving 100  

HiI want to restrict users on selecting only months with actual data and set up the Current month (the last month with actual data) as default for the Month selector.I created the Actual Months (multiselect) and Current Month item variables.Then I set up Actual Months as available items and tried to set up Current Month as default item.But after applying these settings nothing happend, meaning the Month page selector shows All, not a particular - Current - monthWhen I returned to Selector options I found out that default item for month had been changed to All values.

Hello-As I begin pigment training and work through the formula exercises, I’ve noticed that while CONSTANT is the default allocation method, I often omit it, assuming it will apply automatically. However, the post-exercise walkthroughs consistently include it explicitly.Is there an advantage to always specifying CONSTANT (for allocation) or SUM (for aggregation), even when they’re defaults?Thanks,Sudhakar

Hello Everyone,I’m trying to build a validation process for headcount planning where I can track if a team member’s salary/cost center/class change vs the last load month. We currently load our data daily and each load will replace the previous load within the same month, so we would be comparing the difference vs the last load month. My intention is just to build a board that notifies us when changes happen and I don’t need to create a whole process of validation before these changes runs through to the forecast. Any help would be appreciated. Thank you!

Hi I'm working on a centralized user access for several apps in the workspace, including Roles and AR Metrics.I want to create User Roles and Access Rights in the Data Hub and share them to other applications through Library.This article  is marked as legacy. I'm curious what's the new approach and where I can find information about it? To which extent I can use this article advices?Another article has the section related to the topic “Smooth User Access Management” with a link, but the link doesn't work 

Hello,I have a metric that shows the P&L.I’ve been asked to add multiple ratios like % of GM / Revenue or % Contributive Margin / Revenue. The issue is that the accounts are not on the same dimension (revenue is Account lvl 2 and Gross Margin is Account lvl 3).What is the easyest way to add those ratio. Do I need to create a specific metric just for them or can I do the calculation directly in my metric ?

Hello, I am trying to create a calculated item to sum values from countries into a region. However, I only see the option to combine Item A and Item B… is there a way to insert more Items (e.g. Item C) in Pigment? Thank you!

I have a metric with a dimension data type. I want to set a default value for this metric from its dimension when no value has been selected. Is it possible to do that?

Hello Pigment team,  I am trying to build a simple table that shows All-Time-High result based on the report. As shown below, there are multiple segments (No Sales, Core I, Core II, etc) and each reached highest (i.e. max) in different period (highlighted in yellow. Based on Period Type: Actual only, I would like to show 1) highest number for each segment and 2) highest date. I assume i need to create two different metrics and combine in a table. Is my approach right?   The table setting would be something like this:(Please note, the values below will not match with the values above highlighted cells)  

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?

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 y

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

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?

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.

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