Good afternoon!!
I need help with the calculation of quartiles 1 and 2 and I have two problems:
We have Quicksight integrated with another tool that uploads the data in 10-minute time intervals. The data I need to use is “on data change”, however, when it is automatically uploaded, something divides it in these intervals. I have no way to do intermediate data processing between my data source and Quicksight. Is there a way to process the data using SQL statements in Quicksight on the dataset I am working on?
With the data available in Quicksight, I have tested some statistical functions in calculated fields (percentile, percentildisc, percentilcoun) and comparing it with the calculation done by hand, I could see that they do not sort the data in ascending order, so the quartile calculation does not give the correct result. Is there any function you recommend?
Is there a standard function that takes into account the processing I need?
Thanks
For the first part of your question you could try using the Custom SQL query functionality in quicksight:
For the second part could you share your current calculated field that is not returning the correct data? Do you plan on showing this in a table, and if so, depending on your calculated field you could try nesting it in a Rank function. Then you can apply both to a table and sort by the rank function but hide that column from the table.
Hello @agustinmoncada94, did @duncan’s response help resolve the issue you are facing? If so, please mark his reply as the solution. Otherwise, if you can share more information related to the questions he asked then we can help guide you further. If we do not hear back from you in 3 days, we will archive this topic.