-
Re: how to capture the current quarter using beastmode
You could do this: case when QUARTER('Date')=QUARTER(Curdate()) and YEAR('Date')=YEAR(Curdate()) then 'True' else 'False' end4 -
Re: How do I get my bar chart to plot along a minute-by-minute x axis
@JasonAltenburg You would need to make sure that the field you're using for your x-axis is a timestamp that contains minutes. Also make sure that your field is has both date and time:1 -
Re: Pull a list of all datasets in Domo?
@DataLawton For finding datasets that are no longer used, you can also click on Data in the toolbar at the top and then go to the Datasets section. From there you can use filters to find datasets tha…3 -
Re: Arbitrary Periods as Pivot Table Columns
@WillClark My company has a card that does something similar with YTD, MTD, last week, etc. You'll need to write a beast mode for each time period you want to calculate, and use the current date to d…2 -
Re: Can this card be built without pre aggregating the data
I think you can do this within a card by creating a beast mode using the DAYNAME() function with your date column that you can use as a column or your x-axis. Then the average for each day of the wee…3