-
Next Up Summary #
I want to write a summary number that notes the "Next Up" City in my data. X axis are city names (chronological sorted on Closing Date), Y Axis are values. Some of those cities are Closed, some are Ongoing - I can't use the series to break that status out visually by color, because I'm using a dual Y axis to show two sets…
-
Summing column values based on dates
I'm trying to sum values as they fall within a range of dates. I think I have to do this in Beast Mode, because the Window function in ETL doesn't seem to allow for this though I have never successfully used it. I am not proficient in MySQL. I want to sum the 'EDP Visits' between Sundays. In the table below, the values for…
-
Beast Mode update
It seems like in the new Beast Mode you can't look through a list of previously written calculations on the data source. When you open Beast Mode via the 'add a calculated field' button you can only see a blank template for what you want to work on. It also seems like a Beast Mode calculation isn't available outside of the…
-
Filters / need for publication Groups?
Hoping for some feedback on this -- In our instance, we've used publication groups in order to keep some users from seeing data that doesn't pertain to their region (this structure pre-dates the newly released PDP policies). Reason being that, if a card was built for Columbus, the front end would always disply Columbus…
-
App Store Time Zone - FYI!
I ran into an issue using the Twitter Quickstart. Wanted to share as I bet others need this fix. The Quickstart comes with a card called Best Times to Tweet. The X axis is market (UTC), and the Beast Mode that comes out of the box called "Hours of Day (UTC)" takes the field 'Created By' and formats it into h:mm -- which…
-
Drill cards creating unique URLs - Admin cleanup
This is more of an instance governance question than a Builder question: I am going through the list of Cards in Admin > Cards to do some cleanup. I see dozens of cards with the same name as a drill layer I use. It shows me as the only person with access to those cards (which would not be true of the parent card if these…
