Hi there,
I want to get a column value based on the latest date.
For eg: I want to get latest value in ‘price’ column order by ‘date’ field desc. I want to refresh this data daily so that every day the visual displays the latest price based on the available latest date.
I tried with ‘last value’ and did not get the expected result. Any help is appreciated.
Hi @likhitha - I believe this possible, can you please give some sample data and expected output so that it will be easy to replicate and guide you solution.
Tagging @Biswajit_1993 as well for his feedback.
Regards - San
Hi @Sanjeeb2022 As you see in the attached screenshot, I want the output to point out the latest date that is available when the dataset is refreshed.
Thanks.
Thank you @likhitha for the details. I think you can achieve this by below steps.
Step -1: Select the graph type "Key Performance Indicator - KPI)
Step -2: In the value put the sales column and choose Max.
See the screenshot below.
Hope this will help you in solve your problem. If it is resolving your issue, please marked as solution so that it can help other community members.
Regards - Sanjeeb
hi @likhitha,
Did Sa jeeb’s solution work for you? I am marking his reply as, “Solution,” but let us know if this is not resolved. Thanks for posting your questions on the QuickSight Community Q&A Forum!
No, this is not resolved.
@Sanjeeb2022 I want to display the sales value based on the latest date.
The solution you provided just gives the max value of the sales.
Hi @likhitha - Ok, the requirement is to filter the data on the basis of max date? Please correct me If I am wrong.
Tagging @Biswajit_1993 for quick feed back on this.
Regards - Sanjeeb
That’s right. For the max date, I want to display the ‘sales’ column.
My output should only display ‘sales’ and the value for that sales.
Thanks
Ok @likhitha.
Let’s wait @Biswajit_1993 feedback as i Know he implemented same solution. or else I will do a poc from my side and update you.
Have a great week ahead.
Regards - Sanjeeb
Hi @likhitha ,
Thanks for raising your query, yes you can achieve this by using parameter in QuickSight.
Please follow some simple steps to get the desired result.
Step -1 Create one default DateTime Parameter as LatestDate.
- Go to Add menu and select Add Parameter then select DataType as DateTime, Time Granularity as Day & Default Date as Relative Date.
Then put the filter condition as Start of This Day
Step -2 Activate the parameter.
Once you created the parameter then you need to activate the parameter on the Date filter for your analysis.
For this you need to add the Date filed into the Filter menu and select the filter type as Relative Date , Time Granularity as Days then select Date & Time from a parameter and pass the parameter in this section.
PFB the picture for your understanding.
Step - 3 Testing
Then use parameter as control and do testing how the result is showing.
Please check whether this solution is work for you or not if not please revert back.
Thanks & Regards
Biswajit Dash
Thanks @Biswajit. This is awesome.
Regards - Sanjeeb