-
Drill Path Filters Not Working
I'm having an issue where I've created a filter (it's filtering the month and the year formatted together). It works perfectly on the base card, but when I add a drill path and then try to drill into…1 -
Re: Creating "Other" group in a chart
If there is only one instance for each value (i.e. each customer name appears only once) then you could use: Title the beast mode formula something like "Adjusted Group" case when `Value` &…1 -
Re: How do you restrict the summary number to only sum the top x rows (already filtered in show x rows)?
You could fix this in an ETL transform by using the rank function to create a new column. Then you could use that column as a filter to get the top 10, top 20, or whatever version of this you would l…1 -
Re: How do you sort a calculated field as text?
This looks like there may be more than just the text field being sorted since I think the logical progression would start with 120. I would take a look at your sorting filters first. Then, in general…1 -
Re: Calculating 7-Day Moving Average (Beastmode)
This definitely works. Also, it may be easier to use the ETL transform "Rank and Window" with the subfunction average for the window of 7 days depending on how your data is laid out. If the…1