MarkSnodgrass Coach

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…

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