Skip to main content

Questions & Conversations

Got a question about your models? Want to start a discussion? It's here!

  • 757 Topics
  • 2,067 Replies
757 Topics
A
Seasoned Pigmenteer
A_GarneriSeasoned Pigmenteer
asked in Questions & Conversations
Axis labels: any way to improve them?

Hello Pigment!I am currently working with some charts for a board, but I encountered a issue: the axis labels are showing very random values, based on the values I have available: “95,671,103”? why not 95,000,000/96,000,000?“86,103,993”? why not 85,000,000/86,000,000?My first solution was to set the left axis labels to millions, so the information would be clearer:The problem occurs when I apply filters or use the selectors on my board and my values drop below millions; it shows decimals or even just 0: Is there a way to make it dynamic and recommend more appropriate values?Thanks in advance 

3291
Andrea
Community Manager
A
Just Arrived
AshishpJust Arrived
asked in Questions & Conversations
How Can I create a subset of Dimension list ?

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?

1892
Benoit
Community Manager
A
Seasoned Pigmenteer
A_GarneriSeasoned Pigmenteer
asked in Questions & Conversations
CUMULATE on Multiple Dimensions (Using "on" operator), based on Ranking Metric

Hello Pigment!We trying to cumulate values on 1 metric based on ranking, but this metric has 2 dimensions on its structure (Customer, Region), so we have the Ranking Metric and To Cumulate Metric, ex: Region (Dimension) Customer (Dimension) To Cumulate (Metric) Ranking (Metric) Cumulate on Rank (Metric) 1 C1 50 5 148 2 C2 20 2 30 3 C3 30 3 60 1 C4 80 6 228 2 C5 110 9 513 3 C6 90 8 403 1 C7 85 7 313 2 C8 38 4 98 3 C9 10 1 10 The current issue its if we try to do that using CUMULATE, we can only set the accumulation through 1 dimension (either Customer or Region) and using 2 cumulates at the same time seems not to be the solution so farAny recommendations? Regards,Agarneri

782
A
Seasoned Pigmenteer
M
Newly Minted Pigmenteer
Moosa MalickNewly Minted Pigmenteer
asked in Questions & Conversations
Locking Version

Hi,I am trying to build a forecast in Pigment which can have multiple versions. Is there a way, we can lock formulas in versions? I know there is a scenarios feature, in which we can have formulas for different scenarios. Are scenarios the preferred way of versioning in Pigment?  Thank you

2175
Lehtohen
Budding Pigmenteer
CDALMAY
CDALMAYKeen Learner
asked in Questions & Conversations
Change in Fiscal Year once live

Hi community,Has anyone successfully changed the fiscal year for a customer after they've been live for some time?I have a customer who has been live for two years with a fiscal year aligned to the calendar year. However, starting next year, they are shifting to a fiscal year that begins in February. This means Fiscal Year 2024 will run from 01/01/2024 to 01/31/2025, creating a 13-month fiscal period.As a workaround, I considered manually updating the mapping between months and fiscal years to set January 2025 as part of FY24. However, these properties are protected, so I'm looking for alternative solutions until this feature is implemented.I want to keep the past fiscal periods unchanged, so FY23 should remain as 01/01/2023 to 12/31/2023.Thanks for the any suggestions or ideas.

540
CDALMAY
A
Seasoned Pigmenteer
A_GarneriSeasoned Pigmenteer
asked in Questions & Conversations
It is possible to rename selector/slicers on boards?

Hello Pigment,We name lists and their properties according to a specific nomenclature based on the purpose of each list. For example, if we have 2 lists of "Master Data," the first list is called MD01 Master Data List 1, and the second would be named something like MD02 Master Data List 2 and so on.The problem is that these names are not very attractive for the front end. However, on the back end, they are crucial due to the structure of our apps. In the slicers or selectors, the list name with its nomenclature appears, and it’s even more cumbersome if we are using any property of the list as another selector. For example:Selector 1: MD01 Master Data List 1: (ITEM)Selector 2: MD01 Master Data List 1 > MD02 Master Data List 2: (ITEM)Is there a possibility to rename them?Thanks in advance.Agarneri

