Best Of
Re: Efficient Way to Rollover Filters with New Month
Even if that seems too manual to you, it's still an improvement over current state.
There isn't an indicator or identifier of the month being closed. We are just dependent on another team saying "we are done!" at which point we can trust the data and publish it.
Re: Beastmode to flag an item if the date is longer than a week from the current date.
You are on the right track. This should do the trick:
I'd recommend removing the hardcoded Year reference so that this can be used eternally ☀️
CASE
WHEN `Submission Time` < DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
THEN 'FLAG'
ELSE 'NONE'
END
Did that do the trick?
Re: Is there a creative way to adjust the decimal places on a progress bar?
Change the format of the value to percent and then you edit the # of decimal places.
Re: Export data from DOMO to Google Sheets on Schedule
Thank you Colemen! Will try to contact PIC to figure out. Meanwhile I found that we can create a card and then set a "scheduled report", at the same time send the raw dataset within the report by email, and this somehow works (though not the idealist way)
Su_Wd
Re: How do you join a federated dataset with a cloud amplifier dataset from Snowflake?
Thank you both for your answers. I ended up creating an ETL outside of Domo.
HLIN
Re: How can I utilize double case statements in a beastmode
Hello @Anna_Otake,
I believe this is not possible with Beast Mode. ETL should be used to calculate this and create the new columns.
Re: Why is Domo Support on my PDPs?
@andyhicken I often find content that has been shared with Domo Support if they have ever needed access to troubleshoot an issue in your instance for a support case. There shouldn't be any harm in it being shared with them but you can probably remove them if you don't have any open cases
Re: App Studio Controls/Filters
This request is tremendously important. Fire Department with incidents and truck checks (preventative maintenance). If I want to provide a dashboard that allows filtering by fire truck id, I can only do so for one dataset, making the product much less useful.
Yacker
Re: Workflows Form Error: Assignee does not have update content access to queue
Hi @DanHendriksen - I had to deprioritize it for a week - hopefully get a moment this week to build
NateBI
Re: How to import date/time values in workbench exactly as 8/26/2024 9:00:49 AM, without any transform?
When a date is imported into Domo it's assumed that it's UTC. If you want to treat it as a date then you'll need to import it as a date. If the date doesn't align with what you're expecting due to the time zones then you'll need to use a Timezone transform and import it with the timezone your source system is set with. This will allow it to be imported with the correct time in relation to UTC. Once you have the data and it's displayed on a card the Company Settings will take effect and translate your timestamp stored in UTC as whatever your timezone is set to.
