amount_usdcolumn is a computed value by the Flipside team. When working with these, always check for missing values. Checking for Null Values in amount_usd. From this query we see that there are a few dates with significant missing data. Accounting for missing data is beyond the scope of this workshop, but checking the quality and completeness of the data tables is essential to good analysis. This should be noted in our final dashboard.
order byto specify which column and
descto ensure the highest numbers are ordered at the top. As with above, we need to exclude
where amount_usd is not null. Again, set a
limit! We only need the top few results.