amehdad Coach

If it wouldn't be a lot of work to pull your data in between tables, you can split your dataset. Another workaround is to change anywhere you have from varchar to text data type. Or you can increase the value of the innodb_log_file_size (https://dev.mysql.com/doc/relnotes/mysql/5.6/en/news-5-6-20.html#mysqld-5-6-20-innodb).

Admittedly, the knowledge guide on the plugin provides no help for your issue. If you haven't already, you should reach out to Support [support.domo.com] as they can see "under the hood", so to speak, and better advise on what is causing the 'summary numbers' objects to not be in fixed position.

It doesn't appear that the Query API solution is fit for your use cases, due to the constant request load put on the server (even after limiting and offsetting). Have you reached out to Support [support.domo.com] to explore alternative solutions?

Do you get any error message to help with troubleshooting? I would suggest also sending this thread, or these screenshots along with an explanation of your situation, to Support [support.domo.com] as they are better equipped to confirm bug or missing elements in your code.

@Tow solving it yourself is always good and either way you've made @GrantSmith a happy man :P

Have you had your Customer Success Manager switch on the feature for Window Function in your instance?

What's the error message you are getting?

Hi @ndldty, how did you go with this?

Hi @Tow, how did you go?

Hi @user17472, have you checked this issue through with Domo support [https://domo-support.domo.com]?

Hi @imelendez, it's odd that in the article [https://domohelp.domo.com/hc/en-us/articles/360043434413-Facebook-Advanced-Connector], it mentions the metric you are after but not which report it would sit under when you set up the connector. Have you tried 'Custom Insights' in Report and then searching the columns for…

Hi @user24014, I'd imagine you followed the setup outlined here: https://domohelp.domo.com/hc/en-us/articles/360042929334-Matomo-Connector?cid=matomo. The subdomain is the additional bit at the front of the URL (i.e. Anything that is before .matomo) for the Matomo Analytics space that you or your organisation uses.

Hi @user041053, yes the level 1 cert exam is multiple choice

Hi @user052647, I'd imagine you already had a look through this knowledge article: https://domohelp.domo.com/hc/en-us/articles/360043428293-Combining-DataSets-Using-DataFusion. What was the specific case you were trying to address?

If it's not network connectivity related, it could be an indicator that the data volume and querying is at capacity or close to, in which case one should do some content management/optimisation and spacing out update scheduling to reduce the load in the instance.

For any issues like this, one should check if Domo is down or having problems [https://status.domo.com/] and/or open a ticket with support [https://domo-support.domo.com].

For any issues like this, one should check if Domo is down or having problems [https://status.domo.com/] and/or open a ticket with support [https://domo-support.domo.com].

Hi @user095063, have you tried adding MAX before 'HDM Revenue'?

Hi @Tow, what would the significant differences be between the two Dev account settings that would cause the different visibilities of the cards?

Hi @Abhijith, so when you have your empty canvas in the ETL, like the example below, you can then copy and paste Grant's code and it will automatically populate the tiles and dataflow.

Hi @AttuAk, how did you go with this? 

Hi Jack, how did you go with this? 

Hi @User_32265, how did you go with this? 

Echoing Grant's recommendation as the Domo Workbench dev team would be best placed to help solve the problem you've encountered.

Yep so as the beast mode above uses your two dates, you'll need a separate date field to create that month by month view. You can either use another date field in your 'Input' dataset (for example, dataset updated date), or can bring in a date field (like a daily employee log) from another dataset, via ETL and joining by…

Hi @Abhijith, for your first Q, as a start, this is an option to get total employees active: COUNT( CASE WHEN status = 'A' AND 'Hire Date' <= DATE_FORMAT(CURRENT_DATE(),'%d/%m/%Y') AND 'Termination Date' IS NULL THEN 'ID Number' ELSE 0 END) You could use 'COUNT(DISTINCT ... ' in the front instead. To get the graph view by…

For % by category, you would use: over (partition by Category) in the above formula. You'll need to check with your Customer Success Rep if that feature is enabled for you.

Hi @ndldty, you can create a beast mode for % of total by using a window function, for example: Sum('Value') / Sum(Sum('Value)) over ()

Hi @Ainash, on your 2nd question, have a read of this knowledge article: https://domohelp.domo.com/hc/en-us/articles/360060270674-Google-Ads-Connector#4.0.1.

You can also use the Dataset Copy connector [https://domohelp.domo.com/hc/en-us/articles/360043436533-DataSet-Copy-DataSet-Connector] to create a snapshot (with the update setting being Append).