Best Of
"Jump" button that scrolls to section of dashboard
Hello, I have a dashboard that has a hefty amount of cards that are organized into sections marked by headers/borders. Is there a feature in Domo that allows me to add a button that users can click to automatically scroll down to a section? And in the same vein, perhaps a "back to top of page" button? This would make navigation simpler for salespeople.
Thank you!
jrtomici
Re: SQL in ETL
I use the INSTR() function for this type of work.
INSTR(STR,SUBSTR)Returns the position of the first occurrence of substring substr in string str.
Re: How to count strings in a column containing a comma delimited list of strings in each row
The way I did it in SQL, it doesn't matter how many commas there are. In ETL, I'd have to create something recusive to make sure you can get any number of elements typed into a string. If you know you won't exceed the number of delimited items you show, something like this will work.
Using that flow, I then went out and had some website give me random city names which I typed into my webform.
Re: How to exclude a card from getting filtered? (slicer filter)
Hi @Zel, you can change the way the ‘Month Slider’ card interacts with the rest of the cards on your dashboard. When you edit dashboard and then click ‘Edit Content’ of that slider card, you'll get the following:
Throught ‘Apply to selected Cards’, you can keep Card #2 as normal interaction and exclude Card #3 from slider filters.
Let me know if there are any questions, or you are looking for something else.
amehdad
Re: Vue + Vite setup for DOMO?
Sure thing @Rich , @btp_tlangston Yes you can use front-end frameworks like React/Vue/Angular.
I understand that the Domo “starter kit” for Vue instructs you to use the Vue cli even though that is in maintenance mode. That's fine, you do not need to use the Vue CLI as I believe create-vue supports most of what Vue CLI provides. These starter kits were just originally intended to give you a quick start and skip some of the prerequesite setup steps.
You can start your vue project like you would any other website , you just need to be aware of the setup steps that are required here:
https://developer.domo.com/docs/dev-studio-quick-start/set-up
More specifically this would be installing the Domo CLI (which is what you use to publish/deploy your app to Domo) and also the domo.js (which is used to query Domo datasets and get environment data like the currently logged in user, among other things) library which you can read about here:
https://developer.domo.com/docs/dev-studio-guides/domo-js
Lastly I'd like to reiterate that the process to building and deploying a custom app is almost identical to building and deploying a website. Think of Domo.js like you would any other 3rd party library, and think of the Domo CLI like you would any other CLI tool. If you're familiar with that process then you shouldn't have too much difficulty in setting this up.
Re: Heat Map Hours Off
@chrissy Your hour beastmode column is in text so it is sorting it in aplphabetical order, so 1 pm comes right after 1 am alphabetically speaking. Try creating another beastmode that gives hours 1-11 a value of 1 and hours 12-23 a value of 2. Then add this beastmode as a sort before your hour sort.
Alternatively, you could get the time value instead, using this and see if that sorts the issue out:
TIME_FORMAT(TIME('virtual check-in date'),'%h %p')
Re: Heat Map Hours Off
@chrissy I agree with @RobSomers that it is not sorting correctly because it is viewing the field as text. You can also sort by HOUR(`virtual_checkin_date`) since that is already a numeric field.
Re: Creating new field by summing two values from existing field
It doesn't like the tics around Unassisted Entry. Use the same type of single quotes you have around LiveStream and PhoneAutomatedPin on the Unassisted Entry and it should work.