Forum Discussion
Helper IAutomatic calculation
Hi Tameismael,
Following this instruction:
1. You can create a new parameter from Mordeling /New parameter.
2. Use data type with whole number, minimum = 0, maximum = the number week you expect to see.3. Then multiply your current formula with that parameter.
4. Create a slicer or filter above with that parameterYou can download the sample file here for your case
https://drive.google.com/drive/folders/1qZh8MtEuSvm9F-kERIX3AZ12wxWxpFoU?usp=sharingYes, if your data have a date column for each record, so you can use this formula to calculate the week up to today, Then you can model the relationship between this new column with Parameter above
New column in your data table:
WeekNoUpToToday = WEEKNUM(TODAY()) - WEEKNUM(DateOfRecord)
Helper ICan you please provide a real example on that so the idea will be clear.
thank you
Resolver IHi Tameismael,
Following this instruction:
1. You can create a new parameter from Mordeling /New parameter.
2. Use data type with whole number, minimum = 0, maximum = the number week you expect to see.
3. Then multiply your current formula with that parameter.
4. Create a slicer or filter above with that parameter
You can download the sample file here for your case
https://drive.google.com/drive/folders/1qZh8MtEuSvm9F-kERIX3AZ12wxWxpFoU?usp=sharing
- tameismael
Thank you very much I do appreciate that , I will be doing those steps.
many thanks,
- tameismael
thank you again I have done it and it's successful. But is there is a way to add to the formula the Today function so it will bring my the number of contacts reached up to date ??
thanks
- linh091
Yes, if your data have a date column for each record, so you can use this formula to calculate the week up to today, Then you can model the relationship between this new column with Parameter above
New column in your data table:
WeekNoUpToToday = WEEKNUM(TODAY()) - WEEKNUM(DateOfRecord)