GrantSmith Coach

@ibtisamyyy Since you're wanting to do it by week you'll need to calculate the week number or the start of the week as a new column and then partition by that value in your Rank & Window tile so you are ranking per week. You can use a formula tile and the following formula to calculate the first day of a week:…

HI @user047019 You won't be able to do it in a beast mode but you'll need to use a Magic ETL. You can have your original input dataset and then filter through two filter tiles. One filtering where Parent_ID is not null (children) and the other where Parent_ID is null (parents). Then you can use a join based on the…

Hi @Seth you’d need to have your website handle the report selections and then dynamically change the URL of the embedded report for the last step

Alternatively you can also use a formula tile to remove the first character by using RIGHT and LENGTH RIGHT(`field`, LENGTH(`field`)-1)

REGEXP_REPLACE(`field`,'^\$(.*)$', '$1')

Hi @dylang91 You'll need to use an ETL unpivot your data such that your data is in the following format: CaseID | Date | Type 243339 | 2/10/2021 | Submission 243339 | 2/10/2021 | Approved ... Then you can use a beast mode to calculate your percentages per month: CASE WHEN COUNT(CASE WHEN `Type` = 'Submission' THEN `CaseID`…

Here's a Beast Mode that is doing what @amehdad is describing: DATEDIFF(LEAD(MIN(`Date Ordered`)) OVER (PARTITION BY `Account Number` ORDER BY `Which Order Number is this`), `Date Ordered`) This will calculate the difference between each order based on each customer.

Because of how the underlying architecture of Domo and data storage in general it's not like a Database where you can just simply run a DELETE FROM type command. What you can do is do a dataflow to input your dataset, filter out the rows you don't want and then write it out to another dataset.

Search for the Domo dimensions connector then use the calendar report https://domohelp.domo.com/hc/en-us/articles/360042931454-Domo-Dimensions-Connector

Hi @leeloo_dallas I'd recommend reading in your list of URLs as a dataset and then doing a left join from your dataset (on the URLs) you want to filter to this URL filter data and then use a filter to say where the URL is NULL . This will make it much more manageable and easier to maintain moving forward.

@Gus You need to pass your API token in under the X-DOMO-DEVELOPER-TOKEN header variable (assuming you generated it under More - Admin - Authentication - Access Token) not the Authorization header. curl -v -H X-DOMO-DEVELOPER-TOKEN:'{access-token}' "https://[INSTANCE].domo.com/api/content/v1/cards/<card_id>/export"

Ah I misunderstood the request. There is an export-data option with the CLI to export a dataset which can take a query so you could attempt to replicate the query your card is using and pass that along through the CLI but as @MarkSnodgrass mentioned you may need to watch the traffic to get the exact query it’s using

Hi @Gus Card definitions are stored in JSON format. You can utilize the Java CLI (https://domohelp.domo.com/hc/en-us/articles/360043437733-Command-Line-Interface-CLI-Tool) and the backup-card command to export a card definition to a file. It also gives you the ability to backup the drillpath as well.

Hi @abarrie23 This is a limitation of Domo excel plugin. If you want to download the dataset you have to go directly to the dataset in the UI and export it from there to get the entire dataset (Excel has an internal limit of 1M rows). See https://domohelp.domo.com/hc/en-us/articles/360042926134-Exporting-DataSets…

Another alternative is to use the HOUR function on your timestamp and put it in the corresponding bucket: CASE WHEN HOUR(`Time_From_Column`) >= 7 AND HOUR(`Time_From_Column`) < 15 THEN '7 AM to 3 PM' WHEN HOUR(`Time_From_Column`) >= 15 AND HOUR(`Time_From_Column`) < 23 THEN '3 PM to 11 PM' ELSE '11 PM to 7 AM' END

Hi @rishi_patel301 Instead of using STR_TO_DATE just use your time string you're wanting to add to your current date `Time_From_Column` BETWEEN ADDTIME(CURRENT_DATE() , '00:06:66') AND ADDTIME(CURRENT_DATE(), '00:07:05')

@Ashleigh based on the resulting HTML code on the cards it doesn't appear that you can center the summary number in relation to the chart below. I'd toss an idea into the idea exchange for it.

@FME_Cavinder Another alternative is to utilize a Table card and do something similar with your three different columns and split those out into different beast modes, dropping those into your table instead. This will have a little better formatting than a text card. Column 1: CONCAT( 'Order Number: ', FLOOR(RAND() *…

@FME_Cavinder You could get close using CONCAT and a text card and changing the font size in the General properties. You'd also use RPAD (right pad a string with another character up to the given number of characters) and the '\n' (newline) character. For example: CONCAT( RPAD('Year:', 30, ' '), RPAD('Month:', 30, ' '),…

Hi @gllrusso 1024 is a limit implemented by Domo. If you have values larger than 1024 characters you'd need to split the data as part of your query into multiple different columns. You might try reaching out to your CSM to see if they can do anything on the back end to increase it but it's likely not possible.

@sunny for your card is the public embed link correct? 404 means it can’t find anything at your URL. Are you able to take that URL and access it from a browser? Did you confirm the embed ID is the same as the Domo Everywhere configuration settings on the card?

@Ashleigh - Center the text in relation to what? The overall graph? The space for the summary number?

DataSet History from DomoStats is what you want. If you're interested in only the Domo Governance then you'd need to join to the DataSet datasets based on the data source ID to then be able to filter for just the governance type connector datasets.

There is a DataFlow History report you can pull which has prior executions for each dataflow using the DomoStats connector. There's another version for DataSet History as well in the DomoStats connector.

One other thing to note is you can use the name of the month instead of the number via a beast mode: MONTHNAME(`dt`) Then use that beast mode in your Category 2 field.

@user031170 Have you tried using the trellis option on your bar chart and graphing by year? And then sorting by Month then Year?

Hi @user031170 You can use a beast mode to calculate the Month for your date and another for the year of your date: MONTH(`dt`) YEAR(`dt`) Then sort based on those two beast modes. Are you also graphing by month in your date selector in the upper right?

Hi @kofagerburg Segments aren't available within a beast mode. You could try to use a DataFlow to attempt to aggregate all of your data and then stack it / append rows with your dataset such that you now have an "ALL" row. You'd need to make sure though to include the ALL value when doing your filtering. You'd then want to…

Case statements are helpful in situations like this where you want to conditionally add things together. SUM(CASE WHEN `IsRead` = 'True' THEN 1 ELSE 0 END) / COUNT(`Username`) Essentially we're saying give me a 1 if IsRead is True otherwise give me a 0 and then adding all the values together. This should allow you to…

You can also just set the target value under your chart properties: General > Target Value. If you're wanting 100% use 1.