Trying to have a Day difference between the Launch date and First Receive as well as Launch Date and First Ship. keep getting an incorrect calculation?
1 Like
Hi @nellsarg - Can you please provide the logic of calculated field so that it will help in understanding the issue.
Tagging QuickSight experts as well.
@Max @David_Wong @Kristin @Biswajit_1993 @Thomas @Karthik_Tharmarajan @Bhasi_Mehta @Tatyana_Yakushev
Regards -San
Hi @Sanjeeb2022 here us the calculation. I just want to know the difference in days between Launch Date and First Ship Date
1 Like
Hi @nellsarg : Can you please give the format for those 2 fields so that I will try to replicate at my end.
Regards - San
1 Like
Sorry what do you mean by format ?
1 Like
Hi @nellsarg - The formula looks good to me. To ensure the report is work, can we create a simple tabular report and test it. Is there any conditions applied in this report.
Some cases the formula worked as expected, some cases it is not. I am not sure whether you have any other logic implemented or not. Please create a simple tabular report and see whether difference date giving correct result or not.
Also in parallel, please raise a case to AWS so that they can see the details in screen sharing. This will help in fixing the issue faster also. To raise a ticket to AWS, please follow the link - Creating support cases and case management - AWS Support
If you do not have permission, please request your aws admin to help you.
Also tagging QuickSight experts for their feedback.
@Max @David_Wong @thomask @Thomas @Bhasi_Mehta @apjvinod @Kristin @Tatyana_Yakushev @Biswajit_1993
Regards - San
@Sanjeeb2022
Here is the simple tabular form. let me know if you need anything else. Will do on creating a case.
@Sanjeeb2022 I do not have permissions , how would I know who the AWS admin is ? Again thank you for your help.
1 Like
Hi @nellsarg - The person who provided you the access is the first point of contact 
In parallel, i will try to spend some time to replicate this issue at my end as well.
Regards - San
1 Like
Hi @nellsarg! Based on your latest screenshot it looks like day difference between Launch date and First Ship is working as expected. Are you having issue with day difference between Launch Date and First Receive? If that is the case can you send screenshot of calculation used for day difference between Launch Date and First Receive and also add this calculation as a column to your table chart and share a screenshot of that as well.
Regards,
Karthik
1 Like
We have not heard back from you regarding your question. We would still like to help. If we do not hear back in the next 7 days, we will archive the question.
1 Like
Hello Team, I was able to solve the issue though SQL for the tables above and created a new column.
1 Like