Hello Team ,
I want to calculate start location of the first date and end location of the last date in same row for Period control applied. Following is the input for data.
and output is as follows
Hello @Rohit_Nikam
You can probably do this just using min/max level aware calculations and partition by the user:
Hi @duncan ,
I tried that but m getting 2 rows for every user. I want to show first start_location , last end_loaction , min start_value , max end_value for every user in single row
Hi @Rohit_Nikam ,
how are you getting these data inside QuickSight?
I think that this is very hard to obtain, I’m trying to replicate the same thing, but there are some limitation at the moment.
I’m asking how are you getting the data, cause if your source is e.g. a DB, maybe we can obtain the desired result with Custom SQL.
Andrea
Hi @andrepgn ,
This is sample data . We have similar data in our redshift database
Hi @Rohit_Nikam ,
so if you have the data in redshift, can it be a valuable solution for this use case to use a custom sql query? This is probably the easiest way to obtain what you’re aiming to.
For this specific request, you can try to use custom sql, and then you know you can have multiple datasets in the same dashboard and so on…
Andrea
Hi @Rohit_Nikam,
It’s been awhile since we last heard from you on this thread, did you have any additional questions regarding your initial post?
If we do not hear back within the next 3 business days, I’ll close out this topic.
Thank you
Hi @Rohit_Nikam,
Since we have not heard back further, I’ll go ahead and close out this topic. However, if you have any additional questions, please feel free to create a new post in the community.
Thank you