Beast Mode

Beast Mode

Can I use the result of an aggregate beast mode as a filter for a dashboard/app page?

Member
edited August 2024 in Beast Mode

I have a beast mode that is comparing actual performance to a target (by categories) by taking the sum of actuals - sum of targets over an arbitrary date range, defined by user input into variables on the dashboard page. This works great as a quick filter control for an individual card, but when I make a filter card using that beast mode and put it on a dashboard with the cards it was able to filter as a quick filter, it doesn't apply to any of the cards on the dashboard.

I'm assuming an aggregate function used as a filter needs the context of the specific card it applies to to determine which rows it should filter. But I thought I'd ask in case someone knows where I'm going wrong or knows how to work around this. I don't think I can determine performance in the ETL because of the variable date range option on the dashboard (They can select any start/end date in the last 2 years).

Thanks!

EDIT: First comment made me realize I should have mentioned the beast mode is saved to the dataset! Thanks Colemen.

EDIT 2: Problem was user error; I was using FIXED functions in the sums which I failed to revert after realizing how to get the results I needed without them.

Welcome!

It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.
Sign In

Answers

  • edited August 2024

    Have you saved the beastmode to the dataset?

    If I solved your problem, please select "yes" above

  • Yes, it's saved to the dataset. That was the first thing I checked when it didn't work.

  • I think I found my problem. I added a FIXED function to my beast mode while doing some testing before realizing I could get the results I wanted without using FIXED and didn't revert that in the beast mode I ended up using as the filter. Removing the FIXED function and adding the beast mode to the card filters made it so that the dashboard filter applied to the cards.

Welcome!

It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.
Sign In