Best Of
Re: Limit/Filter to Top X
A gentleman and a scholar!! 🙇
I knew there'd be something simple. Thank you!
Re: Limit/Filter to Top X
You can achieve this with the Maximum Items option under Chart Properties > General. Everything outside the limit will be turned into an Other bar, which you can leave or then choose to hide two options down.
brycec
Re: Dynamic Currency Symbol Formatting
@brycec thanks for sharing this idea and for walking me through it at Domopalooza! Definitely something we'll consider for the future.
Re: sum based on distinct in another column
I added an indicator in the dataflow. Every code when it is the first time presneted in the data, the indicator is 1, then I sumed up based on this indicator.
sum(
case
when `code_indicator` = 1 then `mc_spend`
else 0
end
)
WizardOz
Re: Budget Account Descriptions
Append to dataset looks for a delimiter, a dataset and values. The dataset is what you want to append to. The values is a list of values to write to a dataset. If your dataset has 5 columns, you need to write 5 values. The delimter is to allow you to stipulate what seperates your values. Comma is default, but sometimes your values have commas.
So if you want to write 3 values to a dataset, you could have your values be:
value 1, value 2, value 3
And your delimiter would be a comma. However, if one of your values had a comma in it, using comma as a delimiter would return more than 3 columns.
value,1, value 2, value 3
for example would show up as 4 columns. In that case, you'd want to use a different delimiter, like maybe a pipe. So you could pass
value,1|value 2|value 3
with a | as the delimiter and it would write 3 values to your 3 columns.
Does that make sense?
Re: Budget Account Descriptions
1 - That works.
2 - No, they do not. It will write them to whatever dataset you instruct it to.
3 - You could have a function make a UUID and then include it in what you pass to the dataset. You can also grab metadata from the workflow, such as who started the workflow and include it in what you write to the dataset.
Re: Using Sum vs AVG for period Comparison
JasonAltenburg
I figured out a solution, I basically had to sum the column then divide the column to get the results to be static for that month.
Solution is as follows
IFNULL(CASE
WHEN Comparison Type = 'Revenue' THEN
ROUND(SUM(CASE
WHEN LAST_DAY(Fiscal Months) = LAST_DAY(CURDATE()) THEN Revenue
ELSE 0
END), 0)
WHEN `Comparison Type` = 'Driving%' THEN
ROUND(
SUM(CASE
WHEN LAST_DAY(`Fiscal Months`) = LAST_DAY(CURDATE()) THEN `Driving%`
ELSE 0
END)
/ COUNT(CASE
WHEN LAST_DAY(`Fiscal Months`) = LAST_DAY(CURDATE())
THEN `DriverName`
END) * 100, 2
)
WHEN `Comparison Type` = 'Empty%' THEN
ROUND(
SUM(CASE
WHEN LAST_DAY(`Fiscal Months`) = LAST_DAY(CURDATE()) THEN `Emptypercent`
ELSE 0
END)
/ COUNT(CASE
WHEN LAST_DAY(`Fiscal Months`) = LAST_DAY(CURDATE())
THEN `DriverName`
END) * 100, 2
)
END,0)
Re: Card Name vs Card Title (for cards that have the same title)
I second this. There are a number of applications that allow for an internal title and a display title. Beastmodes have this ability. The dashboards for my company share many of the same control cards but are forced to interact with joined tables differently. At this point, it can be quite confusing to assign the correct control to the right dashboard or app.
ZachF