Parameters/Filters to select two dates to compare

jorefice

I have a situation where we are creating a snapshot of a dataset and want to perform two types of comparisons:

1. By default, compare the latest snapshot to the previous snapshot
2. Allow for the consumers of the cards to choose the two date fields to compare

Here is an example of the snapshot data (simplified):

Snapshot Date	Value
9/15/2019	1
9/15/2019	1
9/15/2019	1
9/20/2019	1
9/20/2019	1
9/20/2019	1
9/25/2019	1
9/25/2019	1
9/25/2019	1
9/30/2019	1
9/30/2019	1
9/30/2019	1

 

Does anyone know a way to create parameter type filters for the two snapshot dates in a visual which will allow us to calculate and compare the dates chosen? Also, I would need a way to set the default to the latest value as the defaults?

 

Thanks,

 

Jim

ST_Superman

How many days of data do you need to be able to compare to?  There are a few approaches here.  Do you always want to look at a set group of dates to compare to?  For example, you always want to compare the value from one snapshot date with the previous date, with the value from 30 days ago, the value from 90 days ago, and the value from 1 year ago?  

 

If you truly need it to be dynamic, meaning that you have to be able to select the data from any date, and then compare that with the data from any other date then I think the solution becomes much more complicated.