jaeW_at_Onyx Coach

Definitely ping support@domo.com

you're trying to export ... a table card into a powerpoint? not to state the obvious, but might there be better ways of displaying the data to make it more ... visual... if you absolutely need a table card, consider exporting the data using the Excel plugin, and then linking Excel to PowerPoint.

Couple points here. it is possible to run a job in the Domo Utility CLI (Java CL)I that will remove rows from an UPSERT enabled dataset if you have a CSV with the UPSERT KEY of the removed rows. So ... this will solve your hard delete problem. Alternatively, you can look at data processing models that handle incremental…

this is defo the sort of thing that should be a support ticket. just curious, if you try applying filters (like top 50) does the query still fail?

What you could do is create a Fusion or a Dataset View between a Webform and a Dataset that's JOIN'ed on the email column. Then just maintain your list of users in the Webform and the INNER JOIN takes care of it for you. Seems like hack, but the nice thing is that you can apply that webform + fusion method to a variety of…

@eporama so the Users API does not accept filters, that sucks. agreed. but what you can do is create a users Domo governance dataset in domo then use a dataset apis which do accept filters to get 'the correct user' https://developer.domo.com/docs/dev-studio-references/data-api…

@PhilD is there a way you could avoid having 20 of the same card by maybe using filter cards in your dashboard?

use the bullet chart?

it sounds like you have a dataset with one row per day per project. if you can transform your data I would 1) add a column that flags 'newState_Boolean': such that CASE WHEN YesterdayState = TodayState then 0 else 1 end. You can use the RANK() function in Magic to acchieve this or LAG (equivalent) in Redshift / MySQL. 2)…

so what is the gap between what you're getting and what you want? "it's not doing what i need it to do..."

I know this wasn't your question, but you should really investigate WHY you would want to hide beast modes from people. If it's b/c there are certain calculations you don't want the rest of the business to know about, you should probably ask yourself if that dataset should be available to the rest of the org .. (pdp).…

@kacy i'm assuming you've created a dataset with 'current day' and average 5 day usage' as columns. you can do that, but I'm not sure I'd recommend this approach because you'll have tons of limited use datasets that only work for one visualization, and eventually it'll become a nightmare to maintain. but setting that…

i don't understand your question. can you include a screenshot annotated with the desired behavior? -- how filtering in analyzer works -- one thing to keep in mind is that when filters in cards (in the filter section) they will show values based on available data WITH OTHER FILTERS APPLIED. So if you apply a filter that…

i think @swagner did something in this vein. https://www.youtube.com/watch?v=oEpkHeGOsr0

could you use a Multi Line Chart? and just use your define your limits as metrics in the dataset / series in then chart?

ooh @GrantSmith thanks for the recognition! just be advised the LAG function will always show the last N rows. it doesn't know if the previous row was yesterday or three weeks ago, LAG just pulls the previous row in the window. So be careful if you know you have gaps in your data.

.. it's not that Preview isn't showing your preview accurately, it shows a max of 100 rows by design. That's just ... how it works. What you can do is FILTER some of your data before you get to the APPEND tile. If you know you're interested in a specific date, customer, or amount, apply the filter and then look. Also, an…

I would bet a year's salary that the problem is in your JOIN clause. There are two possibilities, 1) you're JOINING on a column that sometimes contains NULL. You should never JOIN on a NULL because it creates a cartesian product. in other words, you ultimately multiple each row on both sides of the JOIN by any row that…

@PhilD instead of JOINING the aggregated values to your transactional data, make your dataset TALLER instead of wider. Create a section of data where ActivityType = Actual. Then UNION your aggregation where ActivityType = GroupByResponseGroup (or whatever your appropriate group by clause is). In your beast mode use --…

If you have Magic 1.0 you split your data into 2 parts. Where where Col B is NULL and Col B IS NOT NULL (use FILTER tiles) then you can use SET COLUMN tile or I use SELECT and just choose the column I want to keep. If you're on the Magic 2.0 beta you can use a Formula tile and use IFNULL as Mark recommended. In MySQL you…

Also if you have Magic 2.0 (beta, talk to your CSM) you can use INSTR() in the Formula tile.

If you have a google, Instr() will be an easy MySQL equivalent. https://www.w3resource.com/mysql/string-functions/mysql-instr-function.php

... what dataset are you building your card against? ideally you'll want to use the DomoGovernance Datasets dataset, and then plumb that into a recursive query or configure it to Accumulate data (APPEND). how do you define 'delta' ? percent change in rows from yesterday? if yes, then this will work.

you can simplify this code. if i'm reading it correctly, the goal is to generate one row for each employee during the dates of their employment SELECT ... k.`Status`, d.`Date`, case WHEN d.`Date` = k.`Termination Date` then 'Termination' ELSE 'Active' END as `Status on Date` ### to make this column summable, I would just…

Google LIST_AGG and GROUP_CONCAT. Alternatively look at PIVOT / UNPIVOT in a SQL context. The same thing exists for Magic as Collapse and Uncollapse Columns 

if you're using Domo for real time reporting, you should be on platform 3+. If you asked Domo support or account representative about 15-minute updates, (unless it's explicitly written into your contract) they'll probably tell you you're not paying for that level of service. I hear your point, 'it worked before and now it…

There's a Domo Stats Activity Log quick start.

updating data every 15 minutes... unless you have a proper low latency workflow requirement, it's not recommended. talk to your AE, but 15 minute updates is a non-trivial strain on Domo if you don't do the 'right' workflow. Also, if you have ETL AFTER data ingestion, that's another bit of lag in your dataflow, so if you…

you would want to generate a script file (like a .bat) file that contains one row per command you want to run. ... so i wrote a script that produces the following csv: connect -s 'yourServer' -t 'yourAccessToken' dataset-run-now -i 197200 dataset-run-now -i 197126 dataset-run-now -i 197203 dataset-run-now -i 129139…

how wide are your start and end dates? for the sake of example say you have a row where one row represents project (with a start and end date). If you calculate datediff between start and end date, (let's say 12 days) then you could join to a dataset that is already blown out. So Blow out table would be Join_Col, NUM 1 ,1…