Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
This expression shows nothing in my chart:
Mod(WeekDay(Min(timestamp)) + 2.5, 7)
But these two expressions render expected values:
Mod(WeekDay(Min(timestamp)) + 2, 7)
WeekDay(Min(timestamp)) + 2.5
Why is Mod() failing in the first expression?
Also some bonus points questions: 1. Is there a way to see what the underlying error in a chart is, instead of a blank chart? 2. Is using Mod() or NumMin() just as bad as using If() in terms of chart performance?
Many Thanks,
Paul
Don't know why it doesn't work but will FMod(WeekDay(Min(timestamp)) + 2.5, 7) work? It may be because its not interpreting the first input as an integer.
or
Mod(num((WeekDay(Min(timestamp))) + 2.5, 7)
Don't know why it doesn't work but will FMod(WeekDay(Min(timestamp)) + 2.5, 7) work? It may be because its not interpreting the first input as an integer.
or
Mod(num((WeekDay(Min(timestamp))) + 2.5, 7)
FMod() works perfectly, thanks for the fast response!