2 réponses
- Le plus récent
- Le plus de votes
- La plupart des commentaires
1
- Create a dataset to connect your Data Source I used a simple excel spreadsheet with 3 columns "date","metric","value"
Be sure to configure the 'date' column so it correctly parses your data source date formats The help on "Preparing Datasets" has advice on this Make sure the "date" column is of "Date" type (it looks like a calendar icon)
- Create an Analysis from your dataset
- Create a calculated field (in either the analysis or the dataset)
For analysis click "Add" , "Add calculated field" The calculated field should produce "miles driven" since the previous record. I used the following formula
max(value) - lag(max(value),[date ASC],1)
The documentation for calculated fields has many examples of this. The above produces the difference between the maximum of the current time period's miles minus the maximum of the previous time periods miles.
I called my field "driven"
- Add (or reuse the default) visual.
Select the chart wanted (I clicked on a column chart) - Drag "date" and "driven" onto the visual
- Using the Field Well, select "date" and change the agragation to whatever period you want, I chose "By Month"
The result is a column graph of miles driven per month
répondu il y a 2 ans
0
Did https://docs.aws.amazon.com/quicksight/latest/user/periodToDateAvg-function.html
Worked? I'm having a similar problem
répondu il y a un an
Contenus pertinents
- demandé il y a un an
- demandé il y a un an
- demandé il y a 2 mois
- AWS OFFICIELA mis à jour il y a un an
- AWS OFFICIELA mis à jour il y a un an
Hi @daldei,
Thank you for the amazing and fantastic description. It really helped us.
One question though: Is there any way we can get the difference of particular time in the past (like 30 days)? Is there any quick way to basically get the value 30 days ago that we can assign as calculated field?
Again, thank you for your help!
Unfortunately, this solution does not help us for lag of 30 day. Any idea how we can do it? @daldei. Should we use https://docs.aws.amazon.com/quicksight/latest/user/periodToDateAvg-function.html