GrantSmith Coach

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…

@Jbrorby - Thanks for following up and your contribution to the Dojo community!

@User_32612 I'm assuming you're using a beast mode for your x-axis - do you have any fields listed in your sorting? That may throw off your grouping. You may want to come up with a similar beast mode to define your sorting such that anything pre week 16 would be a value of 15 so that they'd sort and group based on the same…

Thanks for the information @jaeW_at_Onyx I'll have to play around more with the syncing in custom apps.

Correct you can only write to an existing dataset in AppDB not in Domo proper

Hi @the_tree What specific issues are you running into? What are the error messages you're getting? Are you trying to write to a new dataset? Has the dataset been correctly defined in your manifest file?

Hi @Daneia , I believe this is because, looking at the connector FAQ tab, it's using version 5.0 of the Instagram API which has been retired. They're on v11.0 now. You could try and reach out to your CSM or support and see if they would get that API connector updated.

Hi @kacy How are you ingesting this data? Are you attempting to do an UPSERT? What it boils down to is that the column you're using to identify a row's uniqueness isn't unique. You'd need to reimport your data such that you don't have duplicate IDs if your keys are set to the column that denotes uniqueness. Alternatively…

Hi @jbandley @MarkSnodgrass offer's a good solution. I was going to suggest another option utilizing SUBSTRING, INSTR and LENGTH but his is a simpler option.

Hi @user069636 Whenever I typically need to do some period over period comparisons I actually restructure my data so that I have a report date and a "comparison date" (the actual date the metric was recorded on) and calculate it as necessary. This allows you to have custom defined periods (like 2 weeks ago and a week ago).…

Hi @nbrx Whenever I typically need to do some period over period comparisons I actually restructure my data so that I have a report date and a "comparison date" (the actual date the metric was recorded on) and calculate it as necessary. This allows you to have custom defined periods (like 2 weeks ago and a week ago). You'd…