Comments
-
Unfortunately no. You can drill down into an individual card and keep the filters imposed on that card, but not san entire dashboard.
-
When users share cards with other users, those new users are automatically given access to the dataset. There are a few requests in the ideas exchange I think regarding changing this behavior, but for now there's not really a work around. You can find more info here:…
-
Ok good. I think at this point there'd have to be something off with alignment of the rows in your blend if the aggregation at the beastmode level isn't working in this scenario.
-
Strange. Is Qty a "measure"? If it's rolling up as a string rather than a number in your blend, that's the only other reason I can think of you'd have trouble adding it tot his formula.
-
Did you already try to the null wrapper to account for empty rows in your data? sum(case when source='POS' then ifnull(`Qty`,0) else 0 end)
-
You don't need sum(Qty). Just Qty
-
You may need to wrap your value field in an ifnull: ifnull(`value_field`,0) If that doesn't work please paste the formula.
-
Are you wanting your filter column to apply to only one of your aggregated columns? If so, try adding a beastmode for the aggregated column for which you want the filter to apply and add the beastmode column to your report rather than the aggregated column you created in your blend: sum(case when filter_column= 'source'…
-
Jae Wilson has documented a lot of Domo's private API. You can find info on authentication and various calls to the User API here: https://documenter.getpostman.com/view/5049119/UyxbppB2#9d632591-53a3-429d-b358-4232e3fba85e
-
Can you paste your beastmode @ScottLeeds
-
You can look up the dataset and this specific beastmode in beastmode manager to see when last it was modified. It's possible the beastmode was changed on the around the 15th and that's why it stopped working. It appears you have several other beastmode columns, variables, and quick filters applied to these cards as well,…
-
You'd have to disable the Personalized Data Permissions (PDP) on the dataset in order for the icon to go away. PDP controls what data your users can see, though, so not likely something you'd want disabled.
-
Where does this notification display? This sounds like a web browser notification. You should be able to prevent notifications from any website in your web browser settings. I'm using Google Chrome and I can stop notifications in settings—>privacy and security—>notifications:
-
Make sure the account used to authenticate the Box Advanced connector has been shared with you in Domo and confirm that account has access to the file in Box. Also make sure you have "edit" rights on the dataset in Domo if you're not the owner of it. Helpful links: Sharing accounts:…
-
It depends on your char type. If the chart type you've chosen has the ability to reverse the legend, you'll see it in the chart properties section when editing the card in analyzer:
-
Card alerts can typically only be configured based on the summary number or all rows. You can set up alerts based on specific columns other than the summary number directly on the dataset itself in the datacenter.
-
@drewswayne awesome. Also, you can hide the title on any card on a dashboard by putting the dashboard in edit mode, clicking the "edit content" option on the card, choosing "appearance", and deselecting "title".
-
Colemen's instructions should work. Try using the summary rather than smart text option:
-
It looks like your average response rate is way less than .37 as most of the companies have null response to company strength. You can try implementing an ifnull(response rate, 1) to see if that gets you closer to where you want to be in your gauge card.
-
You can wrap your existing formula in the date function. Date(str_to_date())
-
I'm not familiar with Exact but the others have connectors available in the Domo appstore. You'll need to look through each of the connectors to see if one of them has the fields you need. If you can't find the information in any of the Domo connectors, you'll need to have it generated directly from each of these…
-
You can also try concatenating all of your columns together into one column, deleting duplicates based off of that column, then splitting the columns back out based off your chosen delimiter.
-
You don't have to limit the number of rows to save space on a dashboard. If there are more rows than can be seen based on the size of the card, users will have the ability to scroll up and down as well as across.
-
What is the datatype on each of these columns before you run them through ETL? Some show hours and minutes, while others show hours, minutes, and seconds. You can remove the 'T' via a replace formula: replace(`ETD at POL`, 'T', ' ').
-
@Jmoreno Thanks for the temps/cookies tip. I found out our IT deletes these automatically on our devices pretty regularly but I finally remembered did it manually today so hoping this is completely resolved going forward. Haven't had the issue since last week though so something's working
-
You can do replace(`date_column`, 'T', ' ') with a space in between the final single quotes to indicate you want to replace all occurrance of 'T' with a space. This will also convert your date column to a string. Alternatively, if you just want to remove the time part of datetime column, you can use the date function…
-
John Le with dashboarddudes.com has a few marketing templates. There's also visuals all over Google and Youtube. You can upload custom graphs or use a brick to visualize charts not available in Domo's out of the box visualization options.
-
@BMilner if the export from Domo is 0 bytes then there's nothing in the file. Only other things I can think of are trying in a different browser like firefox or clearing your temp files/cookies, closing your current browser, and trying again. There's also some stuff on microsoft forums on this issue that's unspecific to…
-
@BMilner transposed tables are retaining their format when I export to exls from my Domo instance - I just exported one to doublecheck. Does the card display as expected when viewed in Domo? Have you tried rebuilding the card from scratch per Mark's suggestion above since it may have become corrupt? Is your export 0 bytes…
-
You can accomplish this at the ETL level. You'll need transforms for the WTD, MTD, QTD, YTD ranges along with calculations in each of those transforms aggregating your measurable fields.
