1 2 Previous Next 22 Replies Latest reply on Jan 21, 2019 6:47 AM by Ken Flerlage

Previous Value based on From and To date

Tablo.0 Jan 14, 2019 9:43 AM

Hello guys,

i need a little help here, i have about 8 different KPI's on my dashbaord, i want to display previous values for all these kpi's based on the interval of the FROM and TO date parameter selected by the user, i already started by creating a previous date- DATEDIFF('day', [From Date], [To Date]) , i need help going further.

Message was edited by: afam here is a sample work book, i want the previous value to display based on the dates selected.

sample.twbx 96.3 KB

1. Re: Previous Value based on From and To date

Joe Oppelt Jan 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.
Like Show 0 Likes(0)

Actions
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.
Like Show 0 Likes(0)

Actions
3. Re: Previous Value based on From and To date

Ken Flerlage Jan 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)?
Like Show 0 Likes(0)

Actions
4. Re: Previous Value based on From and To date

Joe Oppelt Jan 14, 2019 9:42 AM (in response to Tablo.0)

Need to do FILE->EXPORT PACKAGED WORKBOOK
Like Show 0 Likes(0)

Actions
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.
Like Show 0 Likes(0)

Actions
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.
Like Show 0 Likes(0)

Actions
7. Re: Previous Value based on From and To date

Joe Oppelt Jan 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?
Like Show 0 Likes(0)

Actions
8. Re: Previous Value based on From and To date

Ken Flerlage Jan 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?
Like Show 0 Likes(0)

Actions
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.
Like Show 0 Likes(0)

Actions
10. Re: Previous Value based on From and To date

Ken Flerlage Jan 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?
Like Show 0 Likes(0)

Actions
11. Re: Previous Value based on From and To date

Ken Flerlage Jan 14, 2019 10:12 AM (in response to Joe Oppelt)

I'll try!!
Like Show 0 Likes(0)

Actions
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.
Like Show 0 Likes(0)

Actions
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?
Like Show 0 Likes(0)

Actions
14. Re: Previous Value based on From and To date

Ken Flerlage Jan 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?
Like Show 0 Likes(0)

Actions

1 2 Previous Next

Go to original post

Tableau Community Forums

Previous Value based on From and To date

1. Re: Previous Value based on From and To date

2. Re: Previous Value based on From and To date

3. Re: Previous Value based on From and To date

4. Re: Previous Value based on From and To date

5. Re: Previous Value based on From and To date

6. Re: Previous Value based on From and To date

7. Re: Previous Value based on From and To date

8. Re: Previous Value based on From and To date

9. Re: Previous Value based on From and To date

10. Re: Previous Value based on From and To date

11. Re: Previous Value based on From and To date

12. Re: Previous Value based on From and To date

13. Re: Previous Value based on From and To date

14. Re: Previous Value based on From and To date

Sign In or
Create your Account

Actions

More Like This

Incoming Links

Sign In or Create your Account

Sign In or
Create your Account