Best Of
Re: Grouped Bar with two categories and trend line
Hi @AttuAk, I'm curious, what chart type did you use to create that view (with the side-by-side regions) in Domo?
If you are after a simple average line, you can use the Scale Marker feature in 'Chart Properties' [https://domohelp.domo.com/hc/en-us/articles/360042925194-Adding-Scale-Markers-to-Your-Charts]. If it's a dynamic average line you need, you can create a beast mode using the Window function, something like:
SUM('Lead Value') / SUM( SUM(`Lead Value`))
OVER(PARTITION BY `Region`)
amehdad
Re: Domo connectors - Spotify Ads
Hi @Ainash, as the Spotify Ads connector setup is quite new across the BI space, it's also worth reaching out to your Customer Success rep and/or Domo Support to see how your needs can be addressed (whether through a custom API solution or a workaround connector).
amehdad
Re: GA Advanced Connector and Domo (Demographics)
So my point was on the settings in your Google Analytics instance as there's likely different permissions to tick/enable in the admin page.
Also confirming that, on Domo, you aren't getting an error message?
amehdad
Re: GA Advanced Connector and Domo (Demographics)
Hi there, what's the error message you're getting? Also, confirming that you allowied Google to download your data during authentication?
amehdad
Re: Export Dashboard to Excel
@ChaseFinanceData, considering that there's multiple unique datasets you're working with, you're better off doing the bulk of the work through that Excel plug-in. It offers a 'Query Builder' so you can re-create your table views across the different Excel tabs once and then continue to refresh the data via Domo Datasource Download Wizard. Definitely read through the link Mark provided before trying it out.
amehdad
Re: Export Dashboard to Excel
Hi there, I don't believe that exporting option is available currently. As far as I am aware, it is only possible to export each table/card, from a dashboard, as a page via 'Export as PowerPoint'. It has been requested a while ago [https://dojo.domo.com/discussion/26571/export-page-of-cards-as-excel] but no updates since.
amehdad
Re: Create a card/text field that simply says the last month on a dashboard
Single Value card with a beast mode will get you what you're looking for for the current date:
DATE_FORMAT(DATE_SUB(CURDATE(), INTERVAL '1' MONTH), '%M %Y')
Re: Microsoft D365 Finance and Operations Connection
Fair enough, the other options are:
- Workbench (via these example steps: https://www.cdata.com/kb/tech/d365finops-odbc-domo.rst)
- Custom Connector (which can be built from here: https://developer.domo.com/docs/custom-connectors/connector-dev-studio)
amehdad