Best Of
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` )
Re: How do I add a Field to the 'Card Title' or 'Description' even if it is not a card filter?
@brycec LISTAGG is a new one for me, thank you! I played with it, and it also works with DISTINCT, so I'll add that to your suggestion:
REPLACE(LISTAGG(DISTINCT `Current Pages), ',', ', ')
Re: How can I set up a text box Variable that can search for a text string in a field?
Great, I will give this a shot. Thanks!
levi_kim
Re: How can I set up a text box Variable that can search for a text string in a field?
Yeah I realized after the fact that the link wouldn't work for you.
Navigate to the App Store and search for "Searchable Filter Card"
Re: AVG() Beastmode Handling 0s?
Resolved:
Removed the ELSE statement.
distinct_total_apples
CASE WHEN row = 1 THEN total_applesELSE 0 END
NateBI
Re: Cutting the Strings in updated MagicETL?
BryceC - a free Answer for your stat line. Well done 😎😎😎
Re: Customizable Average Calculation
Yes, I would love more flexibility for reference lines. Here's another idea that fleshes that out even more, if you want to add votes to that one as well:
Re: How to update Start Dates of projects & tasks ?
For projects, there is no start date, only the created date of the project.
For tasks, there is no start date, only created, updated and due dates.
If I were wanting to track start dates, I would run the Domostats report "Tasks" through a Magic ETL dataflow that appends each update. I would then use the MIN updated date when the status is In Progress to create a new field called "Start Date". It won't be perfect, as it is likely changes will be made between runs of the Domostats and updates will be missed, but it would get you close.
Alternatively, you could use the Tags field to enter the start date or add the start date in the Description and then using string parsing, pull the date out of the description.
Re: Recreating DOMO Marketing Ops Dashboard Sample
Wow, what a great find. This is incredibly misleading advertising from Domo. Everything about this would be very difficult to achieve without basically coding it yourself in Javascript and using a D3 or Echarts brick to put it in your dashboard (and if you're able to do that, what is the value-add of Domo?). I'm commenting in case I'm wildly wrong and someone knows a way to do this in Domo.
Re: Bar Chart 2025-2028
You need to reshape your data so the years are in a column. That would be easy in a MagicETL:
If you don't want to reshape your data, the only card I can think that would make sense "out of the box" is the pivot table card:
