Best Of
Re: Simple Beast Mode Failing on Federated Dataset
Hi @LCash, alongside this thread and awaiting the advice of the technical adept users, reach out to Support [support.domo.com] to have them look at it as well (and escalate to Dev if need be).
amehdad
Re: Why use a tooltip when I can use a data label or hover text?
Hi @Joe_M
The tool tip fields allow you to put additional information into your hover text or data labels without having to generate a new beast mode to display all of the information that you need. You can refer to them in the analyzer settings as %_TOOLTIP1/2/3 etc
Re: Data Warehouse Summary Values
Hi @Crisocir
It's the number of blue cylinders displayed on the warehouse infographic. Each one represents a dataflow grouped by the types of inputs so you may have one for ODBC / Dataset via Email or Gooogle Analytics / WebForm etc. It's just grouping them by the unique input types for the dataflows.
Re: Budget Amount and Gauge Card Setup
Hi @AJ2020 ,@jaeW_at_Onyx and @GrantSmith ,
I did try to find a solution for the above posted problem and I was able to get it done using a HTML table. Below I am attaching a screenshot for the table card and beast mode using which I have created the card.
Beast Mode for Graph Column :
CONCAT(
'<div>
<div style="width:',(AVG(`Budget`) / AVG(`Budget`))*20 ,'%;Text-align:left;float:left;color:#5D5D5D">
<b>0%</b></div>
<div style="Text-align:left;Width:',(AVG(`Budget`) / AVG(`Budget`))*20 ,'%;float:left;color:#5D5D5D">
<b>20%</b></div>
<div style="width:',(AVG(`Budget`) / AVG(`Budget`))*20 ,'%;Text-align:left;float:left;color:#5D5D5D">
<b>40%</b></div>
<div style="Text-align:left;Width:',(AVG(`Budget`) / AVG(`Budget`))*20 ,'%;float:left;color:#5D5D5D">
<b>60%</b></div>
<div style="Text-align:left;Width:',(AVG(`Budget`) / AVG(`Budget`))*20 ,'%;float:left;color:#5D5D5D">
<b>80%</b></div>',
/*<div style="background-color:#ffffff;Text-align:left;Width:',(`Budget` / `Budget`)*0 ,'%;float:right">
<b>100%</b></div>*/
'</div><br>','<div style="background-color:#224D75;height:10px;width:',(SUM(`Used`) / AVG(`Budget`))*100 ,'%"></div>')
Beast Mode for %Used Column :
case
when (SUM(`Used`) / AVG(`Budget`)) * 100 > 100 then CONCAT('<font color=#fa5e5e>','<b>',ROUND((SUM(`Used`) / AVG(`Budget`)) * 100,2),'%')
when (SUM(`Used`) / AVG(`Budget`)) * 100 < 100 then CONCAT('<font color=#226F78>','<b>',ROUND((SUM(`Used`) / AVG(`Budget`)) * 100,2),'%')
end
Do let me know if you find this useful.
-
Thanks,
Anas Ahmed
Re: Data Warehouse Summary Values
Hi @Crisocir, 'Domo Magic Data' refers to the dataflows made up from multiple 'Data Sources' (for example, Salesforce connector data combined with Excel file connector data). From these dataflows created, you get your output datasets, which makes up the 'Dataset' number tile you can see.
amehdad
Re: Hi! has anyone built a Pepperjam or Twitter API connection for DOMO?
hi @user00426,
The basic Twitter connector is pretty limited in what can be extracted from the API. This is because Twitter locks many of the tweet level metrics (unpaid) behind a wall that you have to jump through hoops and pay to get behind.
You won't find many if any organic tweet metrics through the Twitter connector unfortunately. Twitter acquired a company called "Gnip" a few years ago and all organic API access is routed through them. Contacting Twitter directly is probably your best option in this case.
Sorry I don't have better news, unless something has changed in the last year, this is what I remember.
Best of luck!
Re: Hi! has anyone built a Pepperjam or Twitter API connection for DOMO?
Those three solutions make sense. I've done the first two, and while they do require some management, they work fairly well as a minimal touch solution.
Another solution that goes along with #2 below would be to use Box to drop the files into, then use Domo's Box connector to bring the files in and run the merge dataflows. Domo's Box connector is very robust and useful.
Re: Calculated field doesn't respect parentheses in arithmetic expressions?
Hi @DavidLee, I can comment on why this would be happening when one wants to display the arithmetic expression result in a 'Single Value' chart. Domo defaults to expressing a value as a sum, and so selecting any other option would return the expected result.
amehdad
Re: Is it possible to hide PDP symbol for PDF export (or remove from instance entirely)?
Hi @Ritwik, from what I understand there's no current or planned beta to hide the icon from view. But it's worth also checking with your CSM.
amehdad
Re: SQL Row size too large
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).
amehdad



