Best Of
Re: Domo Re-cert
Thanks Ashleigh, you are right.
I cant seem to see my current certification on my account.
Let me reach out to support and see if they can update my account to reflect my Major Domo certification, that might help. I will keep you updated. Thank you.
AbiO
Re: Custom Themes for DOMO Apps Beta
I believe this was requested on the last beta call and they are putting it on their list of things to consider for future updates.
Re: Effective Dating
@ArborRose I am not sure I fully understand the ask but if you are just trying to look at the current report then you could do a group by to get the max date and then join that back to your data and filter when the date = max date.
Ashleigh
Re: Effective Dating
The way I've done this is utilizing the rank and window tile to rank in descending order grouped by the unique field, in your case it looks like you'd group by `patient`. Then add a filter tile to only keep the records with a rank of 1. This will keep only the most recent date, and corresponding row, for each patient.
Re: Create X-Axis to Only Display Day over Several Months
CASE WHEN DATEDIFF(CURDATE(), `Date Field`) <= `Days Variable` THEN 'Include' ELSE 'Exclude' END
Re: using Domo API and partition
If you're pulling in Daily data and don't need to keep more than 3 years of data partitioning would be easiest for you to utilize.
using IF then WHEN
Hi
I want to add another variable to the above equation but can't get it to work. In my Excel days, I would use an IF statement. Here is my equation:
when 'primary class' = 'supermarkets and grocery stores' THEN sum(case when `Split answer` = 'Female' then `Value` else 0 end) / sum(`Value`)
Thanks
Ben
Re: View as user or view as role
As an admin and the person responsible for an overall positive Domo user experience, this is an imperative management feature.
I intentionally laid out the sub-page order for a deployment to a group of 10 users.
The page order had intentional logic to support adoption. My directions referenced the page order.
Weeks later I learned that each user got the pages in a completely randomized order.
Many of my administration challenges come down to "I cannot see what you are seeing"
jroach