jaeW_at_Onyx Coach

Because I filter by campaign name (in the card editor) and have to manually select it to include it within the card.Is there any way to come around this? Otherwise I might have to do the filtering in the ETL to create an output. That should work automically, right? OOOF. don't do any filtering in ETL! When you apply…

This is going to sound snide, but it really isn't meant to be. Did you try googling the error? A lot of the errors you'll encounter in data work are not unique to a product or platform. If you google 'arithmetic overflow error' you'll find that typically that error occurs when the data doesn't fit into the data type of the…

@datadiva , hate to flog my wares ? but I am a freelance consultant and I do offer a service to help clients like you model and solve reporting issues like this at an hourly rate. contact me at jae@onyxreporting.com with regards to returns. just extend the model. "we prioritize fulfillment on returns" -- fine that keeps…

Simon, Try limiting your data with a filter to a few topics so you can visually inspect and understand what's happening in your data. If the data is small enough you could probably export it into Excel. In table form, use rowCount to understand how many rows are being aggregated and then do the math by hand to know if…

interesting. I'll be honest I didn't test this, but I'm pretty confident the pivot table is acting as expected. In your math, ignoring the adjustment to change units from year to months, you've said "for each row, take issued count and divide it by submission count THEN take the sum." what i believe you want is: "take…

Simon you cannot do a SUM(COUNT(Distinct()) b/c you want a count distinct across all Sources not the sum of Count(Distinct()) for EACH source. It's a bit of a process to understand and setup, but I've tackled the problem you've described in this tutorial video. https://www.youtube.com/watch?v=Xb4QgKYgaqg&t=507s Hope that…

Having taken a closer look at your data though ... it's unclear if your 'ordered' column is total order amount or just new quantity of units ordered in that month. if your data just calculates 'orders placed that month' then your task will be easier. Try to define very explicitly how you would answer the 'outstanding…

oh interesting! what's your beast mode calc? (this might be something to raise to support)

https://www.youtube.com/watch?v=ZPf41Fjn1H8&t=523s Here you go! I did a tutorial on this topic a while ago on youtube. The term you're looking for is a cumulative sum (sorry if that sounds pedantic, but you can do a google search now for cumulative sum SQL and you'll find more in-depth articles etc.) Add a column at the…

Try explicitly setting the data type using the SET COLUMN TYPE tile. Then delete the APPEND ROWS tile and add it back in again. If that doesn't work you can also use the SELECT tile to explicitly name the columns, you might have an invisible special character or empty space.

!!! haha, you initially said you wanted to alter a fusion. Of course you can fix a data type in ETL. You can use any ETL engine, MySQL, Magic or Redshift to change data types. In Magic you should use Set Column Type IF the data can be coerced to the new data type. Value mapper is most appropriate if you need to change the…

Domo does not handle NULL values well in Analyzer Create a beast mode case when `card Title` is null then '-- no card title--' else `card Title` end then you can filter on '--no card title--' hope that helps!

Even if you rebuild the fusion, in the Domo UI there is no way to change the data type. There is a new data views beta that will give you more control over editing the schema of views. Ask your CSM for details. You'll have to move all your cards to the new dataset though.

nope. Magic is not a SQL based engine.

upload or email me a sample of your dataset pls jae@onyxreporting.com. please make sure it's anonymized in case i decide to make a youtube video of it!

https://www.youtube.com/watch?v=ZPf41Fjn1H8 I did a tutorial video on this very topic! Check it out. You may need to contact your CSM to get 'window functions enabled in beast modes' before you can proceed. here's another permutation of Window Functions in case you're interested. https://www.youtube.com/watch?v=cnc6gMKZ9R8…

@imelendez check your parenthesis and break it all into composite parts. CONCAT( ROUND(UNIX_TIMESTAMP(`completed_date`) - UNIX_TIMESTAMP(`promised_time`) / 60 - 0.5), ':', ROUND(MOD(UNIX_TIMESTAMP(`completed_date`) - UNIX_TIMESTAMP(`promised_time`), 60) - 0.5) ) UNIX_Timestamp converts to seconds since XYZ point in time.…

make sure to use the help command... query-data -i <dataset_id> -xf <export_filename> -sql "SELECT AVG(avgHeartRate) AS heartRate, activityName FROM `{dataset_id}` WHERE avgHeartRate > 0 GROUP BY athleteId, month(startDate), year(startDate)" usage: -i,--id <ID> dataset id -q,--query <QUERY> query -qf,--queryfile…

Youtube Tutorial: https://youtu.be/s57DSVmGwQQ I think I understand what you're looking for, but to find an equivalent, I think I would try to frame the question in simple English in terms of defining the behavior that you want. Does Table B define 'the rep who manged an account on XYZ date'? If so then you could define a…

@DataSquirrel Thanks for sharing! Re: structured axis. In SQL world, I know that is attainable in MDX and OLAP cubes; however, I'm reasonably confident Domo achieves its speed by avoiding processing 'too much' data at the client level. Analyzer is constructing a SQL query which is then executed server-side and then laid…

QueryFile will definitely be the easier b/c you don't have to worry about escaping single ticks ' in your SELECT statement. Try SELECT name FROM dataset_id

IMHO, easiest way to accomplish that would be to build out that logic in scripting and then at the end of the script trigger data transfer into Domo. The JavaCLI would be a handy tool for pushing data to Domo This is the official documentation here…

Yes, you can recreate 'parameterized queries' in Domo with a webform: https://www.youtube.com/watch?v=wmMrnPO9ivY

Domo uses MySQL 5.6+ Type SELECT @@VERSION for the exact version number. This version of MySQL predates the implementation of Windowed functions. You can recreate it using user defined variables. https://stackoverflow.com/questions/3333665/rank-function-in-mysql Without performance tuning in MySQL, you'll probably get…

Make sure your Beast modes for 'Users this week' and 'Users last week' return appropriate values when separated into two separate BMs. Then, make sure you're not Getting NULL b/c you can't add x + NULL (you get NULL).

@imelendez I'm not sure I understand your question. If i had to guess though you're trying to calculate duration. If so,wrap your dates in the UNIX_TIMESTAMP and then take the difference. duration_in_seconds = UNIX_TIMESTAMP(end_dateTime) - UNIX_TIMESTAMP(begin_dateTime) @GrantSmith , I think that's the solution you found…

1) try creating a URL with the URL of the image and make sure it works (it is definitely possible to create a URL, consider adding target ="_BLANK" Once that works, try altering to add the image. If I'm honest, off top I don't know if it'll work. But step one would be to make sure you have the sytnax of your href straight.…

Sorry. AFAIK there is no way to force Domo to fill in blank rows. But think about it. Visualizations only work based on data the know about. Conceptually we know that we're talking about 'hours in a day' of which there are 24, but Charts usually have no built-in logic to understand that UNLESS you use a date based chart…

@GrantSmith wrote:If you have window functions enabled in your instance you could do this via a windowed function in a Beast Mode instead of a running total card: SUM(SUM(1)) OVER (ORDER BY `Date`) And then utilize @MarkSnodgrass 's solution about adding a month to the date for display purposes via another beast mode. If…

Thanks for sharing my solution @GrantSmith , it should work for your use case @user095063 . An alternative you could also consider building an offset into your data by using an offset table with a Fusion. https://www.youtube.com/watch?v=CDKNOmKClms&t=705s In this example the offset is one year, but you could easily modify…