-
Re: How do I calculate the average of the past 3 sales of an item?
@meekey the OVER clause tells you what to partition by - in your case I'd assume you'd want to do it on your asset and then order by date descending so you could find the last 3 sales for each asset.…2 -
Re: Can I Create Variables in Beast Mode?
@Musetti I think this is currently in beta - they presented on the functionality at the user group community event. You can see the recording in this post: https://dojo.domo.com/main/discussion/55230…3 -
Re: Beast Mode to remove text after space
@ozarkram you can do this using the instr() and left() functions. You use instr() to find the first space, and then use left to take everything to the left of that index. The formula looks like this:…4 -
Re: Domo chart type
@Raj did you look under tables in the chart type drop down?1 -
Re: Workbench Data Sync Folders won't stay deleted
@Banff_BIAnalyst you will probably need to put in a ticket with Domo Support. I had this same issue a while ago, and if I remember correctly, they had to modify something in the registry. They also t…2