user003279

Discussions

Using date values for both x-axis and y-axis in chart
I have a dataset with a number of series (10-20) with two sets of dates that want to plot on both axis (see example below): x-axis - update date (date a schedule was run to project anticipated finish dates - each series will have the same update dates) y-axis - finish date (projected finish date for each series -…
Beast mode: Format numeric fields in Concat function
Is there a better way to format values in beast mode then using a bunch of case statements to insert commas (see example below)? The format function does not exist in beast mode. WHEN `Amount Value` >= 10000 AND `Amount Value` < 99999 THEN CONCAT('$',LEFT(CONCAT(round(`Amount Value`,0),''),2),',',RIGHT(CONCAT(round(`Amount…