Forum Discussion
3 Mth and 12 mth average the same
My first attempt at moving averages. My problem is whether I have "-3", or "-12" its the same number. All fields are coming from the same table. Also wondering if part of the problem is there are m...
Hi,
Do you have a separate date dimension table? That would be the first thing to do. Mark this as data table, and you can use time intelligence functions. Link your cist table to the date table.
More info, check this post.
waltheed
Impactful Individual
Impactful IndividualHi,
Do you have a separate date dimension table? That would be the first thing to do. Mark this as data table, and you can use time intelligence functions. Link your cist table to the date table.
More info, check this post.
Thanks!
- waltheed
You're welcome. Glad it worked for you.