I am very new to Amazon quicksight.
I have imported my data into Quicksight as an Athena database.
However I have to use two tables. But I do no want to join them.
Table 1 has the Timestamps, ShopID, and some more columns. This data is around for 1 year. For each day, there are almost 3000 Unique Id. but they are repeated, based on the fact that which product they sold.
Table 2 contains the overall Unique IDs for a particular day with the information on their location.
Now I want to calculate Daily active shops using the below formula:
No. of Distinctive IDs *(from table one)/*no. of total shops (from Table 2)
Hi @priyagoel - Welcome to AWS QuickSight community and thanks for posting the question. When you are deriving the details from two tables in QS, you have to join the tables. In this case you can create a view in athena and do the joins and do the calculation and bring the view details to QuickSight if you do not want to join at QuickSight side.
Yeah… this is a great idea. I can query any data in Athena and do any calculations, however, I do not understand how to bring this queried data to Quicksight which is dynamic (my data would be updated daily) and would have multiple queried results.
Hi @priyagoel - You can use custom sql and bring the data from athena and write the logic completely in custom sql. Please refer the documentation share by Deep.