GrantSmith Coach

@Whimzyy You won't be able to pull in the color however you can tweak your spreadsheet and add an additional column to hold the status (You can go one step further with Google Sheets and restrict the values within the column to be only selectable from values in a list you specify to enforce data integrity). That column…

You could also select to compare against 364 days ago rather than 1 year. Since it's evenly divisible by 7 it lines up days of the week this year to last year.

Of course after I posted my original response I run into issues with the Bing connector. They did roll out a new version on yesterday which will now break any old connections with authentication errors. You'll need to go into the azure portal and create a new application and get a new secret and application id but it's…

@Moberling Domo should handle empty strings correctly when converting to a whole number using the Set Column Type tile (It converts them to NULL values). Do you have a screenshot of your ETL or some sample data? Is there a specific error you're getting? How is it not working correctly?

@user00820 - According to the connector FAQs it's utilizing v13. This connector uses version 13 of the Bing Ads API (https://bingads.microsoft.com). You shouldn't need to worry issues with v12 being deprecated

@Simon_King Have you utilized the javascript filter function? Something like (untested): var agentVersions = jsonRes.data.filter(function( i, n ) { return n.key==='agentVersions'; });

I keep it consistent where OVER budget is represented in the positive and UNDER budget is represented in the negative. I may make some colorization changes representing one as green and the other as red if it's good or bad respectively. This keeps a consistent definition to avoid confusion and also easily illustrates if…

@DP_BA What do you mean by floating integers? Typically when talking about data types floats and integers are two very different data types with floats (DECIMALS in Domo) containing a decimal point and integers do not. Is it just a matter that youre data is represented as a float with numbers always followed by .0? Do you…

@imelendez You should just need a simple tweak to your case statement to include an ELSE clause: SUM(CASE WHEN `rpt_job.authorized` = 1 THEN (`rpt_job.subtotal_sales`) / 100 ELSE 0 END)

@hamza_123 I've done something in the past where I calculate the current day value and the value from a year ago. The data set is aggregated on a daily basis (to allow slicing on day / week / month / year) and I simply use a MySQL ETL to join the dataset to itself shifting the current date by a 1 year interval (or 364 days…

You can use either UPPER(`Field`) or LOWER(`Field`) to check values without worrying about the case. For Example: SELECT `Field` FROM table WHERE UPPER(`Field`) = UPPER(`Value`) You can wrap the Field selection at the top in either UPPER or LOWER if you're not interested in the case of the original value.

@AnnK - How is the subtotal wrong? Are you using fields A or B as rows or columns in the pivot table?

@user060210 - It's treating it as a measure because it's not an actual number. If you do have a textual representation of a number you'll need to use the Set Column Type tile to convert it from Text to either Whole Number or Decimal. Then the card should treat it as a metric and not a dimension. As this would have to be…

@hamza_123 To my knowledge, Domo currently doesn't support filtering agregates. There is an idea exchange which was posted several years ago at https://dojo.domo.com/t5/Ideas-Exchange/Filter-and-Sort-by-Aggregations/idi-p/9224 to add this functionality but there hasn't been much update to it. I'd give it a like to make…

@nbrx - You'll just need to make use of some CSS styles on your image and convert your div to a span surrounding your text. CONCAT('<div align=center><img src="',`Picture`,'" height="130" style="vertical-align:middle"><span style="vertical-align:middle">', `Total Impressions`,' </span></div>')

@user014054 - You need to give your output dataset a name under the configuration tab. Click the "Output Dataset Name" and name it however you'd like.

Another option would be to utilize the replace text tile and use a regular expression: ^.*(\d{1,2}\/\d{1,2}\/\d{4}).*$ You'll put the above regular expression in the step in box 2. Also make sure to click the gear icon and select "Use RegEx". In step 3 place $1 as the replacement text.

You could also just treat it like an actual decimal number and utilize the following BeastMode: ABS(HOUR(TIMEDIFF(`lte_donation_phleb.stop_time`, `lte_donation_phleb.start_time`)) + (MINUTE(TIMEDIFF(`lte_donation_phleb.stop_time`, `lte_donation_phleb.start_time`)) / 60))

Try this: CONCAT( HOUR(TIMEDIFF(`lte_donation_phleb.stop_time`, `lte_donation_phleb.start_time`)), '.', CASE WHEN MINUTE(TIMEDIFF(`lte_donation_phleb.stop_time`, `lte_donation_phleb.start_time`)) < 10 THEN CONCAT('0', MINUTE(TIMEDIFF(`lte_donation_phleb.stop_time`, `lte_donation_phleb.start_time`))) ELSE…

@user11590 - You could utilize CONCAT to combine the different data elements. Note: The following code is untested. I'm utilizing your same logic for the dates to only display the dates where it's matching the logic of the revenue $ CONCAT( MIN( CASE WHEN DAY(CURDATE()) >= 1 AND DAY(CURDATE()) <= 18 THEN CASE WHEN…

@imelendez - @ST_-Superman-_ has it correct. It's a simple case statement to handle the nulls and replace it with 0. Depending on your aggregate level you may need to wrap it in a SUM() (or do this on the sorting section of the card building interface)

That's functioning as intended. NULLs always appear last. The actual data should appear after the nulls decending. What sort of behavior are you expecting? If you want to override the sorting behavior you can utilize a separate beast mode to handle the nulls differently and sort based on this new field rather than the…

@user14867 - You're getting a bunch of extra records because you're doing a large many to many cross join. What you'll need to do is reduce your dataset first before you do your join so you only have one record. It should just be two simple group by widgets. They will both spawn from your original dataset. The first Group…

I don't think there's a way to do this since the annotations are stored on the date level and not any filtered sublevel.

You'll want to reach out to your Domo contact for assistance.

@SusieQ - Have you installed the package on the Salesforce side for All Users? When you're connecting Domo to your Salesforce instance are you using the sandbox connection or your production environment connection?

Currently Domo doesn't have this exact feature. While @Aditya_Jain solution would work it won't allow you to keep other filters for the user to select. There's an idea that's been posted under the Idea Exchange specifically for this request:…

Alternatively you could utilize max and a case statement like the following MAX(CASE WHEN `lte_donation_general.hemoglobin2` IS NOT NULL THEN 1 ELSE 0 END) + MAX(CASE WHEN `lte_donation_general.hemoglobin` IS NOT NULL THEN 1 ELSE 0 END)

Have you tried adding the count of distinct donation IDs and adding the two together? COUNT(DISTINCT CASE WHEN `lte_donation_general.hemoglobin2` IS NOT NULL THEN `lte_donation_general.donation_id` END) + COUNT(DISTINCT CASE WHEN `lte_donation_general.hemoglobin` IS NOT NULL THEN `lte_donation_general.donation_id` END)

@SGuglietta Have you tried a different browser or logging out and back in? It seems to work fine for me.