Best Of

Re: Excel addin

Cbrack, thanks for posting your problem…I'm running into a similar problem with the Excel Addin. My issue has to do with filters that I have on various cards (so similar to your date range selection problem) and when I go to refresh a card that I've been using for the last 12 months or so, it'll download all of the data as though I did not have a filter on the card. I tried turning the filters on/off of the existing cards and it didn't solve the problem. I also went down the path of adding new sheets and opening up new Excel workbooks and the initial download of the data with the filters applied would work but any time I refresh, it would be as though I didn't have a filter on the card. I've just started working with Support and one of their solves works and that is using the "Filter View" and applying the same filter to all of the cards in the Excel file. While it works, it doesn't help me with the files that have a number of cards with a bunch of unique filters applied to each card (I would need to create individual files for each unique set of filters that I would want on a card or cards). I'll follow up if I end up with a better solution. My guess is that the latest App Version 2.0.20 that had a Build Date of 6/21/24 has screwed up some portion of the population using the Excel Addin…so you are not alone and hopefully we can come up with a solution that resolves this problem. Please follow up if you figure out a solve. Thanks!

FPA_720

2

Re: Calculating period over period change in Domo

If you have more than one year of data you'll need to account for the year, and not only the month. You can use the LAST_DAY() function to normalize your dates:

— % Change Costs

(

— current month costs

SUM(CASE WHEN LAST_DAY(`Your Date Field`) = LAST_DAY(CURRENT_DATE()) THEN `Costs` END)

-

— prior month costs

SUM( CASE WHEN LAST_DAY(`Your Date Field`) = LAST_DAY(DATE_SUB(CURRENT_DATE() INTERVAL 1 Month)) THEN `Costs` END)

)

/

— prior month costs

SUM( CASE WHEN LAST_DAY(`Your Date Field`) = LAST_DAY(DATE_SUB(CURRENT_DATE() INTERVAL 1 Month)) THEN `Costs` END) * 100

ggenovese

1

Change owner to a connector for someone who has left the company

Hi, How do you change user details to a connector for someone who has left the company

AbiO

1

Re: pfilter in Apps

Here is the link:

https://community-forums.domo.com/main/discussion/67957/app-to-app-persistent-filtering

Chris_Wolman

1

Re: Beastmode to return current month value? And what's the best card type to show the variance?

Hello @verytiredgirl,

There are no issues visualizing the Current Month Target and Actual. If you have data spanning multiple years, please include the year in the Beast Mode formula. Examples are provided for reference:

CASE
WHEN Month = MONTH(CURRENT_DATE()) AND Year = YEAR(CURRENT_DATE()) THEN Actual
ELSE 0
END

and

CASE
WHEN Month = MONTH(CURRENT_DATE()) AND Year = YEAR(CURRENT_DATE()) THEN Target
ELSE 0
END

Then you can visualize with Filled Gauge chart: