MarkSnodgrass Coach

you can use the like operator along with the % sign which acts as a wildcard when Business Division_p LIKE '%Biologics%' then 'Bio'

You can do this by using a window function in a beast mode. You may need to ask your CSM to enable window functions in beast modes. Once that is enabled you can create a beast mode like this: RANK() OVER (PARTITION BY YEAR(date) ORDER BY SUM(valuefield) DESC) You would then add this beast mode to your filters and filter to…

If you are in a table card, one way is to drag that same column in again as the 1st column and choose count. Then in the chart properties, General - Hide Columns, enter 1. This will hide the 1st column and the aggregation that you chose will remove the duplicates.

You can construct the format through some elaborate beast mode syntax, but it will still be viewed as text. If you search the community for beast mode formatting, you should see some examples. You could add a round function to eliminate pennies very easily, but the commas and $ signs require an elaborate beast mode.

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.