Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello , help with a code for tornado chart , its giving me negatives for one gender
if([GENDER]='F',
Num(count(if(YEAR([TRANSACTION_DATE])=vCY AND COUNTRY='INDIA', ID))*-1),
Num(count(if(YEAR([TRANSACTION_DATE])=vCY AND COUNTRY='INDIA', ID)))
)
my graph is this
In addition , how do i color with own colors for F and M , the below is the code am using but its not workingif([GENDER]='F', '#000000','#C51633')
Try this
if([GENDER]='F',
Num(count(if(YEAR([TRANSACTION_DATE])=vCY AND COUNTRY='INDIA', ID))),
Num(count(if(YEAR([TRANSACTION_DATE])=vCY AND COUNTRY='INDIA', ID)))
For gender color
if([GENDER]='F', RGB(0, 0, 0), RGB(197, 22, 51))
)