Best Of
Re: Stop code: System_service_exception (the new blue screen of death)
Definitely reach out to Support [support.domo.com] so they can be across this incident and have a deeper look on their end (via the dev team)
amehdad
Day on Day Change Issue
Hi,
I am trying to calculate the day on day changes of campaign activities (i.e. Sends, Receipts). The problem experienced is restricting the unique counts to one day because the code I've been using includes some records of the previous day. Depending on the time of viewing the domo cards, it takes the record of 24hrs from the time of viewing (which is not necessarily 24 hrs of the entire day). I've been using date_format, specifically:
(COUNT(DISTINCT
CASE
WHEN DATE_FORMAT(`campaign_schedule_date_local`, '%Y%m%d') = DATE_FORMAT(DATE_SUB(CURDATE('%Y%m%d'), INTERVAL 0 Day),'%y%m%d') AND `media_booking_type` <> 'Sample' AND (`campaign_status` = 'Scheduled' OR `campaign_status` = 'Sent')
THEN `campaign_id`
END))
I want to see if using time_format is able to restrict the timeframe for representing daily changes to the exact day (i.e. Up until 23:59:59) but have not been able to see any values return from the code when changing from date_format to time_format. Could you please advise?
Any help is appreciated. Cheers
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: 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: Comparative Gauge using Scale Abbreviation for Value Change
Agree with @RobSomers that you should submit it to the Ideas Exchange as the gauge should have that feature. I have found the comparative gauge a bit too limited. I tend to use the multi-value gauge, which has a lot more customization options and can show the value or percent difference between two values.
Re: Comparative Gauge using Scale Abbreviation for Value Change
I don't think there's a way to do this, which seems a little odd. I'd use 'Feedback' to suggest it to Domo as well as post it in Ideas Exchange. I'll definitely upvote it if you do!
Re: Become a Domo Sensei
What does it mean to "Help one person get certified"?
Is this like a referral program? Or is Domo going to pair up a sensei with someone who is looking for support getting certified?
Re: Dataset column description mass load
@Jmoreno - I would also want you to know, before you update the descriptions for 800+ fields... Those descriptions will not persist through a dataflow. Meaning that if you use that dataset in an ETL or MySQL dataflow, you will need to add the descriptions all over again.
We only add descriptions for certain key fields or for fields that may be named similarly but have different sources or slightly different meanings.
Re: How to show a specific date with an aggregate (max)
Thanks guys for your replies I appreciate the help.
@Grant this would work, but it greatly increases my row total which I don't want to do in this particular case.
@ST_Superman I am implementing this now and it appears to be working.
