jaeW_at_Onyx Coach

コメント

  • https://stackoverflow.com/questions/28486891/uncaught-error-module-did-not-self-register ?
  • there's built in filtering that would allow you to filter by weeks. alternatively you can construct a date dimension table based on TODAY() that includes a calculation for WeekNo and a WeekLag_fromToday
  • What error message did you get? This works fine. select date_part(dayofyear, cast('2020-02-14' as date)) Is your Date column a date or text? Domo processes Redshift ETL in a Redshift cluster. So if you're throwing an error during transform steps it's usually a code issue.
  • piece of cake. You need two chunks of data. "Sales Actual by day" and "Financial allocated by day." Yes, you need to break your financial data into one row per day. Decide if you have 20 or 30 days per month. APPEND the two together and differentiate by 'Activity Type' or some similar column. Then decide how you're going…
  • https://knowledge.domo.com/Connect/Connecting_to_Data_with_Connectors/Configuring_Each_Connector/Connectors_for_Social_Media/Facebook_Advanced_Connector#Which_endpoint(s)_does_each_report_call_in_this_connector.3F The documentation is pretty clear about which APIs it's hitting. https://developers.facebook.com/docs/ I don't…
  • @user046467 let's be clear, when you're creating a connector you're saying you're unable to get 'the right data' OR in your cards you're not showing the 'right data'? If you're having difficulty configuring a facebook connector, support might be a good avenue for you to pursue. if you can't get the right data in Analyzer,…
  • I assume in your raw data you have one row per building and then the metrics going across in columns. If that's the case then you need o collapse the metrics such that your end result is one row per building per metric. (use the collapse columns MagicETL tile). Then you can pivot as @MarkSnodgrass where Metric is in Rows…
    Chart Type jaeW_at_Onyxによるコメント June 2020
  • @user10198 wrote:Hi All, Well im trying to have a date-time card so that it is like a clock visible on domo dashboard. So there are few issues that i am facing 1. the date and time are required for different time zone . i want to show central European summer time zone (utc+2) 2. i am using the NOW() function , and i want…
  • Beast modes don't support BETWEEN syntax. But also... this is the sort of thing that might benefit from a lookup table / date dimension + a fusion. It'll be more easy to manage.
  • 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