Best Of
Re: Is it possible to calculate ROAS and WoW change in the same beast mode formula?
Hi @ccc123 ,
Here's my video on how to do rates:
and here's my video on time comparisons:
Just for you or anyone who wants to see for future reference
Re: Apostrophe messing up formula
THANK YOU BOTH! I got it to work with the Trim and Like statements.
Marcel Lüthi late introduction 😅
I guess I'm not exactly new, as I've been lurking the forums for a few months now, but never got to properly introduce myself to the community. I'm from El Salvador (Central America), my native language is Spanish, so sometimes my mind struggles when trying to catch up while writing in English and testing things out. Currently working as a Data Analyst in a tech startup. I own a cat (or rather she owns me) and my main hobby is playing Magic the Gathering, specifically sealed and commander. I love taking ideas from the forums and try solving interesting questions that pop up every now and then, that I could see I might come across further down the road.
Re: Introduction Suggestions
Hello All! I am a new user for Domo and I am very excited to be part of this group.
I am an operations analyst currently supporting an awesome organization with multiple lines of business. As I go through the educational material, I can see how Domo will bring value to the organization. So, I am happy and grateful for this forum.
Re: comapare current-3 days in period over period chart
@chetan_cricut here is what @GrantSmith is suggesting.
From the list of charts, choose Gauges and select Multi-value Columns chart.
In the date range select Previous and Last 4 Days
Create a beast mode called "Last 3 Days" that looks like this:
CASE whendate>= DATE_SUB(CURRENT_DATE(), INTERVAL 3 DAY) THENconfirmed_totalEND
You will need to swap out the date field and the confirmed_total field with the date field in your dataset and the value field that you want to total
Create another beast mode called "Last 4 Days" that looks like this:
CASE whendate>= DATE_SUB(CURRENT_DATE(), INTERVAL 4 DAY) THENconfirmed_totalEND
You will need to swap out the date field and the confirmed_total field with the date field in your dataset and the value field that you want to total
Drag the Last 3 Days field in the Gauge Value field and choose an aggregation type of Sum.
Drag the Last 4 Days field in the Comparison Value field and choose an aggregation type of Sum.
You can then use the Chart Properties to change the look and what values you want displayed.
Hope this helps
