MarkSnodgrass Coach

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.

I would try breaking the two conditions out into separate conditions and see what they return. This will help you identify which part is the issue.

I'm referring to up here by clicking on the pencil. Then click on Format Choose Display as Number Hovering over the legend should result in this

Is your y-axis set to a number? Or something else? Make sure it is set to a number by editing the formatting of the y-axis value.

In the chart properties, your data label settings are likely using these two in the text section: %_CATEGORY_NAME %_PERCENT_OF_CATEGORY You can use the same ones in the Hover Text Settings, so that they display the same.

You could pull this off using variables as well as a window function to create a row count. To create a row count, create a beast mode like this: SUM(SUM(1)) OVER(ORDER BY Start) Change Start to whatever field you need to order by in your dataset. Create a variable control. I would use a radio button control that says…

In the value fied, format it as number. Then in the general properties, set Divide Value By to None. That will show the actual number.

You would need to do this in Magic ETL. You can use the filter tile to filter where job_name equals QC_Job and then use the join tile to join back to your main dataset and do a left join on content_id with your main dataset being on the left side of the join. The left join will allow all of your main dataset rows to come…

If you are unable to change how the data is coming in as @ST_-Superman-_ suggests, you can use the LPAD() function to add the leading zero, when necessary. You can do this in Analyzer by creating a beast mode, or in Magic ETL using the formula tile. It would look like this: LPAD(zip,5,'0') This will add a zero to the front…

That is strange. There used to be a map of the world (as the video in the KB article demonstrates) that allowed you select what city you want to use and then would select the correct time zone. This definitely seems like a step backwords and it is missing more than Mountain Time Zone. I am not seeing Pacific Time Zone…

If you only wanted to show dates that are the first of the month you could create a beast mode like this: CASE WHEN DAYOFMONTH(datefield) = 1 THEN datefield END You could also create an include/exclude filter logic and then drag this beast mode into your filters and filter to include: CASE WHEN DAYOFMONTH(datefield) = 1…

The best way to fix this would be to build a Magic ETL dataflow with this dataset as the input dataset. You can then use the Alter Columns Tile to change the data types, or you can click on the Input Dataset and click on Data Handling and choose what type you want to change it to as well as clicking on the wheel cog to…

Yes, you can create a beast mode that simply has this: CURRENT_DATE() You can then use the textbox, dynamic textbox or even a table card to display the field.

In picture 1, I think you need to make it a nested case statement. The way case statements work, they exit once they find a condition that is true. A nested case statement would look like this: CASE WHEN condition1 THEN CASE WHEN condition2 THEN 'Include' ELSE 'Exclude' END ELSE 'Exclude' END

The likely reason that you are running into issues with the two tiles is that you are likely using the same column name in both tiles. This results in the 2nd tile overriding what was in the first tile. I would suggest that in the IC Exception formula tile, you label the field as IC Exceptions. In the END Exception formula…

@SaloniShah happy to help. If you can mark as accepted any of the above answers that helped you, that will help others in the community.

You can create multiple formulas with different field names in the formula tile. You are not limited to 1.

I think what you want is this: (Customer Type != 'END') OR (Customer Type = 'END' AND Bill-To Customer Name IN ('A','B','C') 

While you can write formulas in the filter tile, for this type of logic, I would suggest adding a formula tile before your filter tile where you determine which rows to include or exclude and then you can just filter to include in your filter tile. In your first scenario, your formula tile logic would look like this: case…

I asked the same question to my AE the other day. It seems odd that there is not a link to it from the Tool Downloads section in the Admin Center of the Domo instance where the old Excel and PowerPoint Plug-ins are currently located. Here is a link that will take you to the MS Appstore and filtered to the new Domo add-ins.…

If your data is in 2 rows then you can use the dynamic textbox and use the last and penultimate data to display it like this. If your data is all in 1 row then I would suggest using the Multi-Value card under Gauges and you can use the Gauge Value and Target Value. This gauge has quite a few properties and can be…

I believe these changes are already in the works to give users more granular control over the layout and spacing. It was discussed during the March Community Meetup. You can watch it here: https://www.youtube.com/live/PVQm5-_aJm0?feature=share