GrantSmith Coach

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…

Hi @DANIH Can you put your MySQL code here for us to review?

Hi @Khan You'll want to calculate the percentile rank within a Magic ETL before you pull it into your card. Use the Rank & Window tile and Rank your times. Add a Group By tile to get a Count of the total rows in your dataset. Join it back to the Rank & Window tile so that the total row count is now a column next to every…

Substring starts at position 1 so you'd need to start as position 3 with a length of 2. It'd look something like this using a string operation tile:

You can utilize a formula tile and use the LEFT AND RIGHT functions to get the left 2 digits or the right 2 digits but note that if it’s not 4 digits you’ll get unexpected results. Alternatively you can utilize the sting operation tile to pull out pieces of a string as well

Hi @dacorson Magic ETL 2.0 doesn't know if your format is MM/DD/YY, DD/MM/YY, YY/MM/DD... etc by default. You need to explicitly define your format using a format string within the Alter Columns tile for your field. To do this you need to click the gear icon, then select the Date Settings option. In here you'll need to…

@Daneia Have you tried explicitly pulling the missing days to see if that will pull in the data for you via the Domo FB connector? Alternatively you could export the missing data from the FB platform, upload it into Domo and then utilize a Dataset View to UNION / append the data together and utilize that new dataset view…

You can create your own custom app if you want to do a custom visualization but it'd be a bit difficult to maintain if you're wanting to utilize custom apps for every single dashboard you're wanting. You can check out https://developer.domo.com to see how you can extend the Domo platform. This may also be something to…

Hi @bp_paulo_fernandes User filters are applied to the entire dataset, there isn't really an 'ALL' option like in Power BI. You might be able to aggregate your data via a dataflow and join that to your original dataset. This way each row would have the values from the entire dataset when each row is filtered via the user…

Hi @tobypenn How is your data formatted? You'll likely need it to look like: Quarter | Week | Activities Q1 | 1 | 500 Q1 | 2 | 450 ... Q4 | 13 | 1000 You can then use the Week as the x-axis, Activities as your y-axis and Quarter as your series.

@Daneia What is the issue you're running into? Is it returning an error message? No data? Are you able to pull that data from the Facebook platform using their website?

Hi @jmcgurl You'll want to have your case statement inside your aggregate: COUNT(DISTINCT case whenate WEEKDAY(`datefield`) = 1 AND `SESSION PURPOSE` = 'FULL_STORE_SCAN' AND `REGION CODE`= 'NA' AND `REGION CODE`= 'AP' Then `STORE NO` End)

Glad you got it figured you!

Hi @emmanuel_fabre It appears that the NULLs in your data are causing some issues which is odd because the AVG should handle nulls correctly. In any case I was able to utilize this beast mode to get around the nulls or 0 values as outlined in your excel document: AVG(CASE WHEN `Total Conversions` > 0 and `Total Views` > 0…