GrantSmith Coach

This is within the data level in Domo

You can setup a dataset view and allow them access tot the dataset to download the entire dataset. I’d also recommend looking into PDP as it will automatically filter your dataset based on defined permissions so you’d only need a single data set to point your users to

Hi @user048760 Another option would be to define a custom date offset dimension for the current date, last month and 2 months ago. You can then conditionally calculate the rolling average over the past 3 months or look at the difference between months based on the offsets your define. I’ve done a write up about offset…

Hi @Adrien the total row is calculated on the card after the beast mode is calculated so it’s adding your percentages instead of calculating your total percentage. if you want a total row you need to use an ETL to group your data together and sum all your columns using a group by tile then using an add constant tile put…

Hi @user041053 Id recommend looking over the knowledge base article on workbench and how to configure a job to start https://domohelp.domo.com/hc/en-us/articles/360056669354-Workbench-5-1

Filters will apply to all rows in your dataset so what you’re wanting to do isn’t possible. You might be able to get around it using a segment and tell it to not apply those filters you wish to ignore.

You may also want to look into Domo Publish https://domohelp.domo.com/hc/en-us/articles/360045120554-Domo-Publish

to get around this limitation I will utilize the line+bar chart and define my own offset dataset which gives much more flexibility. I’ve done a previous write up on this here: https://dojo.domo.com/discussion/comment/50540#Comment_50540 @jaeW_at_Onyx has done a video on this as well.…

I don’t recall the exact CSS styling but you’d need to update the hyperlink CSS styling link color for your hyperlink and that might work for you

The total row adds everything after beast modes have been applied. You’ll need to stack your data in an ETL using an append with your data set grouped and summed and call the rows TOTAL. Then you can use the beast mode to calculate your data for each lane and the total

Typically it’s just (‘New’-‘old’)/(‘new’) but it depends on how you have your percent change metric defined in the card settings. Which method are you using?

You’d need to have the field be the same name if you’re using a filter card for filtering on your page. If you’re using the page filter at the top it’ll filter based on the date field defined on each cards date selection. Im not sure how your dynamic text is being generated but it should get updated automatically if you’re…

Hi @Shumilex Can you use a group by name account and date and just use the MAX aggregate to get the highest balance?

Hi @JZz There are several custom visualizations that Domo has done for the Covid dashboard and I believe that violin plot is one of them. There isn't a violin plot available out of the box within Domo and would require a custom app to visualize the data in this way.

I agree with @MarkSnodgrass put your percentage value first and it’ll be displayed as a percentage and have a separate scale from your other two counts with your counts on the same scale.

Hi @user082291 You can use SUM and a CASE statement to conditionally calculate your percentage. SUM(CASE WHEN `anonymous`='yes' THEN 1 ELSE 0 END) / SUM(CASE WHEN `anonymous` IN ('yes', 'no') THEN 1 ELSE 0 END) The denominator case statement isn't required if your values are only 'yes' or 'no'. You could change that to…

The embed token just identifies the card that needs to be embedded, it doesn't provide authorization.

Hi @DANIH Are you using a mega table or an HTML table? That would only work with an HTML table. Mega tables have limited HTML support.

Hi @Kenn Private embed requires the user be authenticated with the Domo platform in order to view the card. You could try public embed however anyone with the URL link can access that page/card.

Hi @ShaneB By nature of the Admin role they have access to all data in datasets so this isn't possible. You might be able to look into creating near-admin custom roles but you'd have to share all datasets with them as they'd no longer have access to the datasets they previously did.

@melyeo - Have you tried removing the all of your code (comments and all) and just manually typing in the function call manually in case there was a hidden character copied into your transform?

Typically when dealing with databases you'll want to narrow down your data as soon as possible to limit the amount of data being processed. Also, you'll want to make sure you're utilizing table indexes in your join and where clauses to improve querying response time. If they don't have any the might want to think about…

@Ashleigh - What type of source is the data being pulled from? A database?

Hi @Liliana have you tried using a pivot table and pivoting on your payor type field if you’re just wanting to display it in a table? If you’re wanting to do it in your data set you can utilize a pivot tile in magic ETL

@Shumilex To add my two cents I'd recommend going a bit further in the beast mode as MONTH will return the month number so if you're going multiple years in the future you'll get unexpected results. I'd recommend the LAST_DAY function instead which returns the last day of the month for a given date. CASE WHEN…

Hi @Kenn You should be able to just put in the iframe code that Domo provides when creating a Domo Everywhere link into your HTML. This is a good article which outlines a lot of the questions you might have with Domo Embed.…

@leeann_flowers You have to opt into each beta feature individually. Filter Views did get released as GA with their July release so you should have access to it now. https://domohelp.domo.com/hc/en-us/articles/360042936114-Current-Release-Notes#3.2.

Hi @melyeo look at your input dataset at the top. On the bottom of the box it’ll show the name of the table you can use. It’ll be in a grey box

Hi @user02700 You can look at the activity log and filter for your specific dataset. It’ll show you who deleted the dataset

Hi @sky00221155 this is likely because you have the same value multiple times in the joining column. You need to either add more columns to tour join to make sure each record is joining to a single value or you can use a remove duplicates tile in your ETL. Refining your join columns is the best way to go if it’s possible…