Comments
-
Where are you looking to see 3rd lowest day? In the dataset provided by Domo in the quickstart, I see the "date" field, which I assume is the date the credit was consumed/charged/whatever, but not necessarily when the 3rd lowest day of storage was.
-
There are a few connectors you could look at: JSON No Code Connector: JSON Advanced Connector:
-
Similar to dashboards, you can only enable drill in place if a drill path has been created for the card. When importing a dashboard to an app, the drill path will come with it. If you did not have a drill path created before importing the dashboard, you will need to navigate to the card outside of the app and create a…
-
During the append, the matching fields being appended default to the most compatible data type between the appends sources. So if you change one source to Date, but the other is Date Time, it will change the data type to Date Time. You'll need to ensure that the data type for all inputs to your append are cast to Date. Add…
-
Edit App > Select the card > Actions > Drill In Place
-
Try: CONCAT(ROUND(Sum(CASE WHEN `To Step` = 'Forward to HM' THEN 1 ELSE 0 END)/(COUNT(DISTINCT `Requisition Number`)),2), ':', ROUND(Sum(CASE WHEN `To Step` = 'Hire' THEN 1 ELSE 0 END)/(COUNT(DISTINCT `Requisition Number`)),2))
-
You can wrap each of the two parts of your concat with ROUND(). CONCAT(ROUND(Sum(CASE WHEN To Step = 'Forward to HM'THEN 1 ELSE 0 END)/(COUNT(DISTINCT Requisition Number)),2) , ':', ROUND(Sum(CASE WHEN To Step = 'Hire'THEN 1 ELSE 0 END)/(COUNT(DISTINCT Requisition Number)),2) )
-
If ultimately what you need is when the status changed, you can use a lag function to check the previous status. If the previous status is different than the current status, then flag that row as when the change occured. If the previous status is null or the same, then flag it as no change. ETL Overview: Rank & Window: 2.…
-
It doesn't look like there are direct integrations between Domo and Zapier, but there are many other tools you could integrate with using the Domo Writeback Connectors. You can gain access to Domo Integration Studio if you are on Consumption. If you are on user license model, you can talk with your CSM about a specific…
-
Hey @pftomas! I was the one who led the "Cultivating a Community of Empowered Users" session. A hand was raised by someone in the audience who said that they link to their confluence documentation from Domo, but that it does not actually live as content in Domo. As mentioned by @Sean_Tully, at Henry Schein One we do all of…
-
I have noticed that dataset alerts off of Dataset Views are limited to aggregated alerts and not row level alerting. Is this also what you are seeing?
-
Thank you @GrantSmith !
-
I just submitted a very similar idea topic: Hopefully the squeaky wheel gets the grease here!
-
Hmm that doesn't seem to work if multiple filters on a page impact a card.
-
@DashboardDude's dude status was replaced with coach status.
-
I'd look at the unique values in that column and see if there are text values there. For example, 'N/A' can't be converted to a floating decimal because it is text. The "Failed to parse text" in the error leads me to believe there are text values for that field.
-
Social users are, like Ashleigh said, in a holding position. We want them to have a profile so we have a full hierarchy in Domo and so they can enroll in Domo university trainings. My preference would be to customize the button actions but if that is not realistic then removing it would be my next choice.
-
There are a few ways to change the column type. The easiest would be in Magic ETL. Open the dataset in Magic ETL Add an Alter Columns tile Choose the column in the alter columns tile and select "Date" for CAST DATA TYPE
-
Are you using the response text to identify a specific responder? What if instead you had the responder or response ID as the filter so you wouldn't have that character limit issue?
-
Nice work @ArborRose !!!
-
There is not. The easiest way to do this would be to combine the data using Magic ETL or a Dataset view.
-
No, the closest thing to that would be to apply a filter to the scheduled report that makes the cards blank. You'd still see card titles though. You could also make a duplicate of the dashboard and remove those cards from it.
-
You could just create a beastmode that is `your value` * 1000000000. Then in the chart properties, select General > Divide Values by > Billions. End result (this original number in my data is 95.72, once I take the steps above I get the below):
-
Can't wait to hit the slopes with ya'll!! 🏂️
-
Yeah! The best thing to do is split the email out so you only have characters left of the @ sign. Then remove all text and only keep numbers. Then count the characters left. Use the following: CHAR_LENGTH(REGEXP_REPLACE(SUBSTRING_INDEX(Email, '@', 1),'[^0-9]+','')) Then use a case statement to filter out anything you don't…
-
Have you looked at using TIMEDIFF()? Here is what I use to calculate duration between two datetime: CASE WHEN ((UNIX_TIMESTAMP(`datetime`) - UNIX_TIMESTAMP((`datetime2`)))/3600) < 24 THEN TIMEDIFF(`datetime`,`datetime2`) ELSE (UNIX_TIMESTAMP(`datetime` - UNIX_TIMESTAMP((`datetime2`)))/3600) END
-
Users can set their own language that can differ from the company language settings:
-
You don't have to do the recording, just the screenshots. Cheers!
-
The only way currently to get that custom formatting is in a separate card that you could place next to the card on the dashboard. I would recommend adding an idea to the ideas exchange for a dataset last updated date display smart text.
-
A workaround (if you have workflows) would be to create a workflow that updates the data every 15 minutes or hour. A word of caution, if you are on consumption model of Domo this would incur high usage costs.