-
1. Re: Previous Value based on From and To date
Joe Oppelt
Jan 14, 2019 8:45 AM
Need more info.
A sample workbook would really help. Then you can point to specifics and explain what you expect to see under various conditions.
-
-
3. Re: Previous Value based on From and To date
You posted a twb, but that's just the workbook (it doesn't include the data). Can you repost as a packaged workbook (twbx)?
-
4. Re: Previous Value based on From and To date
Joe Oppelt
Jan 14, 2019 9:42 AM
Need to do FILE->EXPORT PACKAGED WORKBOOK
-
-
-
7. Re: Previous Value based on From and To date
Joe Oppelt
Jan 14, 2019 9:45 AM
Ken -- I'm kind of under the gun today. Can you run with this one?
-
8. Re: Previous Value based on From and To date
I don't quite understand. Can I assume that the current KPIs are filtered by the selected from and to dates? If so, then those can be adjusted, correct? When they are adjusted, what previous time period are you looking for?
-
9. Re: Previous Value based on From and To date
yes they are. here is a better definition; Previous period value - This value will display the previous period value equal to the duration of the current date period specified by the user. For example, if the user selects a period of 45 days, this element will display the value for the preceding 45 day period.
-
10. Re: Previous Value based on From and To date
OK, next question. Your dates are parameters. It doesn't look like you've done anything with them. So, can I assume you want to integrate those into the existing KPIs as well?
Also, there are a number of KPIs here. I'd suggest we pick one to work with, make that work, then you can apply the same logic to the others. Can you choose one you'd like to use as an example? -
-
-
13. Re: Previous Value based on From and To date
would it be better to use the dates as filters as opposed to parameters?
-
14. Re: Previous Value based on From and To date
Not necessarily. But are you hoping to apply those as filters to the existing KPIs?