Skip to main content

Explore the Community

Connect with other users, discuss how you're using Pigment, and get inspired

1057 Topics
Ola
Master Author
OlaMaster Author
asked in Questions & Conversations
Link to a prefiltered board

When you apply a filter to a board you can see that the url is updated to include the current filter. The problem is just that the url only includes a GUID. Is there any way to find these guids in Pigment? For example when filtering on a specific employee in my employee dimension I can see that []=df7ce50d-304b-472e-a8e0-f448d960e8de is added to the url, and I would expect that each employee is related to a unique guid, so question is just how to get from dimension value to a guid. My use case is that I am having a grid view with a list of employees. For each employee I would like to link to another board with details about each employee and I would like this board to automatically be prefiltered based on which row I clicked on the first board. 

1625
Andrea
Employee
G
Author
Gali BaramAuthor
asked in Questions & Conversations
Dates exported incorrectly through gsheet connector

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? 

731
D
Apprentice Helper
Spandan98
Master Author
Spandan98Master Author
asked in Questions & Conversations
Concatenate Dimension Type Metrics - Convert Dimension type metrics to text type

Hello Pigment Community,I need help converting dimension-type metrics into text and concatenating them into another metric.For example, in the screenshot I provided, I want the "Concat" metric for Row A to display "Asste1Con1".How can I achieve this? Any guidance would be greatly appreciated.Thanks in advance!  

2192
Min Li Bright Point
Master Helper
F
Apprentice Author
FPA
asked in Questions & Conversations
syncing context pages across multiple tabs

Hi, we have users that work on multiple boards at the same time that share common pages selectors.The challenge here is that when we switch from one dimension element to another on the page selector in one tab, we need to go through each other tab to adjust the page to the newly selected element. As people here work with like 10 tabs in parallel, that s a lot of clicks to update boards and have them being synced.Do you people encounter those kind of usage / challenge ?Are there ways to make this work in pigment and how if you experimented it ?I was thinking maybe using a custom user defined variable ?

341
W
Employee
M
Apprentice Author
mmcgrathApprentice Author
asked in Questions & Conversations
Remove a dimension from a chart while maintaining the calculated item from that dimension

Hello, I have created a calculated item cumulating totals by week for a month. I would like to show the cumulative total of each week on a chart, without showing that week’s individual total. In the example below, I would like to remove the lighter blue “Jan 25” value, and keep the calculated item - the cumulative total by week. Is there a way I can do this?  Thank you!   

902
M
Apprentice Author
G
Author
geoff_chovazAuthor
asked in Questions & Conversations
Unshare block

Is there a way to unshare a block if it hasn’t been used yet? I accidentally shared a block I didn’t want to, and in the block settings->library the share toggle is greyed out. It says it’s being used somewhere else, but also says “Not Used” beside it. 

733
Min Li Bright Point
Master Helper
Misbah
Master Trendsetter
MisbahMaster Trendsetter
asked in Questions & Conversations
Dynamic Variable not Updated Page Selectors

Is there a bug in Dynamic variable?I have a metric with Year format and This year populates the actual months. When I apply this variable it doesn’t update variable in page selectors instantaneously. Instead I have to wait for a minute or two to see it get applied Or we need to refresh the browser url or application in order for it to make work. Is this the intended behaviour or Am I missing anything?Appreciate your responses!  Thanks,Misbah  

2654
Hugo Delaby
Employee
Thu Mai
Master Trendsetter
Thu MaiMaster Trendsetter
asked in Questions & Conversations
Ability to add multiple metrics with same dimensions at the same time

Hi Pigmenteers 🤗I have an input table with 10 input metrics (same dimensions, serve the same purpose). I know how to create them 1 by 1 directly from the table (more convenient), but I’m curious whether there is a way in Pigment we can create them all at the same time? 🤔

2353
Sharon Conroy
Wallflower
M
Author
MohanAuthor
asked in Questions & Conversations
Extract Day from a date in text format

