Hi:)
I am trying to generate a calculated date field called : testedDate, from a time range parameter.
I would like to be able to enable my users to generate a report based on a given time range and calculate my logic based on all the days within the given time range.
Is this possible?
Thank you
Tal
Hi @tal
do you need the time in your calculated field or would it also just work to create the calculation and add a time range filter to the visual?
BR
thank you for your response .
The solution i was thinking about was to have a calculated field that will represent the tested date , and will actually get each day in the given time range.
Based on this tested date i could calculate daily metrics such as daily spend.
Hope i was able to make my vision clear:)
1 Like
Why not restrict or filter the dataset directly to this period?
Maybe it will help if you could provide a sample with numbers?
Hi:)
If you at the attached screenshot, this is an example of what i am looking to achieve.
I would like to calculate for each tested date in the given time range, anomalies of spend for example. i don’t want to filter my data based on the given range because i would like to compare for each entity id (or any other aggregation level) what is the difference between the average spend to my tested daily average.
this means that for each tested date i am calculating avg of spend in this day and also average of spend on other days , before that day.
when i get a date as an input it is easy, cause i have a calculated field that represents this date and do all the calculations accorddingly.
here i am stuck is how do i get a range of dates and generate a calculated field that will get multiple values?
Hi @tal
how would you calculate it? maybe as a Excel sample?
BR
Sorry @ErikG , i missed your response.
Basically i am looking for the option for input of multiple days and not one specific day.
The multiple days will initiate the tested day calculated field .
and i will be able to aggregate by tested day and calculate the logic for each tested day.
i don’t know how to implement something like that using a time range.
1 Like
Hi:) checking in on this.
Do you have a suggested solution?
Thank you
Tal
Hi @tal,
Seems like you aren’t filtering your data as you want the full dataset in computing the average values that you are comparing with. You can still get dataset wide calcs in a filtered visual through the use of LAC-W calculations in PRE_FILTER mode.
Read more at Using level-aware calculations in Amazon QuickSight - Amazon QuickSight
I’m marking this as solution for now. Please feel free to post with more details if you aren’t able to make it work. In that event, post a sample analysis in Arena to make it easier for community members to help you.
Regards,
Arun Santhosh
Pr QuickSight SA
1 Like
Thanks for your response.
This does not resolve my issue so I will consider sharing a sample to make my question clearer.
1 Like