GrantSmith Coach

@mamedu I've typically just had two separate fields as part of my dataset. One which has the HTML code to make the link clickable and another with just the URL like @MarkSnodgrass suggested. You do have some data duplication but it gives the interactivity of a link within the page but then also allows the users to have…

Hi @user037924 Have you looked at the Chart Properties > Colors? This will allow you to assign specific colors to values you choose. You can also change the opacity of the colors if that's more of the look you're going for.

Hi @jamesdII, Have you tried just comparing the dates themselves? CASE WHEN current_date <= `Target Date` then 'Future' else 'Historical' END This treats a target date of today as in the future. (simply change <= to < to exclude today from the future group. The other issue with your current logic is that both conditions…

@user06209 I'm not certain why you can't do a period over period graph based on hours, seems like you should be able to. One way you can get around it is if you create a MySQL ETL to join the table to itself based on the time being 48 hours before and labeling those oclumns with a suffix ('_48ago' for example). This is…

@user06643 - You can utilize windowing functions within a beast mode calculation. For example: sum(`visits`) over(partition by `channel`, `store` order by `date`) MySQL has supported windowing functions since version 8.0 so this should work in MySQL as well if you're at or above that version. If not then you'd need to…

@user02162 If you want the users to be able to add PDP policies to the data sets or data flows then they need permission to edit those. You'll either need to manage that for them as well or give them permission to edit the data flow / sets.

@cjack-PML - Have you tried plotting the seconds value as a number (total seconds - 65, 58, 12, 38, 22) rather than the string formatted version (00:01:05, 00:00:58, 00:00:12, 00:00:38, 00:00:22) of your seconds? You could then utilize your formatted string as a tooltip and then change the hover text or display text to…

The issue was with the way Google redid their authentication. The general YouTube connector still doesn't work but I was able to get the connections utilizing the YouTube Enterprise Advanced however there were a few caveats. Since I was utilizing a brand page instead of the actual google account to get information tied to…

@rgbuckley Because how the 100% stacked bar works and expects a single column for a series it's not quite possible. However! You can hack around it with a normal stacked bar and then plot the percentages. You'll need to make distinct beast modes for each type of Pay Cat Name using the same formula you posted earlier, just…

@Cartergan - You'll likely need to do a full outer join of the dates table and a distinct list of your agents to get the possible combinations of agent and dates. You can do this as a transform and then select that table and left join it to your qualtrics_responses table on agent and date. This should populate all possible…

@user017486 How are you uploading the data to Domo? What connector are you using? You should be able to encapsulate the value containing a comma with double quotes to treat it as a single value: Column 1, Column 2, Column 3 one, two, "three, four"

Can you filter that value out via the card filters?

@hamza_123 Which column are you attempting to hide? If you want to Hide a column in the flex table you can do this under General settings by selecting Empty from the drop down for the Column #. You can't utilize a beast mode to do this because the beast mode will look at each row individually. You'd need to calculate the…

@WizardOz This is a very common question. The limitation of beast modes is that it can only look at a single row at a time so you can't do a cumulative sum like you'd need in this case via a beast mode. You can however utilize a MySQL ETL data flow to get the information you'd need. The following is untested back of napkin…

I think that is a limitation of the API / connector. You could utilize an ETL or card filter to ignore the records based on the date or the 0 values. 

@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>')