-
De-duplicate one column while summing up another
Hi, Context: our ticketing dataset consists of barcodes and their relevant fields (such as redemption date, issuance date, price etc.) To figure out the number of unique tickets redeemed for a day, we use a count distinct formula for the barcodes to eliminate "re-entries" - the only way to identify re-entries right now is…
-
Filter for blanks in Sumo Card - Sanity Check Data Sources
I want to be able to quickly sanity check some of my datasets by filtering for blank dates, for example. I haven't figured out how to do it yet, and don't know if it's possible. Please let me know if it is! If it isn't, I strongly suggest this capability to be included in the Sumo card functions. Thanks!
-
X Axis Interval - hourly
Hi everyone, Context: This graph aims to show the number of tickets sold for our business at each hour of the current day. The data updates every 10 minutes. There is data associated with every minute of the day. Problem: During the first couple of hours of the day, even though I have the "Card Date Range" set to "Today"…
