Best Of
Re: Date filter greyed out - multiple date columns in a table visual
Update: (@MichelleH)
It works now, I removed both dates, added the created date first then added the batch date.
It must take whatever the last date field added is and auto set this as the date range field filter for some reason.
Thanks for the help!
NateBI
Re: Is this a bug or user error
@Jones01 Having two columns named the same would create a problem. When they're imported into Domo, your query has p.zone_id and s.zone_id. But when the data gets imported, since the p and the s are only used to identify which zone_id is which within your query, the column names are actually just zone_id and zone_id. Since they're named the same, Domo will think they're the same column and have trouble.
Re: Date filter greyed out - multiple date columns in a table visual
@NateBI This is usually because the "created date" field is being used in your card. Try removing it and adding the date field you want.
Re: Date filter greyed out - multiple date columns in a table visual
@NateBI You can still have created date in the card, but you will need to add 'batch date' first. Also, you may need to have the 'batch date' column further to the left than 'create date'
Re: How do you pull Revenue data from Facebook connectors?
Hi @finsters, using the 'Facebook Ads Advanced Connector' [https://deloitte-au.domo.com/appstore/connectors/com.domo.connector.facebookads?origin=search], and by selecting the 'Custom Insights' report type, the field 'ConversionValues' appears in Columns that can be selected. Let me know if you're still having issues.
amehdad
Re: Multi Tab in excel
Once you drag in your file and it previews the data for you, if there are multiple tabs, the first tab will be selected and there will be a dropdown arrow next to it for you to select a different tab. This will be just above your preview, above column A.
Re: Release Notes - What Changed
Just commenting to boost this idea. This is a great idea and would be very helpful.
Re: How to represent how many tickets opened by each individual user?
@Morgan This depends on what you have available in your datasets. If both datasets have a username or some other id column that can be used to identify who the user is, you can use an ETL to do left join between the Tickets table and the Users table. This will then look through your ticket table and attach user record from the user table to the corresponding ticket. Then you can decide whether you want to do the aggregation for the number of tickets in the ETL or in the card.
Re: Creating a Link Field in Domo
You have to add the target="_blank" tag
CONCAT('<a href="https://na132.salesforce.com/', `field_ID`, '" target="_blank"></a>')
Re: Move/Copy Card - Indicator and Warning
I might also add that it would be nice if there were also a message before any changes to the card could be saved. Something like "The changes made will impact multiple locations where this card is used". If possible, even list the different pages that the card is on.