Best Of
Re: Is there a way to nest beast modes in another beast mode without exposing the full calculation
Unfortunately, the beast modes will expand out when you include them in another beast mode. I agree that it would be really helpful if they did not do this, as it would make the code a lot cleaner and more efficient.
I'm not sure if it has been submitted in the Ideas Exchange section of the Dojo, but I will definitely vote it up if you posted it there.
Re: Aggregation on Lag/Lead functions
This isn't possible as you can't aggregate a window function within a beast mode. What you'd need to do is perform your lag in an ETL and then calculate the average in your card. You may lose some filtering abilities as it's going to be pre-aggregated.
Re: Custom Sorting
Update - I was able to correct the Day of Week to make it sort in order.
I made a new beast mode called "Day of Week Transform" where it just contained
DAYOFWEEK ('Date')
Then I dragged that beast mode into the sort and I was able to sort Day of The Week correctly.
The dayparts (hours), I'm still stumped on...
Re: Adding values to a custom chart
Thanks, @MarkSnodgrass The goal was to set the ID of each square of the chart as a concat of its x & y categories and then assign a count against each cell of the 5 x 5 matrix (25 cells). If the colour of each square were pre-set, the only thing I would be missing would be the data label, as I could just put a count against the concat categories. I will play with it tomorrow and see what happens.
However, you have presented an excellent example of how it could look if the requirements were simply a gradient of colours. If I can't get it to work, I will regress to this process as I've managed to fix my sort by including dummy 0 values when no data is available and "checking" show 0 values, too.
It's a shame there aren't more options for colour logic in these charts because overriding and filling a cell with a specific colour is almost impossible but could be incredibly valuable.
Samuel.
Re: Adding values to a custom chart
Hi Mark,
Thanks for your response - I've been watching a lot of the content you have put out on custom charts on behalf of DOMO with this, so I appreciate your time and want to thank you for your help with SVG files and the custom chart format.
Unfortunately, the Risk Heatmap card suffers from the same problem as any other table where if you want to use a custom sort through a beast mode, any cells with 0 values will not be captured and sorted correctly, leading to the categories being out of order, (unless I'm missing a trick?).
The other issue with the risk heatmap is that as it's a gradiated colour pallet, the set cells that need to be a specific colour cannot be coloured correctly. Part of the work we will be doing in other graphs is trending the time-series of the count of each colour bucket to differentiate severity visually. So the set colour per cell is, unfortunately, crucial for the story we are looking to tell.
Samuel.