MarkSnodgrass Coach

Try switching to the HTML table chart type and see if that works.

If you are using a mega table, you can create beast modes that color the numbers like this: CASE WHEN budget > actual then concat('<div style="color: #ff0000">',`budget`,'</div>') else concat('<div style="color: #00ff00">',`budget`,'</div>') end This would turn the budget red if it is higher, otherwise it will be green.

No, there is no Mode function. You could potentially calculate it with a group by to count the number of values and then use rank & window to rank them by count and then filter to where rank equals 1.

@Newbie23 glad we could help. If you can mark any answers that helped you as accepted, that will help others in the community.

First I would make sure that the column is included in the select columns tile at the end of the ETL. Next, I would edit the card in Analyzer and click on the Date Range selector in the top right. Ensure that Hide Date on Card Details is not selected and that the appropriate Date Range Field is selected.

Since your field only contains the month and the year, I recommend using the split_part and concat function to pull out the month and year and set it to the 1st of the month. You can do it like this: DATE(CONCAT(split_part(Monthfield,'-',1),'/1/',split_part(Monthfield,'-',2))) Wrapping the DATE() function around all of it…

See if this works for you: CREATE PROCEDURE GetAllDates () BEGIN DECLARE l_cnt INTEGER DEFAULT 1; DECLARE l_region VARCHAR(10); DECLARE l_org VARCHAR(3); DECLARE l_ordered_item VARCHAR(100); DECLARE l_date DATE; DECLARE l_group_sequence INTEGER DEFAULT 0; DECLARE C_DATE CURSOR FOR SELECT DISTINCT REGION, ORG, ORDERED_ITEM,…

You can also make it a text in a beast mode by wrapping a CONCAT() statement around it and put that in the items list: CONCAT(yearfield)

You could use the Java CLI tool to do this, but it would likely be a manual approach. I know you want avoid creating an ETL, but creating a simple Magic ETL with a filter tile that looks at the current date and the date field in your dataset would be an easy and dynamic way to filter out the older data.

@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. This recent video is also a nice walkthrough showing you how to use it.

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. Another option is to only have this in your beast mode: CASE WHEN (COUNT(UserId) > 100) THEN 1 ELSE 0 END Then once your drag into the field you want on your card,…

@Mario did this work out for you what I suggested on your other post?

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. It's a pretty convoluted beast mode. I have started to move away from this and create another card that would sit right above the other…

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…