Best Of
Re: Create Nested Beast Mode that nest more than two levels
If we could nest beast modes 5-10 levels, that would make it way easier for us to write complex formulas.
It would also be great if we could click a button to unnest the beast mode so we can see what the full formula looks like without opening it in a new window.
Thanks!
Jemiller
Re: Total row not calculating right
@TC1199A Do you have any aggregation set on your volume field? It sounds like it may be set to calculate the average rather than the sum.
Re: Total row not calculating right
@TC1199A I'd recommend using a FIXED function instead like this:
sum(sum(Volume)) FIXED (BY Customer,MONTH(Date))
Re: Modify formula
MIN(MIN(CASE WHEN taskEventStatus = 'Completed' OR taskEventStatus = 'CompleteLate' THEN 'Yes' ELSE 'No' END)) OVER (PARTITION BY `PlantID`,`Date`)
You can use a window function to return the minimum value (No if any of them are No) for each date and plant ID.
Re: Running Total Beast Mode
Have you considered using the Chart Property "Fill empty data cells with 0"? It is under General in the Pivot Table card.
Re: WE NEED YOUR FEEDBACK: What topics would you like to see covered during our monthly meet-ups?
I'd love to see some examples of well-designed and function rich dashboards using the new AppStudio feature in combination with Workflows.
Re: Magic ETL Tiles groups for clearer organization and visibility/observability :D :D :D
I 100% agree with this. If we could group tiles together along with colorize tiles, it would make complex ETLs much easier to work with. I would also extend the colorizing tiles idea such that when you colorize tiles and run a preview to see sample data from each tile it also colors the column headers. It would make it much easier to tell where a column came from in your ETL flow.
DomoDork
Re: Is there a way to use the LIKE operator to make it case insensitive, specifically in the ETL?
Yes. you should be able use the LIKE operator in the filter tile. I would add the LOWER or UPPER function to make it case insensitive. Adding the % sign around your string will make it a wildcard search. Like this:
LOWER(statename) LIKE '%tex%'
Re: Google Slide Integration
This would be a great asset. A lot of companies rely on google products for sheets/slides and reserve Microsoft licenses only for the finance team
p1390
Re: Google Slide Integration
If I could vote up on this idea more than once, I totally would. Great idea!