Best Of
Re: Please help me write this filter formula:
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 tile, label that field as End Exception. Then in your Filter tile, set your filter to where IC Exception equals Include or End Exception equals Include.
Re: Adding filtered count to dynamic text box
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 configured in a lot of different ways to display the information you want.
A third option is to use the Textbox card and build all of your dispaly in a beast mode using CONCAT() to combine your text with your data.
Re: Adding filtered count to dynamic text box
Have you tried using a beast mode to calculate the difference between now and 5 days ago and counting them?
COUNT(CASE WHEN `date_field` < CURRENT_DATE() - INTERVAL 5 DAY THEN `date_field` END)
Re: Can dashboard separator width be reduced?
Thank you. I appreciate the response. I hope that they continue. I generally try to optimize intelligence-presenting screen area, and I'd love to improve this as well.
Re: Compare last 12 complete months to prior 12 months
I think this is why the Period over Period charts aren't used too heavily as they have some pretty rigid code tied to them. I often use the standard Line + Bar chart and create a few beast modes to have a more flexible period over period chart. I walk through how to do it here:
Re: Null values in date fields
Instead of this:
Case whendiscarded_atis NULL andarchived_atis NULL then count(invoice_id) else NULL end
try this instead:
SUM(Case whendiscarded_atis NULL andarchived_atis NULL then 1 else 0 end)
Using 1's and 0's with SUM is another way to count items instead of using the COUNT function.
Re: Connecting to the Powerpoint Plugin
Domo released a new Office add-in at DP23. I would try using it instead.
Re: Beast mode errors in dataset views
@Jobur I'm glad you got it to work in the dataset. Yes, I've found that calculated columns don't always perform well in dataset views, especially when columns or removed or grouped.
Re: beastmode
@NIKKI Do you plan on having a single row per value of the Indicator Text field? If so you do not need to partition by that field in your card because your data will already be grouped by that field. Also, note that your denominator will always be 1 in this case based on your current formula. If that's not what you want, then you can remove the word DISTINCT from your formula to calculate the percentage based off the total number of rows.