Best Of
Re: HTML image
You'll need to host your image elsewhere, outside of Domo. There are several free image hosting sites out there you can check and perhaps use depending on how sensitive your data is. If your company has a website and FTP access, you might want to talk with the department that manages it to see if they can create a directory inside your company website structure to host the images publicly and retrieve them from there.
Re: Defining Custom Color Palettes
please do something about palette and colour management in the dashboard
Gionniz
Re: Can I get the MIN date over a partition with a formula tile?
Have you looked into using a Rank & Window til in your Magic ETL to get the minimum date across your column partition?
Re: Trying to calculate Rolling Averages/Sums over the previous year
You'd have to do this in the dataflow -basically join the 12 prior monts to each month (Aka, April's date would have the prior 12 months appended to it and all have a "Report Date" of April, so in analyzer when you select April you'd have the 12 months there). If you don't want the ability to drill, you could aggregate this before appending it.
Re: I am using this beast mode but it wont let me save the card
You need to aggregate the aggregate when using a window function in a beast mode because of how Domo processes the beast mode.
You could do something like:
COUNT(MAX(`ID`)) OVER (PARTITION BY `Clinic`, `Product`)
