Best Of

Re: Distinct Count of Donations and Distinct Count of Donors with those Distinct Count of Donations

One other approach would be to have a few common, preselected date ranges that will be used and then you can use Magic ETL to produce the groupings based on those date ranges. Users wouldn't be able to select any date range, but they'd at least have some options.

ColemenWilson

1

Re: Calculating MoM, YoY, YTD in table

Hi @mroker ,

So first, you'll need to do a bit of data cleanup. Having the names of the months at the top isn't the best hygiene, but I have you covered. If you can get your data to just be Category, Date, Sales, that's cleaner. If not, you can transform it. Anyway, after that, you just need some basic formulas to get MTD, YTD and YOY.

I made a video for you showing you how to do it: https://www.loom.com/share/f0dfe27e114d4eda8ed4933449bf1197

Best,

John Le

You're only one dashboard away.

More video solutions at: https://www.dashboarddudes.com/pantry

DashboardDude

1

Re: Auto-Hide Buzz on Default

I love this idea. My users also don't like it when they have to clear their cookies and re-hide Buzz (especially users who access several instances). This would resolve that problem.