MarkSnodgrass Coach

@Frank_Sodano to get the single value card to show the actual number instead of the abbreviated number, set the value format to number. Then in the Chart Properties - General, set the Divide Value By to None.

I would look into using the Java CLI tool to do this. Here is a link to the KB article. https://domo-support.domo.com/s/article/360043437733?language=en_US This recent video is also a nice walkthrough showing you how to use it. https://www.youtube.com/live/M8cl0B2rScE?feature=share

Welcome to the community!

I would recommend changing your data type on the schema tab in your workbench job from date/time to date. This will keep Domo from changing the date because it won't try and adjust your time since there is no time on a date data type. Basically, if you aren't using the time element of the datetime field, change your data…

Here is a non-regex solution you can do in Magic ETL with the formula tile. CASE when INSTR(fieldname,'k') > 1 THEN STR_DIGITS(LEFT(fieldname,INSTR(fieldname,'k')-1)) * 1000 END The INSTR() function will find the character position of the letter k. If it finds it then it will do the work in the WHEN statement. In the WHEN…

@Dot_Perez if you add the Activity Log dataset in the DomoStats Connector, you will be able to retain a complete history. There are a lot of good datasets in the DomoStats Connector that may be of interest to you for this purpose.

@faisalnjit In the Chart Properties - Change Value Options you can set some actions for No Data Handling and No Data Message. Try setting that to different settings to get the result you are looking for.

@GrantSmith might know the answer to this.

If it works without the project filter, I would suggest having the connector set without a filter and then create an ETL that would then filter to the specific project that you are interested in.

This will likely involve creating new classes in the CSS section of the DDX brick where you would define your colors. You would then need to go to javascript section and then apply logic to use a certain class based on the values.

I have users using Forms on the most recent iPads and are not having issues. I would recommend that.

In your y-axis, choose Format and Display as Number and set the number of decimals to 1. Then in the Chart Properties - Data Label Settings, select Use Scale Abbreviation. This might get you what you want.

You might be able to do this if you use variable controls as your filters. You can then build beast modes to set the proper filtering by targeting the specific variable and date field that you want to use.

You can't do an aggregate on aggregate without using an OVER clause (window function) or the new fixed functions. Here is the KB article on fixed functions. https://domo-support.domo.com/s/article/4408174643607?language=en_US Another option is to only have this in your beast mode: CASE WHEN (COUNT(UserId) > 100) THEN 1…

@Mario did this work out for you what I suggested on your other post? https://community-forums.domo.com/main/discussion/54212/difference-in-business-hours

I would suggest doing this in Magic ETL. You can use the Join tile and do an Inner Join between the two datasets and join on both Job Title and Description (assuming the data is spelled the same in both datasets). After the join tile, add a formula tile and create a column called variance that subtracts (or divides) the…

You could create a variable control that is a date field and then in your beast mode evaluate the variable date against the date in your dataset to exclude or include.

Have you looked into the Java CLI Tool? That might get you what you want.

You can show multiple summary numbers in the summary number box by creating a beast mode to show those numbers. Here's one previous post that talks about how to construct the beast mode. https://community-forums.domo.com/main/discussion/32344/formatting-multiple-summary-numbers-with-commas It's a pretty convoluted beast…

If the date column in your dataset is the date something was last promoted, you could create a beast mode called "Days since last promoted" and use the following formula: DATEDIFF(CURRENT_DATE(),datefield) You can then put this beast mode in your filter and and turn on quick filter. It should be a slider control and you…

You would need to do this in a two step process. In your split columns tile, don't try and label the columns as fruit, vegetable, etc, yet because you don't know what is what yet. Instead, label the split columns as split1, split2, split3, etc.. for however many splits you are doing. After the split columns tile, add a…

It would help to see the formula you are using in your beast mode. It's also important to note what you have in your sorting and what type of, if any, aggregation you are using for that field in your table card. All of these can affect how values are calculated.

To get the "System" group, create beast mode that uses the SPLIT_PART function, like this: TRIM(SPLIT_PART(fieldname,'|',1)) You can then use this field as your grouping and aggregation.

Can you show what you would want the end result to look like? Also, is this for a table card? Or some other visualization?

This may not work for you depending on what your series looks like, but in the Chart Properties → General, change Sort on Totals to Descending and see if that does it for you.

The bar + line requires you to have everything as an aggregation. You would need to create a beast mode for each partner name and what value you want to aggregate. You would then go to your color rules and select that beast mode name and assign it a color.

you can use the date that they select with the variable and use some functions in your beast mode to apply to the entire month. This would get you the first day of the month: DATE_SUB(`dt`, INTERVAL (DAYOFMONTH(`dt`) - 1) DAY) This would get you the last day of the month LAST_DAY(`dt`) You can use these functions while…

You could use a variable that would allow the user to select a date. You would then create a beast mode that creates the open/closed logic. Something like this: CASE when variablefield >= create_date and varialbefield <= last_update then 'Open' ELSE 'Closed' END You would then put this beast mode in your filters section…

I believe it is a limitation with the Excel option when choosing Send/Export. I just tested with an mega table card that had 84k rows. When I chose Excel, it only exported 50k rows. When I chose CSV, I got all 84k rows.

You should look at the Datasets History dataset in the DomoStats connector. This has the information you need for this.