Hello,I have a Date field called “Delivery Date” (Ex : 10/06/2024). From here, I want to extract the day of the week in text format (Example :10/06/2024 is “Monday”) and my calculated field should show similar to the example here. I tried WEEKDAY(‘Delivery Date’) and it returns day of the week but in number format and I tried again TEXT(WEEKDAY(‘Delivery date”), again it does not work. How to convert weekday into Text format like Mon,Tue,etc…? thanksMohan

3314
Sharon Conroy
Wallflower
C
Apprentice Author
Charlotte BApprentice Author
asked in Questions & Conversations
New application

I can find the blue buttom “New application”

871
Min Li Bright Point
Master Helper
I
Apprentice Author
Idris BUIApprentice Author
asked in Questions & Conversations
Pre-fill item creation form with filters

Hello everyone, when creating a new item in a P&L, is it possible to pre-fill the item creation form with the filters applied on the page ? (for instance Entity / Current budget phase)

431
oliverlee
Master Helper
Thu Mai
Master Trendsetter
Thu MaiMaster Trendsetter
asked in Questions & Conversations
Sparse Engine concept

Hi Pigmenteers!While I’m taking Pigment trainings and explore my personal application, I figure out that there is no information about the size of my application or total number of cells, etc.. and the reason behind is that Pigment is a sparse engine.Therefore, can you help explain to me more about the concept of sparse engine - what is a sparse engine, how does it actually work and what is the benefit compared to non-sparse engine?

3355
Thu Mai
Master Trendsetter
A
Master Trendsetter
AdelgoMaster Trendsetter
asked in Questions & Conversations
Widget Text Format

Hello,Is it possible to change the format of a text Widget ? → Background color→ Text Size→ Text Color→ Center the text in the boxIf not, when do you plan to develop this feature ? ThanksAdèle

1772
Sharon Conroy
Wallflower
abhilashsawla
Master Author
abhilashsawlaMaster Author
asked in Questions & Conversations
How to turn off Share Toggle in Scenarios

Hi, Please let us know how to turn of Shared Scenarios. 

19311
Sharon Conroy
Wallflower
Trever Leavenworth
Master Trendsetter
Trever LeavenworthMaster Trendsetter
asked in Questions & Conversations
Modifiers not applying as expected

Hello! I’m attempting to aggregate my metrics into a full P&L with actual and forecast views. I have data coming from a Shared_IS_Actuals dimension, several Revenue and COGS dimensions already mapped, a Shared_WF_Plan dimension, and a Shared_Opex_Plan dimension. I’ve been able thus far to successfully have Actuals for all IS accounts pull in, and have Revenue, COGS, and WF (payroll, benefits, taxes) appear in a single metric. However, when I try to add my Shared_Opex_Plan data using the formula below, my Actuals stay, my revenue and cogs disappear, my WF_Plan stays, and my Opex_Plan disappears, leaving me with only the WF_Plan.  It’s like the first by modifier to map the WF_Plan to the CoA is applying to everything? What am I missing?  

2023
Sharon Conroy
Wallflower
Y
Master Author
YaejisMaster Author
asked in Questions & Conversations
Average If

Hi! Can you please help me to find average amount if the end of week month is same? Thank you!  

572
Y
Master Author
Y
Master Author
YaejisMaster Author
asked in Questions & Conversations
Week # of the Year

Hi!  I am trying to setup my report table to show Week # of the Year. I assume Week # needs to be created in the Week Dimension. Could you help me with the formula? I would like Monday-based weeks.  ​​​​ My final goal is to add Week # before Week property in the table.   ExampleThank you!

886
Y
Master Author
E
Master Author
ElodieMaster Author
asked in Questions & Conversations
Conditional formatting based on previous month

Hi everyone!I am trying to add a conditional formatting in my headcount metric in order to highlight when the number of employees increases or decreases from month to month. I cannot find any option in the conditional formatting that allows me to do so... Could you please help me finding the best solution if anyone has already faced this issue? 🤗Thanks!

2975
Sharon Conroy
Wallflower
Lehtohen
Master Trendsetter
LehtohenMaster Trendsetter
asked in Questions & Conversations
YTD Calculations Wrong when Showing Values as %

Hello Community, I am struggling with YTD summaries for %-values. In image 1 I have lines for Revenue and Costs and then I have added metric “Costs” for a second time and I am showing the value as % of Revenue. Image 1When I add YTD calculations (Image 2), I have an issue that also the “% of Revenue (Costs)” seems to be cumulating when in fact it should be always calculated as Costs/Revenue. This means that for February YTD (ACT) shows -2.20 % (= -1.30 % + -0.90 %) instead of the calculated values, which should be -1.11 % (= -4 664 / 419 306). Image 2Is it possible to keep the YTD calculations for other metrics, but use a “formula”-calculation for the %-metrics? In case it is any help, here is also a image of how I have pivoted the data. Image 3 

2292
Sharon Conroy
Wallflower
agnar
Wallflower
agnarWallflower
asked in Questions & Conversations
Change formatting of all rows in tables

In a table, the row headings (the pivoted fields that you can view either in Tabular or Tree layout) are by default formatted with dark grey font on a light grey background. But if I want it to make it *pop* I can’t think of other way than to go row-by-row and go through the menu:Is there a better way?

2524
Sharon Conroy
Wallflower
I
Wallflower
Ivan SenkinWallflower
asked in Questions & Conversations
Filter timescale by day and month in one grid

Hi community! I need to filter grid in board by days and month. I have a boolean metric “Show days?” and when it is TRUE I want to see in grid only days, when its FALSE I want to see only months. How can I do it?

2316
Sharon Conroy
Wallflower
Spandan98
Master Author
Spandan98Master Author
asked in Questions & Conversations
Dynamic selection of time period and aggregating data based on that.

Hello Pigment Community,I want to dynamically aggregate my data based on the selected time period—whether by month, quarter, or year—using a Boolean metric.Expected Behavior:If Month is selected (TRUE), the data should display only monthly values. If Quarter is selected (TRUE), the data should aggregate and display only quarterly totals. If Year is selected (TRUE), the data should aggregate at only the yearly level.How can I achieve this functionality efficiently? Any guidance would be appreciated!Thanks in advance! 😊

1582
oliverlee
Master Helper
A
Master Trendsetter
AdelgoMaster Trendsetter
asked in Questions & Conversations
Block Scenarios for a business contributor

Hello,I know it is possible to block a scenario, but when it is blocked, this apply for all users.Is it possible to block a scenario for a contributor, but not for an admin ? If not, when do you plan to develop this feature ?ThanksAdèle

3342
Sharon Conroy
Wallflower
M
Apprentice Author
msoussApprentice Author
asked in Questions & Conversations
Select Total Aggregator

Hello, I have a metric “MD02 - Quel macro composant ?” which displays elements from the list “macro composant” and its total. The dimensions are “Composants” and “macro composants”.  I also have a second metric where I want to display the total with the only dimension “Composants” :  Do you know which formula I must use in this second metric please ?Thank you very much !

692
M
Apprentice Author
V
Master Author
venitiavMaster Author
asked in Questions & Conversations
KPI with no value = 0

Hello,I have a KPI on the headcount planning board for budget owners showing the number of open positions. When there is no open positions, i would like the metric to show 0 instead of “nothing to display”. I tried putting a ifblank is my formula but i have an error message saying it is taking too long to calculate. Is there any way to show 0 ? ThanksVenitia

363
V
Master Author

Badge winners

  • Read and Interpret Formulas Certified
    Terry Archsmithhas earned the badge Read and Interpret Formulas Certified
  • Read and Interpret Formulas Certified
    Jad Fhas earned the badge Read and Interpret Formulas Certified
  • Innovator
    Avronhas earned the badge Innovator
  • Pigment Modeling Fundamentals Certified
    Ashishpradhanhas earned the badge Pigment Modeling Fundamentals Certified
  • Pigment Like a Pro
    Ashishpradhanhas earned the badge Pigment Like a Pro
Show all badges
Terms & ConditionsCookie settings