-
Find missing records from 2 tables
Excuse me for not providing a screenshot as the data is sensitive but I have 2 sales order details datasets: - A (sales orders for the year 2024 - 1.7M rows) - B (all the historical sales order for all years - 14M rows) - I want to see which orders are in A but not in B. It's pretty straight forward to do a LEFT JOIN, A =…
-
Appending a dataset said "Data updated successfully" but no rows was added?
I was appending rows on my existing dataset by going to Data → pick that Dataset → Settings tab → Details (drag my other dataset in), update mode: Append) → but in the History Tab I saw no rows was added: P/S: I was appending just fine yesterday, so not sure what happened
-
Month filter not working on all cards in an App?
I have 2 card visuals for my app right now. Card #1use dataset 1 (have a month and a year column). Card #2 use dataset 2 (which has a date column, formatted as 'yyyy-mm-dd' And so my goal is to select a Month (say August), and both card #1 and #2 would show the data only for August. But if I create a "Dropdown Selector"…
-
Beastmode to return current month value? And what's the best card type to show the variance?
My dataset has these columns: year (int), month (int), target, actual I created a BeastMode to return the current month (Aug) value for both target & actual, but instead of showing an actual value for Aug, it shows 0. CASE WHEN month = MONTH(CURRENT_DATE()) THEN target ELSE '0' END Since I want to see the variance for…
-
Data Labels disappear?
I have a line chart with category labels next to each line, and I have a drill path to this line chart as well. But the labels kept disappearing (the lines were still there) after I returned from the dill path. I don't prefer legend, but I'm not sure how to fix this.
