Best Of

Re: Facebook ads connector not returning conversions and conversion value?

We've had the same issue with our FB connector dropping revenue for the standard purchase event randomly across client accounts.

We fixed it by creating a new connector with less columns. For some reason the values show up when there are less columns. Definitely seems like API changes on the Meta side are being rolled out to accounts.

Bobby_Kelly

1

Re: Remove dates from a card with a beastmode?

Something like this can work. You can tweak based on your logic but I tried to give several different examples:

CASE WHEN date IN ('2022-01-01', '2022-02-01'…) THEN 'Exclude'

WHEN YEAR(`date`) = 2022 THEN 'Exclude'

WHEN DAYOFMONTH(`date`) = 1 THEN 'Exclude'

WHEN DAYOFWEEK(`date`) = 4 THEN 'Exclude'

WHEN LAST_DAY(`date`) = 2022-01-31 THEN 'Exclude'

ELSE 'Include'

END

Then just filter for Inlcude in your card.

GrantSmith

1

Re: Page menu and Admin role option

Are you referring to the 3 lines in the top left of your Domo instance which exposes the pages menu?

Hovering over the 3 lines will expose the pages you have access to.

In the Admin menu, they are called Dashboards and Privileged users have access to this.

MarkSnodgrass

1

Re: Beast Mode Column Sort Not working Correctly

@jtrollinger I would check your sorting settings in Analyzer. If you are sorting by multiple fields, be sure that this is the one at the top of the list. Also, be sure that you are not sorting by the SUM of the sort field.

MichelleH

1

Re: Extract Quarter Value from Date Field and Return First Date of that Quarter

A simplified Beast mode would be something like:

`Start date` - INTERVAL DAYOFMONTH(`Start date`) DAY + 1 - INTERVAL MOD(MONTH(`Start date`)+2, 3) MONTH

Detailed Breakdown:

`Start date` - INTERVAL DAYOFMONTH(`Start date`) DAY + 1

Returns the first day of the month for a date with start date. DAYOFMONTH returns the day number of the month, subtracting it would get the last day of the prior month so we add an additional day to get the first of the month

- INTERVAL MOD(MONTH(`Start date`)+2, 3) MONTH

This causes the months to return a sequence of 0, 1,2,0,1,2… to subtract that number of months.

MONTH returns the month number, +2 to shift the sequence right 2 places so that 1 = 0, otherwise it'll return 2,1,0,2,1,0…

MOD(…,3) takes the month number and divides it by 3 and returns the remainder.

GrantSmith

1

Re: DDX: Getting Data in DDX form

Hi Naveen,

'Query' not defined. Can you paste you code snippet to get more idea? It's javascript legacy api object so shouldn't happen.
You cannot refer your Domo dataset directly in your DDX. You have to first map the dataset(s) that you want to refer in your DDX by choosing them in your mapping section (as dataset0, dataset1 etc.) - see below for example.