Connect with other users, discuss how you're using Pigment, and get inspired
Find everything you need to get going
Learn about Pigment features
All the best practices and the guides from the Pigment team
Would like to default the page selectors in my application to dynamic display as opposed to default. Is there a way to do this without manually adjusting every view?
We are pulling data from a view in Pigment into Sheets via the Pigment Connector and have noticed that the date information that is pulled does not necessarily reflect correctly.The month in Pigment, for instance, shows “Jan 24”. However, when this data is pulled into Sheets via the connector, the actual underlying date comes over as 1/24/2023 (which would be January 2023, and not January 2024). Is there a known way to account for this disconnect in dates between the month in Pigment and the way that gets translated into Sheets? Below are a few screenshots to illustrate the point: January 2024 date in Pigment translates to January 2023 in Sheets via the connectorJanuary 2024 date in Pigment translates to January 2023 in Sheets via the connector
I was able to Breakdown by Department>Internal Group property for one metric in a table but I’m not able to Breakdown by Department again for another metricI’m able to breakdown by department in either of those metrics but not both. I’m using breakdown option at various places in this table which allows the same dimension to be broken down among different metrics multiple times but not this one specifically. What could be the reason for this?
I everyone,Do you know if there is a way to pull a dimension based on a metric ?Here is what I would like to do :I have a dimension that has :An ID number column from 1 to 1000 (manually filled) A Country dimension column (that I want to fill with a formula) A Month dimension column (that I also want to fill with a formula) An Activity dimension column (that I also want to fill with a formula)On the other hand, I have a number metric with the tree dimensions Month, Country and Activity, with an input based on a formula that gives me numbers from 1 to 1000.So in my dimension I would like to affiliate the month and the country regarding the column number, matching with the number metric. I tried Match and Item functions but it is not working.Do you know if it is even possible with Pigment ? Thank you for your help !
I am looking to find a way to setup an automatic feed for 1-month SOFR future rates in order to better forecast variable interest rates. Does anyone have any experience with this or have any recommendations?
Hi Pigment Community, Is there a way to insert a Trend Line on a chart similar to Excel? For instance, here I have a chart, which is trending slightly upward.
Hi Pigmenteers 🤗I have 2 questions related to Pigment’s native scenarios:1. What are the main benefits of using native scenarios instead of custom scenario list? 2. I also learn that once you enable native scenarios in Pigment, the native scenarios will be applied to all the metrics in the application, is there a way we could remove it out of some specific metrics?
Hi,I’m trying to calculate a moving average where blanks are counted as zero’s. When trying to leverage the “is defined” formula I get a calculation time-out error. Please advise.
Hi Guys, I have a beginner’s question. I am not entirely sure I understand the difference between BY and ADD. I understand both can be used to split the data into additional dimensions but not sure when I should use which. For example - I have data by Period and Account. For the purpose of dimensions alignment with other metrics, I need to add Channel and Country assuming the same values for Channel and Country per Period and Account. I know I can use BY or BY CONSTANT but what if I use ADD? What would be the difference? Regards,Adam
Hi!I’m having issues with a formula. My formula is currently looking like this:The result I get is the error message Function error: function IF argument 2 and 3 need to have the same type. Any idea of what I need to do to get the dummy name in the CC# column?
I’m running into an issue with the dates getting mixed-up when I load data from Pigment to google sheets (see the formula bar in the screenshot, the date ). The issue is that the title which is a text field appears as the header, and gets translated to a date incorrectly. I tried switching the header in Pigment, but the start/end date fields aren’t listed as options. Did anyone else encounter this? Any suggested solutions?
Is there a way to apply conditional formatting to a column/row with the option of removing the formatting on specific cells within that column/row?In the attached example, I would like the bottom row to not be subject to the conditional formatting.
Dear Pigment Community,I'm currently tackling a challenge with a modeling project and could really use your expertise.Goal: Forecast future customers using the average months to convert.Issue: I have a metric for my forecasted number of customers, but I'm stuck on how to shift these values forward into the future based on my metric that calculates average months to convert. Desired outcome: My ideal solution would take the forecasted customer values and shift them forward into the future by ‘x’ months based on what the average months to convert value is. Please find images and further explinations bellow.This metric contains the number of custstomers expected.I want to use this metric to push the values in # cust fcst forward into the future by the number of average months.Example using the images above:metric[# Customers FCST]: France, Inbound Nov 23 value will be shifted to Mar 24, 4 months into the future because the metric[Avg months to convert previous year] value is 4. I'm open t
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.
Hello Pigment!I am having an issue with a formula.I have a dimension called 'MRR-D Invoice '. I want to create the column “latest_suscription_duration” which takes the same value as“subscription_duration” according to the max end date, and that, for each customer. This is similar to a group by function in sql. Anyone knows how to do that ? I tried this but it gave me weird results because I didn’t group by customer reference :'MRR-D Invoice .'Subscription_duration'[BY max 'MRR-D Invoice '.'End_date' ] PS : End_date is a dimension, Subscription_duration is an integerCustomer_reference End_date Subscription_duration Latest _subsciption_duration Customer A 24-Jan 3 3 Customer A 21-Jan 12 3 Customer A 23-Jan 4 3 Customer B 24-Feb 12 12 Customer B 23-Feb 12 12
Contact our support team and we'll be happy to help you get up and running!
Already have an account? Login
Single Sign-On Need help?
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.