Comments
-
Hi @meekey you’ll want to use a lag function to get the last three values. Typically I use this when doing a rolling average like you’re needing. I’ve done a write up on rolling average and lag functions here: https://dojo.domo.com/main/discussion/52679/domo-ideas-conference-beast-modes-rolling-averages window functions…
-
Whatever username and Password you use the data you’re able to pull it will be restricted based on that username and password. So yes you will likely need an admin level account to get all of the data out of day force
-
You’d need to incorporate a calendar dimension table in an ETL. However because magic ETL doesn’t support conditional joins it gets a little messy. You would need to add a constant to both a Calendar data set and your actual data set and Collett join column and set it to a value of one. Then you would join your calendar…
-
Currently there isn’t a way to have Domo do a segment in this way easily. One hack would be to duplicate your dataset and have an extra column to “filter” on which just has the value you want to highlight however this can drastically increase the size of your dataset as you’d need to replicate it as many times as possible…
-
Did you copy the dataset as well or just the cards? Are you doing any filtering on the new card? Are you using all of the same settings on the cards as their original?
-
Because you’re using a federated dataset it will only update the information when you query it like in your case with the view. what happens if you recreate the federated dataset? Does the row count then match?
-
Are you clicking done in your notebook card after being in edit mode before you navigate away?
-
Have you updated to the latest version of workbench and rebooted the server or in the famous words of the IT Crowd: “Have you tried turning it off and on again?”
-
When looking at the history of the execution does it show writing the data as successful (you'll need to click on the success green oval on the execution to get the detailed step breakdown)? In the preview pane on the output tile does it show data?
-
Have you used an SQL transform to add indexes to your two tables on id, id2 and date fields? Alternatively have you used the new MagicETL as that will be much faster.
-
Currently no, it's all or nothing when it comes to editing cards. You can't select specific cards a user is able to edit. I'd recommend adding this as an idea to the idea exchange because I'm sure others are needing this specific functionality.
-
Hi @NateBI You'll want to use a Magic ETL and Unpivot your data such that you have a column for the different types of clean and then use that column in your Pie Chart. The pie chart only supports a single value for the pie name.
-
they only thing out of the box that would handle this correctly is doing a year to date selection. What I recommend is to configure your own date offset dataset to do a more apples to apples comparison. I’ve written up on this method before…
-
It doesn't appear to be currently possible within the smart text on a title however you can utilize a notebook card and add a summary number to display the minimum or maximum values in your dataset. https://domohelp.domo.com/hc/en-us/articles/360043430233-Adding-a-Notebook-Card#4. I'd also recommend adding this as an idea…
-
Yes as the data is filtered to that specific range and you no longer have access to the prior period data. I recommend utilizing a custom period calendar date to allow you to still have the PoP values even if the data has been filtered to a specific time frame. I've written up on this before here: A more flexible way to do…
-
You can do some simple date manipulation to get the Monday of the current week with a Formula Tile `Date` - INTERVAL (CASE WHEN DAYOFWEEK(`Date`) = 1 THEN 6 ELSE (DAYOFWEEK(`Date`) - 2) END) DAY DAYOFWEEK returns a number between 1 (Sunday) and 7 (Saturday). The CASE statement is checking if it's a Sunday to subtract 6…
-
SUM only takes a single argument. You'll need to add them together. Note that I'm adding 3 sums together as it will handle nulls otherwise if I add CURRENT_INVENTORY + NONCURRENT_INVENTORY + OLD_INVENTORY and if any one of those values is null then the entire value will be null causing incorrect summations. SUM(CASE WHEN…
-
You need to put your condition inside your aggregation. SUM(CASE WHEN `Order Src` LIKE 'CSR' THEN `order_line_total_price`) END) Also - as a side note your LIKE 'CSR' isn't matching on any wild cards so it's expecting Order Src to be equal to exactly CSR. if you're wanting to see if CSR is anywhere inside the Order Src…
-
Are you using Magic ETL or MySQL ETL? Can you post a screenshot of. the tile / logic that's being used?
-
Currently Domo doesn't have a way to remove the borders. I'd recommend adding it an idea in the idea exchange for the product team to possibly review and have other users vote on.
-
Start with the calendar dataset from the Domo date dimension connector and left join your dataset to it on the date using a dataset view or ETL. Then use the calendars date field instead of your own. Left join will cause your missing data to be null but still have the dates from the calendar
-
Are these two users in the same group / need the same access? Have you thought about configuring a group and then sharing the cards with that group instead so any future users will get the access when added to the group?
-
Likely no, it won't work if it's not a direct link to download the file. You'll have to figure another way of getting the data out of their system (perhaps they have an API you can access?).
-
In the email connector have you configured it to attempt to download from a link? https://domohelp.domo.com/hc/en-us/articles/360042931954-DataSet-via-Email-Connector#3.1.
-
Depending on the size of your dataset and the processing needs you can do this in either MySQL (simpler but slower) or MagicETL (more complex, possibly slower depending on dataset size). MySQL dataflow allows for conditional joins so it's a simple query: SELECT a.`ipaddress`, a.`ipnumber`, `Country`, `Region`, `City` FROM…
-
@Casey_Tsujita Domo doesn't exactly support recursive queries as you've mentioned because they're on MySQL 5.6. For my use cases I ended up utilizing a Magic ETL dataflow and then self-join the dataset to itself to go down the recursive list and did it 20 times to handle up to 20 levels deep. It's not the most elegant…
-
You can utilize a formula to calculate the most recent Monday for the week: `Date` - INTERVAL (CASE WHEN DAYOFWEEK(`Date`) = 1 THEN 6 ELSE (DAYOFWEEK(`Date`) - 2) END) DAY A week prior: `Date` - INTERVAL (CASE WHEN DAYOFWEEK(`Date`) = 1 THEN 6 ELSE (DAYOFWEEK(`Date`) - 2) END) DAY - INTERVAL 7 DAY DAYOFWEEK returns a…
-
CASE WHEN `model` IS NULL THEN 'Ignore' ELSE 'Include' END You can then take that beast mode and filter it on your card for Include
-
Magic ETL isn't performing SQL under the hood so there's no SQL to extract from the ETL. It's all done using Apache Spark. You'd need someone to look through your ETL logic and then write then translate it into SQL.
-
You can't dynamically tell a page to filter on different values (filter on shift 1 / filter on shift 2) depending on the time of the day. You'd likely need to have a beast mode that calculates the shifts as either "Current" or "Other" and then have a default page filter where shift = Current.