ggenovese Coach 
-
Re: Beast Mode Case-When Grouping Not Supporting Occurrence Count
Hi afieweger I don't believe what you're looking to do can be achieved with a beast mode, you would have better success doing this in an ETL. The issue is that your distinct count will count all bm v…1 -
Re: Trying to get different values into the pivot table
Hi @Analyst_Mike You may want to try this update, if it doesn't work it might be helpful to share a screenshot of your pivot table so that we can see how it's configured: CASE WHEN MOS_Year = 2023 AN…1 -
Re: Is there any way to create a grouped Bullet Chart?
Hi @jslatham, I think the trellis options in analyzer would give you something similar to what you're looking for but it's not available on a bullet chart unfortunately. The only alternative I can th…1 -
Re: Cumulative Sum for the Year on a table card
Hi @zaclingen_fwm, You can do this with a window function: SUM(SUM(`Monthly $`)) OVER (PARTITION BY `year` ORDER BY `month number` )1 -
Re: Pagination issue with JSON No Code Connector (API PennyLane)
Hi @Makam - I reviewed the documentation for that API and I see that the "List Ledger Entries" and "List Ledger Entry Lines of a Ledger Entry" endpoints use a page based paginatio…1
