GrantSmith Coach

@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.

Ah, so your data isn't a percentage but an actual number. Have you tried using a beast mode to calculate your percentage and use that as your value? Your target would need to be a percentage value as well so they're on the same scale. I don't know the fields you're using but a simple beast mode like the following should…

Hi @Hedger Have you tried formatting your column as a percentage in the Filled Gauge card column properties?

That should be correct.

Hi @Canioagain Im not a Salesforce user but on other systems sometimes I can export a report from the system to get the historical data and then combine it with the data from the connector using an ETL or view. It depends on the Salesforce platform if they even keep historical records of opportunities. Based on what I’ve…

@Jessica When I create a dataset I'll make sure to add some tags on the dataset denoting the workbench server so I know which workbench server specifically this data came from. It's an extra step and I haven't found an easy way to automated it yet but it's been tremendously helpful to make sure we can track down the source…

Hey @MarkSnodgrass , that's a great article! 🤪 @jordan_platinum Have you tried using a trellis option on your bar chart? https://domohelp.domo.com/hc/en-us/articles/360043428713-Applying-DataSet-Columns-to-Your-Chart#6.

It would be great for both types of tokens - API Tokens (Admin -> Access Tokens) and Developer Client ID and Secrets (developer.domo.com).

Hi @Stefan Since you're wanting to aggregate an aggregate you won't be able to do it directly in a card. I'd recommend using a Magic ETL dataflow to do your grouping based on the `User ID` field and count how many records you specifically have for each user. Then you can use the new activity count field as your series and…

@WorldWarHulk The code I provided should have a Filter -> Group By -> Filter and it should automatically have the code pre-filled out. Do you see it elsewhere in your ETL canvas? I'm guessing because the dataflow I copied it from is quite large it might be off your screen and you'll need to scroll down. Alternatively I've…

I'm glad you got it figured out! I was going to suggest programmatically calculating the number of months to divide by depending on the current year and month (untested - back of napkin): (CASE When YEAR(`EOMDate`) = YEAR(CURRENT_DATE) Then SUM(`TermCount`)/ ((SUM(`ActiveCount`))/MONTH(CURRENT_DATE)) When YEAR(`EOMDate`)…

Hi @user048760 You can do this with a beast mode to cause 0 values to return NULL / nothing: CASE WHEN `Rsvn` <> 0 THEN `Rsvn` END

You can use a group by with the COUNT aggregation to count how many records matches compared to the number of records in your original dataset then use a formula to do total - count to get the difference / records which don't match.

You can use an ETL with both datasets as an input and then left join them together based on your columns and see which ones are are missing values, that will identify where your records don't exactly line up.

You could attempt to use a magic Etl and the pivot tile to process your data into the pivot format you’re wanting and then use a standard table to display that information.

Hi @trevrobwhite It sounds like you're needing to do some custom processing and handle JWT tokens so the JSON Connector won't really solve your problems. You'll likely need to write a custom connector to communicate with your API endpoint. This does have the ability to generate JWT tokens, you'd just need to write the code…

Hi @Emma You need to check for your denominator to be zero, not your numerator. Try this (will return 0 if `Conservative Max Qty per plt` is 0) CASE WHEN `Conservative Max Qty per plt` = 0 THEN 0 ELSE `Total Stock`/`Conservative Max Qty per plt` END

Right however I’m lazy and want even fewer keystrokes :)