Skip to main content

Hello Everyone, 

 

I want create a revenue metric. I Create all the dimensions and transaction list. 

When I add a formula there is no problem of dimension, but the value are only in January month. But in my transaction list the Dimension Month is present. I dont understand why all the values are imported in only one month. 

Here is my formula ( 'Sales History Unit'.unit uBy Sum : 'Sales History Unit'.month,  'Sales History Unit'.Customer,  'Sales History Unit'.'Product Group'] ) 

 

Thanks a lot 

Hello Sokhna,

Can you send us an anonymized screenshot of your transaction list showing the columns you call up in your formula? I suspect some elements are missing on the Customer and Product Group dimensions in your transaction list.

I would pick one transaction line (that isn’t in January) and find the exact location it should be in your metric. Make sure that line has all the dimensions populated and of the type Dimension (verses Text).  Usually the problem presents itself then. My only other question is use of ‘Month’ verses ‘Month of Year’. 
Although as stated above sharing what your transaction list has in it would be helpful.

Hello Guys, the problem is resolved. It was a problem with the transaction list thanks for your help. 

 

I have an other question Im starting the “SECTION 2 | DATA HUB → STEP-BY-STEP BUILD” in the Pro Training. 

When i put this in the formula playground. I have noting. Can you help me ? 

 

Could you please show us the dimension Versions and its properties?

 

I suspect you’re not using the right property dimension.

(Month.'End Date' > Version.'Last Actuals Month'.'End Date' AND Month.'End Date' <= Version.'Window End Month'.'End Date')
currentvalue=True]

The name of the property you’re showing is Last Actuals Monthh.



 

Yess your right, It works now thanks a lot. :) 

Reply


Ask your question here!

Terms & ConditionsCookie settings