Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Apart from hard numbers (which works), I can't use dynamic dimension reference line. I tried using variables or formulas - it does not work.
Is it a bug or a feature?
Thank you!
Hi,
It should allow you to write a function for a value.
What expression you have used which didn't work?
hi there!
this is the Dimension formula:
Number of Orders by AOV
=AGGR( Class( [AvgOrderValue], 1500), OrderN)
This is the formula for Dimension reference:
Total Average Order Value
=SUM( {< Cal={'CP'} >} Sales)
/
Count( DISTINCT {< Cal={'CP'} >} OrderN)
Figured it out myself:
=Floor( [AvgOrderValue], 1500 )