Unanswered questions

Is there any way to hide the boards in all blocks section even for Admins ?

 I have a metric which is by Year Dimension, and I have another metric which is by Month in the same table, i would like to have a year selection on the Page that will filter both metrics at the same time, does anyone have a solution or workaround? 

Hello,I need your help with a topic regarding data aggregation with their Parent-Child Hierarchy.In my Transactional list, I don't have any lines corresponding to the Parent value "Finance," and for "INC" type accounts, only Gross Sales returns values. However, I would like to display all accounts as shown in the attached chart of accounts:Problem: When I create my metric, the rows (Finance, Operating Income, Gross Profit, Net Income, Gross Income) are empty and do not aggregate with their children, and therefore do not allow for ratio and P&L calculations.Could you help me find a workaround?Thanks a lot

Hi, I'd like to merge my Forecast and Actual data into a single table.To do this, I created these metrics:'IsActual Metric':'Switchover date Metric':'Growth Rate Hypothesis''PREVIOUS_(Month)''FCST - Product': which should be my result. But the problem is that I get one result per Version, even though I need to have the 5-month Actual and 7-month Forecast data in the same table. Thank you very much for your help. 

Hi, I'm trying to perform a calculation in a metric that’s part of an iterative calculation. What I want to achieve is to take the value from the last non-blank month in Module A and allocate it to the latest actual month.I’ve tried using the same formula that’s applied in the I02 FY RF metric, but it’s not giving the desired result here. Interestingly, when I use the same formula in a different metric, it gives the correct value.I suspect the difference might be because this is an iterative metric and Month is the iterative dimension. Could you please suggest how I can handle this situation?  

Hello,I would like to convert the amounts in my Transactional List into euros.To do this, I created the Tab_Rate metric corresponding to the conversion rate: I also created an Amount metric, which directly reflects the amount in the Transactional List:Now, I would like to create a new metric, Amount converted to euros (target amount):Can you please tell me how to do this? I need your help.

I have a rather large transaction list (roughly 5M rows) with several dimensions.  I need to map the combination of these unique dimensions to assign my data into user managed groupings.  To do that, I need to do a 2 part calculation by first concatenated the various dimensions and then matching it to the grouped dimension.MATCH('_ Subscriber Activity'.'Account Type'.Name &"-"& '_ Subscriber Activity'.'Product Group'.Name &"-"& '_ Subscriber Activity'.'Product Subscribe Group'.Name &"-"& '_ Subscriber Activity'.'Device Sub Cohort'.Name &"-"& '_ Subscriber Activity'.'Device Type Cohort'.Name &"-"& '_ Subscriber Activity'.'Marketplace Cohort'.Name &"-"& '_ Subscriber Activity'.'Customer Subscribe Category'.Name,'_ Product Attributes'.Name) The problem is that I get an error that is: “Product Attributes: Formula timed out (> 3 minutes)”.  I’m not sure how to work around this error with a more optimized approach.  Any help will be much app

Hello everyone,I have created a Clone data in metrics set up on my application settings but when I go to the board to add the action button the Clone data in Metrics form does not appear to let me choose what i want to copy and where..Basically i can only use one preset configuration into the app settings. Am I loosing a step? I also see in the documentation that is clearly possibile but I can’t manage to set it up;Thanks in advance, community, for your help! :) 

We are experiencing that if we save a copy of a Google Sheet with Pigment Connector connections, we lose the connections in the copied sheet.  We just want to double-check if there's a way to maintain connections in a copied sheet or is it perhaps on the radar to be supported in the future?  Thank you!

I am trying to export pigment data to PowerBI following the guided steps available on community, but I get an error “404 id not found”. Does anyone know what I could be missing in the setup? I used payload functionality to generate ID for metrics. 

Hi!Could you please elaborate on what “preferred” means here? If dimensions are not in the preferred selection, will they be left out? Thanks,Louie  

Hi All,Does anyone know how “Auto-Input Using Default Page Items” this works?There is metric with data type dimension. Same dimension is on the page selectors. The value of the page selector should also be the value in this metric

My headcount planning app currently uploads a headcount report on a monthly basis and the forecast basically rolls forward after every new month and the only way I can compare changes over months is to take a snapshot and change the switchover month.How should I approach making this update since it seems like I would have to rework the entire application and add a version to every metric? My current thought is that a budget version is tied to a specific months load, so I can do a mapping for load month → version but does that work?Example:Current monthly data by load monthExpected Result if I want to use June load month for BoD Version. The data from Jul onwards would only use data up to the June load and not use anything beyond that.  Any ideas would be appreciated. Thank you!

Hi,I’m trying to set up an iterative calculation to use the PREVIOUSOF function to address a circular reference. However, in my application the setup doesn’t appear the same as described in the article “Iterative Calculations Across Multiple Blocks Using PREVIOUSOF.”Instead of showing options for Cycle Name, Iteration Dimension, and Metrics That Can Reference Each Other (as mentioned in the article), it only gives me the option to add an iterative calculation and asks me to select the Base Metric and Allowed Metric. 

Hi All,Although PREVIOUSBASE() is replaced by PREVIOUSOF(), why am I unable to see that update in my workspace?I am only able to use PREVIOUSBASE and it keeps throwing me circular reference error.According to this documentation - This should be new interface where we don’t need to select a base metric Instead, while setting up iterative calculation to use PREVIOUSOF, this is my current interface Can someone please tell me how I can start using the new update?