412
A
Seasoned Pigmenteer
D
dariousKeen Learner
asked in Questions & Conversations
Aligning Metrics Across Applications: Handling Different Time Dimensions in Pigment

Hi Pigment Community!I'm currently facing a challenge and would appreciate your advice.The Issue:I need to combine two metrics from different applications to create a comparison view for my users. Here’s the setup:App 1: Holds the visual displayed to users and includes a metric titled “Actual & FCST # SQL -> SQP - NBiz.”App 2: Contains a metric titled “# FCST SQL by SQL date - NBiz.” This metric has been shared with App 1, so I can access it there.The problem arises when I try to bring these two metrics together. Since the applications have different time dimensions, I end up with two sets of time dimensions in my final metric, causing the values to not calculate correctly.Additional Context:I've separated the time dimensions in these applications because they have different period lengths.However, the specific data I want to combine should fall under the same period of time.Possible Solutions:I’m considering using the remove modifier or specifying [by: month] to align the metri

1291
CDALMAY
B
BenedikteOccasional Observer
asked in Questions & Conversations
Apply default formatting specified to a role

Hi,I am looking for a solution to create a default filter specifically per user. Today we work across different countries and would like to set default filter per board per person so that Person A see country “Finland” as default and Person B always see country “Germany” in the same board. Any suggesting on how I can implement this?Would really appreciate you help on this topic:)Kind regards, Benedikte

732
B
P
pigment_enthusiastKeen Learner
asked in Questions & Conversations
Updates/ History for formatting

Can we see the history/updates of following:formatting done on table’s metrics Aggregators applied on tables

1121
CDALMAY
R
Newly Minted Pigmenteer
Ramana ReddyNewly Minted Pigmenteer
asked in Questions & Conversations
Transactions Bulk Delete

Hello Everyone, I am new to Pigment and started with training recently. I came across a scenario where I had to delete a few items from the transaction list and realized the only option we have is manually selecting them and delete. Is there any way/action that we can create pointing to a Boolean metric which holds TRUE for delete items (with a formula) and whenever we run that action, it will delete those specific items (We can think of deleting a specific months data)Please suggest.Thanks,Ramana 

1042
R
Newly Minted Pigmenteer
A
Seasoned Pigmenteer
A_GarneriSeasoned Pigmenteer
asked in Questions & Conversations
Aggregation Cells on Tables with metrics that uses multiple Dimensions

Hello Pigment!We have some scenarios where we use multiple Metrics with different dimensions on the same table, ex: This table has Products and Month on Rows, Metrics as columns. Metrics structures below:Metric Dimensions Formula Product Demand Product, Month - Vendor Product Products.Vendor Planner Product Products.Planner We are aware that a possible solution could be adding “Month” dimension on Vendor and Planner metrics then add “[ADD CONSTANT: Month]” at the end of their formulas, this would lead us to our desired shape: However, this might not be the ideal solution; we do not need to be “calculating” Vendor and Planner every Month, for every Product, since those are properties which are not changing at all (not monthly, weekly, at least). Our apps are quite big, that is why we are trying to avoid that.There is a workaround? Also, there is a way to omit the “Total” rows/columns at all?

832
A
Seasoned Pigmenteer
R
Newly Minted Pigmenteer
Ronit_SNewly Minted Pigmenteer
asked in Questions & Conversations
Changing calendar settings

Hi,I’ve bullied an app and set up the calendar and set the start month to January. Now that everything is set up we want to change the start month to February . Is it possible?Thanks

7546
Benoit
Community Manager
J
Newly Minted Pigmenteer
Jacques d. S.Newly Minted Pigmenteer
asked in Questions & Conversations
Filter by views in a board

