Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have Month field in dimension and in expression i am using Rand() function to get random values. now based on my selection in month i want to see the data in chart like if i choose march, then i want to see from jan to mar, if i choose may then i want to see from jan to may...
Would appreciate if anyone can help me
May be like this:
RangeSum(Above(Sum({<Month>} Rand()), 0 RowNo())) * Avg(1)
it gives error if i use in dimension, it is not taking rowno()
In dimension? The above should work as an expression
It doesnot work, it shows error in same point for rowno(), can you check if something missing
it shows only for 1 month
RangeSum(Above(Sum({<Month>} Rand()), 0 ,RowNo())) * Avg(1)
What exactly are you trying to do? I am not sure I understand the reason to use Rand() here. Can you may be provide a context?
I have a bar chart and in that i have used Month field as dimension and in expression i have written Rand(), now when i select Month as mar from a filter i want to see data from jan to mar. and i dont want to see data for the month which i chose.
How about this:
Rand() * Avg({<MonthNum = {"$(='<=' & Max(MonthNum))"}>} 1)
UPDATE: More like this:
=Sum({<Month>}Rand()*10000)* Avg({<MonthNum = {"$(='<=' & Max(MonthNum))"}, Month>} 1)
Where MonthNum is created in the script like this:
LOAD Num(Month) as MonthNum
...
Thanks Sunny, I tried a different format it works. appreciate your help