MichelleH Coach

@nkasper I believe it's just to a specific sheet. Not knowing what your Google Sheet looks like, I would consider either one of these options: Import the Domo data into a separate Google Sheet tab and use formulas referencing the Domo data in the cells you want to fill Use a Domo ETL or View to isolate only the…

Hi @nkasper, I'm not sure how you did this in Alteryx but there is a Google Sheets Writeback Tile in the Domo Appstore: https://domohelp.domo.com/hc/en-us/articles/360042932334-Google-Sheets-Writeback-Connector

Minor edit to @GrantSmith 's suggestion, to re-format the percentage: CONCAT(SUM(`delivers`), ' delivers ', ROUND((SUM(`delivers`)/SUM(`total`))*100,0), '% delivery rate')

@Jmoreno I would recommend a Risk Heat Map card. If you wanted to replicate the same format, you can create two beast modes using the DAYOFWEEK() and YEARWEEK() functions for your series. More on Risk Heat Maps: https://domohelp.domo.com/hc/en-us/articles/7506837994007-Risk-Heat-Map

@Musetti Do you have any sorting or grouping in your Single Value card? If you do, try removing it and see if that fixes the issue.

@ozarkram It looks like you just need to cast your result to a date rather than datetime like this: CAST(STR_TO_DATE(`MFGDTE`,'%Y-%m-%d') as DATE)

Hi @ozarkram are you using ETL or Beast mode? Also could you share a few examples of what your MFGDTE values look like?

@Jones01 Do you have this box checked in your card? I believe the date must be visible in order to be affected by the global date filter.

@Jones01 You can customize your summary number by wrapping it in a CONCAT() function like the examples in this article: https://domohelp.domo.com/hc/en-us/articles/360043430093-Sample-Beast-Mode-Calculations-Card-Element-Transforms#4. Here is an example of what that could look like:…

@ozarkram You cannot have multiple fields inside the same SUM() function. Try changing to this: CASE WHEN YEAR(`DATE`) = year(CURRENT_DATE()) THEN `CURRENT_INVENTORY` + `NONCURRENT_INVENTORY` + `OLD_INVENTORY` END

@NathanDorsch Is it possible that the other filter tile, "Filter Rows", is removing the new data?

@NateBI Aggregate functions like SUM() and COUNT(DISTINCT) use multiple rows to return a single value. The way that the data is grouped or filtered affects which rows are included in the aggregate. When the data is grouped or filtered by a dimension, then the aggregate value for each category will be evaluated using only…

Hi @RanjitR try adding a second beast mode for the summary number that divides the average for the whole period over the number of weeks: ((SUM(`CY_TRANSACTION`) / COUNT(DISTINCT `STORE_ID`))) / COUNT(DISTINCT `YEAR_PERIOD_WEEK`)

@Jackie96 Where do the reports come from? Are you able to add the Domo email address to that distribution list instead of auto-forwarding through your own inbox?

@AJ2020 I don't believe this is an option currently, but I would recommend submitting this in the Ideas Exchange.

@mberkeley I don't believe there is an XLSX option for scheduled reports currently. Domo does have a paid add-on called Campaigns that gives you more customizable email options, including customizing file types: https://domohelp.domo.com/hc/en-us/articles/360042933494-Domo-Campaigns-App

@RajNadar It sounds like you need a CASE statement. You can read more about how these work in this Knowledge Base article: https://domohelp.domo.com/hc/en-us/articles/360043429933-Beast-Mode-Functions-Reference-Guide#2.3.

@EWold It depends on where your dataset comes from. If the dataset is an output of a dataflow, you should be able to see the query in the dataflow editor if it is from a MySQL or Redshift dataflow. Otherwise, I don't believe there is a way to produce the SQL query from a MagicETL.

@ozarkram What kind of dataset is it? Depending on what kind it is, you may need to import your new data using the File Upload connector and use an ETL to append the new and existing datasets together.

@Taichi I agree with @mhouston 's suggestion. To add to it, you could use ETL to recreate the respective pivot tables and then append or join them both together.

Hi @Kunal you can remove columns you don't need using the Select Columns tile in Magic ETL

@andres Is the date field a beast mode?

@andres Can you please share some screenshots of your date filters?

@louiswatson How are your two datasets related? Do they have a common field that could be used to join them in an ETL?

@andres You can change what the users see if there is no data under Chart Properties - General - No Data Message. I'm not familiar with this particular error, though, so you will have to test this to see if it works

Are both MajorDomo certification and Super User status required to become a Sensei, or is it one or the other?

@NathanDorsch I would recommend checking out the Domo Dimensions Connector. There are some geographic datasets that may have the information you're looking for. https://domohelp.domo.com/hc/en-us/articles/360042931454-Domo-Dimensions-Connector

@Kailin Do you have a drill path configured on the card? The Drill in Place option does not go down to the raw data table, so you will have to configure a Mega Table or HTML table in the drill to see the detail in order to drill from the dashboard.

Hi @jrtomici here is an article I wrote about a method to solve a similar problem: https://www.domo.com/blog/improving-supply-chain-logistics-with-geographic-proximity-matching/

@TylerMarshall How is your data grouped in the card? You many need to add a PARTITION BY and/or ROWS clause in your window functions