Hi there!
I have:
Horizontal Dimension - MonthYear
Vertical Dimensions - YearSignUp, MonthYearSignUp
My Color background expression:
WORKS FINE: ColorMix1( column(columnno()), rgb(255,255,255), rgb(0,96,11))
DOES NOT WORK: if(Columnno()=1, red(), ColorMix1( column(columnno()), rgb(255,255,255), rgb(0,96,11)) )
Questions:
1) It seems that Colormix does not work in conjunction with IF, right? My desired formula is actually more complicated (i want another Colormix instead of red() )
2) Is it possible to change the representaiton of the Horizontal dimension (MonthYear)? I want 0, 1, 2, 3 etc. instead of MonthYear.
Please, help
My Measure (in case it matters):
if(ColumnNo()=1,
// Formula for the first Column
num(
count(distinct {<
First_Purchase={'1'},
>} total <[MonthYearSignUp]> OrderN)
,'# ##0')
// Formula for rest of Columns
,num(
after(total
count(distinct {<
>} OrderN)
,(YearSignUp-min(total [YearSignUp]))*12+num(month([MonthYearSignUp]))-1 // this is dynamically changes based on the number of rows with MonthYear
)
/
count(distinct {<
First_Purchase={'1'},
>} total <[MonthYearSignUp]> OrderN)
,'0%')
)
