-
30, 60, 90 Day Variance Calculation
UPDATE: I have this code, but it isn't doint what I need/want CASE WHEN MONTH(`Date`) = 1 THEN SUM(CASE WHEN MONTH(`Date`) = 2 THEN `Revenue` ELSE 0 END)END What I'm trying to do is say, Ok when the Date is January, grab Feb Revenue and Sum that I also tried this but it produced nothing: (CASE WHEN…
-
Convert datatype in a BeastMode
I have data coming in from a sql table, and I cannot change the datatype of it at the source. I'm trying to join on the columns but it won't join on certain rows of data b/c One column is varchar25 and the other is nchar10 from the SQL Server side it comes from. They are already string, so when I use the Magic Tile to…
-
Coalesce for a missing month?
I can't seem to get a magic to work, nor can I seem to get a beast mode to work. I am sorting data by month. If though, my data does not have data for May (5) then I want there to be a row for May, even if there isn't data. Somewhat obviously, a case statement wont work because again, when there is no data, then no row.…
-
Query code or Documentation for Domo Brick connection to Domo Magic Dataset
Can anyone share the piece of code you need or a document where I can find how to connect my domo data set to a domo brick? It's kinda frustrating as heck to see this documentation on how awesome the Domo bricks are, but nowhere does it tell you how to actually connect a dataset to it.
-
How do I find the dataset alias?
Learning on the fly for DDX, and I can't even seem to understand how to find the dataset alias? Nor can I find documenation.
-
One text box for multiple text cards?
I may be coming at this wrong. I tried to concat but on occasion a zip is missing or something like that. I think I want to use a notebook card somehow, but my brain is blocking me from thinking outside the box. How would you get this data in multiple text cards, into one?
