Best Of
Re: Pinterest authorization issue
This is correct. I think that these platform deprecations / updates, that may affect the connectors, should be passed on to us on the Domo status page for example.
Re: Variable Control Title and Descriptions - Ability to Format Text
I might end up making this as a separate idea in the exchange, but we need the ability to sort the items in the variable dropdown list. They don't automatically sort alphabetical and if you don't enter them in the right order the first time, you are stuck with that order. Just tried removing items and then adding them back in alphabetical order and it is not holding.
Re: How do you restrict access to Admin Panel for normal users?
I want to let basic users be able to edit a card, but not access this menu, circled in red. Accessing the menu shows other user information, which I want to restrict. The document linked says that this access is only limited on the Participant role, which has view only access and does not let you edit cards. There are no role grant settings to allow or restrict access to the admin menu, circled in red. I have users with sensitive information, and I do not want other users knowing who has access to that information. From what you're saying, it doesn't sound like there's any way to do this, because user information, under the Admin -> People heading, is not restricted by publication groups or PDP settings because those are focused on data, not system access. It sounds like we are talking about 2 different things here...
Re: Beast mode case change based on whether or not a filter is in use
@Domomon It sounds like you could use variables for this, though that likely depends on the details of your specific use case.
Re: Any ideas on how to show different table columns based on a dashboard filter
Have you tried using variables? You can conditionally return a specific column based on the criteria selected. You'd just have beast modes for the many different columns you want to display. You'd need to have the same amount of columns though as you couldn't have an empty column.
Re: IN function
No you cannot. You would have to do: CASE WHEN `session_medium` LIKE('%Email%') OR `session_medium` LIKE('%email%') OR `session_source` LIKE('%Email%') OR `session_source` LIKE('%email%') THEN 'Email' ELSE 'Whatever' END
I would recommend using LOWER() function so you don't have to have both Email and email in your statement.
Re: I want to calculate difference between yesterday and day before yesterday.
You could use a beast mode like the one below to sum the file collected if the date field is one or two days before today:
sum(case when DATE(`local_collect_date_time`) = CURRENT_DATE() - 1 then `FilesCollected` else 0 end) - sum(case when DATE(`local_collect_date_time`) = CURRENT_DATE() - 2 then `FilesCollected` else 0 end)
Re: Adding link to card name
You can create a direct link to a card based on the card ID and a url like the following:
https://[DOMO_DOMAIN].domo.com/kpis/details/[CARD_ID]
Re: Rounding Data within card
It'd seem many of your Count and Average columns are being retrieved from actual values from the Dataset your ETL generates, rather than being an aggregation at the card level:
This would explain why you get two entries for the same half hour period for the same account. Ideally any aggregation and calculation that should be dynamic and that can be affected by locally applied filters should not be performed via ETLs but either by using Aggregation on existing fields, or via Beast Modes that do the aggregation and oppertaions needed (like if you need a ratio or the like, you'll do something like SUM(value1)/SUM(value2))
