Best Of
Re: DOMO Rank System
@Kumar619 it's a feature that needs to be enabled on the instance, contact your CSM or support and ask them to enable "window functions in beast modes"
Re: Is it possible to do CTE hierarchical recursive query in MySQL?
MySQL 5.6 does not support CTEs.
this approach works.
Re: Is it possible to do CTE hierarchical recursive query in MySQL?
@Fatias MySQL 5.65 is several years old. I'm pretty sure it's safe to say it's not a priority to upgrade the version of MySQL to something more modern.
you don't have to implemen using parent_id < id. you can implement where you accumulate the path
concat(path '+', id) as path
and just filter
WHERE path not like '%id%'
Re: Problem while trying to edit a scheduled report
I assume you checked the obvious culprits like making sure the card renders and removing any erroneous beast modes that error out?
Have you tried sharing the card with the user first?
If the obvious things fail, send a support ticket, they have the right tools for debugging bugs.
Re: Read only DataSet API access/token generation
@Sam1 ,
@GrantSmith is correct insofar as the access token you generate (or client_id & secret combo) will have the same permissions as the user with which the token was generated.
to control which rows of data a user has access to, use PDP policies.
to control which APIs a user can use (what actions they can take in Domo) use scope and customize their role as Grant suggested.
Re: Read only DataSet API access/token generation
Hi @Sam1
The API token you authenticate and communicate with us for the user that created the token. So you could have a user which has their permissions limited to read only ( a custom role)
Re: How can I show % change summary # for Period over Period chart?
Hi @MattGo
Period over Period charts don’t support percent change. You’d need to calculate it yourself using a beast mode however it’s best to reformat your data using a date dimension table to calculate your metrics on a certain date based on a certain offset (Last Year, last month last week etc. ).
@jaeW_at_Onyx has a great video outlining the process https://www.youtube.com/watch?v=CDKNOmKClms&t=468s
Re: Single value card displays blank if specific date is selected in date range with existing data
Hi @Slapo
Have you tried viewing your data as a table in analyzer and applying filters to see if your rows still show up? What happens when you lift some of your filters?
Re: % Change Question
I don't think this is possible without preaggregating the data.
to apply conditional formatting, you'd have to be able to wrap the aggregate in a CASE statement
CASE WHEN sum(amount) 10 .... END
But Domo broke that functionality a few weeks ago. I don't know if it's been restored.