Hello, For our monthly reporting we would like to filter by views in the boards we have, is it possible ?For exemple, for our revenues or COGS, in a same metric we have views by clients, countries, cohorts… and we would like to have filters based on these views in our reporting boards.Thank you for your answer. Jacques

612
J
Newly Minted Pigmenteer
A
Seasoned Pigmenteer
A_GarneriSeasoned Pigmenteer
asked in Questions & Conversations
What is the maximum number of cells that a table can display?

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 your assistance.

2391
CDALMAY
D
dariousKeen Learner
asked in Questions & Conversations
Add "Month" to "Month of Year" without aggregation

Hi Pigment Community,I’m working on building a forecasting model and have encountered a challenge that I could use some help with.The core of my model is based on using the "Month of Year" dimension to allow users to input information. However, I now need to incorporate the "Month" dimension for a specific year, which I want to select using a switchover date.The issue arises when I create a new metric and add the "Month" dimension. After filtering for my designated year, the metric aggregates the total values across all columns, leading to an incorrect result. Essentially, the metric isn't giving me the precise data I need.You might wonder why I didn’t implement the "Month" dimension from the start. My goal was to minimize the work required to maintain and update the model as we transition into a new year. In my current setup, the user inputs values for the "Month of Year," and I planned to assign these values to the desired year later, based on the switchover date.My main question is:

1394
D
O
Newly Minted Pigmenteer
Olivia Van Gerven
asked in Questions & Conversations
By Modifier "-> "

Hi, I have a metric with 3 dimensions: Quarter, Products & Employee. I also have a transaction list with the following infoSale XYZ  - in Q1 24  (dimension Quarter) - Productclass A - sold by John (dimension employee) - previous product seller is Anna (dimension employee)Sale FMG - in Q1 24 - Productclass A - sold by Maria - previous product seller is John In my metric with dimension quarter, product, employee I am calling in all product sales, but I assign them to the previous product owner so something like [by: -> sale.product.previousseller]. However, in this way all sales get assigned to the last previous seller, whereas I want to assign the sale from John → Ann and the sale from Maria → John because they were at that point in time the previous seller.  How can I do this?  Thank you very much in advance  

841
CDALMAY
A
Newly Minted Pigmenteer
Antoine-2Newly Minted Pigmenteer
asked in Questions & Conversations
Merging Dimensions Across Applications in PIGMENT

Hi I would like to merge all the items from 2 dimensions of 2 distinct applications in PIGMENT into a new dimension. Is this possible, and if so, how?To give a bit of context, I have an existing application that tracks ongoing projects and those planned for the next two years (updated via an import), and I would like to create a dedicated application allowing users to submit their project requests for the next 2 to 6 years.These requests will be subject to prioritization, and not all will be carried out. Therefore, I would like to distinguish between confirmed projects and future project requests by creating 2 distinct dimensions. However, in the end, I would like to merge them into a single dimension to facilitate analysis of all projects.Thank you in advance for your help.Have a great day,Antoine

1692
A
Newly Minted Pigmenteer
P
pigment_enthusiastKeen Learner
asked in Questions & Conversations
Functionality for aggregating the data by a metric

In Pigment, Is there any way to use a metric with BY modifierI have two source metrics named as ‘Assigned’ and ‘Calendar Week’: “Assigned” with data type: Number Dimensions: Project, Role, Project Weeks “Calendar Week” with data type: Weeks(dimension list)  Dimensions: Project, Project WeeksI need to create a target metric:“Final metric”: of the data type: NumberDimensions: Project, Role, WeeksI’m trying this formula for “Final Metric” : ‘Assigned’[BY: ‘Calendar Week’]Since, Calendar Week is a metric and not a dimension list, formula is throwing error. Is there any way by which I can use the metric with modifiers?Can someone let me know if there is any suitable approach for this solution?

