-
1. Re: Previous Value based on From and To date
Joe OppeltJan 14, 2019 8:45 AM (in response to Tablo.0)
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.
-
2. Re: Previous Value based on From and To date
Tablo.0 Jan 14, 2019 9:07 AM (in response to Joe Oppelt)i posted a sample as requested.
-
3. Re: Previous Value based on From and To date
Ken FlerlageJan 14, 2019 9:40 AM (in response to Tablo.0)
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 OppeltJan 14, 2019 9:42 AM (in response to Tablo.0)
Need to do FILE->EXPORT PACKAGED WORKBOOK
-
5. Re: Previous Value based on From and To date
Tablo.0 Jan 14, 2019 9:43 AM (in response to Ken Flerlage)i reattached the .twbx thanks.
-
6. Re: Previous Value based on From and To date
Tablo.0 Jan 14, 2019 9:44 AM (in response to Joe Oppelt)done, thanks.
-
7. Re: Previous Value based on From and To date
Joe OppeltJan 14, 2019 9:45 AM (in response to Ken Flerlage)
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
Ken FlerlageJan 14, 2019 10:02 AM (in response to Tablo.0)
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
Tablo.0 Jan 14, 2019 10:08 AM (in response to Ken Flerlage)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
Ken FlerlageJan 14, 2019 10:12 AM (in response to Tablo.0)
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? -
11. Re: Previous Value based on From and To date
Ken FlerlageJan 14, 2019 10:12 AM (in response to Joe Oppelt)
I'll try!!
-
12. Re: Previous Value based on From and To date
Tablo.0 Jan 14, 2019 10:14 AM (in response to Ken Flerlage)lets use time to fill, thank you so much.
-
13. Re: Previous Value based on From and To date
Tablo.0 Jan 14, 2019 10:16 AM (in response to Ken Flerlage)would it be better to use the dates as filters as opposed to parameters?
-
14. Re: Previous Value based on From and To date
Ken FlerlageJan 14, 2019 10:23 AM (in response to Tablo.0)
Not necessarily. But are you hoping to apply those as filters to the existing KPIs?