832
P
P
pigment_enthusiastKeen Learner
asked in Questions & Conversations
Increment the values by 1 for each column

Hi folks,I have a metric: “Start Week” of the datatype: “custom Weeks List” and using dimension “Project”. So, it has Start Week for every project. E.g. “Week 1” , “Week 27” for ABC, XYZ project respectively.In the metric: “Calendar Week” of the data type: “Weeks” List and using dimension: “Project” and “Project Weeks”, I am trying to fetch the Start Week and then increment it by 1 for every column of Project Week.I have tried this formula: 'Start Week'[ADD: 'Project Weeks']But, it is giving me the same value of “Start Week” value for every column in each project.Desired Outcome: For the 1st Project Week Column: it should give the “Start Week” value and for the next Project Week Column: (Start Week + 1) and for the next : (Start Week + 2) and so on…I have tried using SHIFT('Start Week'[ADD: 'Project Weeks'],1)but it gives Week 2, Week 28 for ABC, XYZ project respectively for every column .  SHIFT operatorSo basically, the values should be incremented by 1 for the subsequent columns.Wee

1142
Stef
Employee
A
Budding Pigmenteer
AlinaBudding Pigmenteer
asked in Questions & Conversations
Maximum cardinality exceeded when using calculations

Hi, I was trying to use Calculations and faces maximum cardinality issue. I have metrics for BoP, EoP and 2 metrics I need to add. So, the logic would be EoP = BoP + Metric 1 + Metric 2Each of them has 6 dimension, and unfortunately I can’t get rid of any dimensions.We used the logic of where BoP = EoP {select month -1] and EoP is calculated as previous month + Metric 1 + Metric 2 but we faced formula timeout recently.Maybe anyone has any ideas how it can be solved? 

1263
Matt D
Employee
S
Just Arrived
Siddhika JadhavJust Arrived
asked in Questions & Conversations
I am not able to input data in any of the metrics since it shows the below error.

 

512
Benoit
Community Manager
Natalie
Newly Minted Pigmenteer
NatalieNewly Minted Pigmenteer
asked in Questions & Conversations
Signing in to your Pigment Workspace with SSO

What is the best process for an organization to use SSO with Pigment? 

8542
Pierre
Community Manager
M
Newly Minted Pigmenteer
MikhailIvinNewly Minted Pigmenteer
asked in Questions & Conversations
Advanced Modeling Training

Hi!It would be great to create another step of the Learning Path to enable many topics not covered in the Fundamental training but present in the articles in the community, such as Variables, integrations, naming convention and etc.The next step for advanced models and enterprise cases would be of use.Could you please tell if it’s on the roadmap? Or perhaps I overlooked it and would be glad if you provide me with the link.Thanks.

4965
M
Budding Pigmenteer
M
Newly Minted Pigmenteer
Moosa MalickNewly Minted Pigmenteer
asked in Questions & Conversations
Sharing Calendar Dimensions

Hi community.Is it possible to add calendar dimensions e.g. Month from one application, as widget in another applications board view?  Cheers

1022
M
Newly Minted Pigmenteer
C
Seasoned Pigmenteer
Cedric LJSeasoned Pigmenteer
asked in Questions & Conversations
Display client ranking

Hello, I would like to display the ranking of my client (1,2,3…..) based on their actual value , how can i do it ?Thanks for your help  

631
Stef
Employee

Badge winners

  • Innovator
    IrenePhas earned the badge Innovator
  • Pigment Modeling Fundamentals Certified
    imene.mbarekhas earned the badge Pigment Modeling Fundamentals Certified
  • Pigment Like a Pro
    Gerahas earned the badge Pigment Like a Pro
  • Pigment Modeling Fundamentals Certified
    Gerahas earned the badge Pigment Modeling Fundamentals Certified
  • Chatterbox
    gablahozhas earned the badge Chatterbox
Show all badges
Terms & ConditionsCookie settings