-
Summary number color rule?
I understand you can be powerful with the summary number in a card, referencing HTML or calculated fields/etc. Is there a way to set a color rule to it? So if i want to make the summary number RED if below 15, or GREEN if above 50, then i could make the card-size tiny and fit more cards on a page and the end user could…
-
Workbench Schedule Error
I just tried to create a schedule group within Workbench 4, and i got th ebelow error. My question is, the path at the end says C:\JENKINS\.. that isnt on my computer anywhere. [ERROR] [19292:30] 2018-02-22 15:16:20,549 - Could not create scheduled task 'Sched_Group1' with path…
-
Workbench CHAR a timestamp
When i use.. TO_CHAR((now() at time zone 'America/Chicago'),'YYYY-MM-DD HH12:MI') Workbench uploads it as a date (Even though i have CHAR it). How can i force Workbench to upload as a char? I have also tried TO_CHAR((now() at time zone 'America/Chicago'),'YYYY-MM-DD HH12:MI')::VARCHAR and there was no difference. I have…
-
Can i change a column Name on workbench upload?
Example: I currently have a column named "REFF" and the dataset is used by 2 cards, when i try to update the column name to "REF" in workbench, it errors with "no matching element found". Once you make the initial dataset, are you set-in-stone with the column names and number of columns? I have it set to "replace dataset",…
-
Gauge card bufferzone between pass/fail
For a filled gauge card, let's say i want to put a goal of 50 on a gauge. Is there a way to have a small buffer zone of color that isnt pass/fail? For example, "goal = 50, but 48 to 50 is yellow not red" Similar to a radial gauge where you set limits to numbers high/low but it is a percentage based. I am looking for a…
-
Is there a way to stack smaller cards on the page?
I have created multiple cards just have a single gauge on them. As a "quick reference" to the end user, i want to stack these small cards on the page so that they are vertical and utilize the space more. Right now the white space under each card doesnt allow me to drag another card over to it... see photo for reference. I…
-
Sum ( Extract ( ) ) using RedShift
Using RedShift,,, i know that EXTRACT ( minute from date1) will give me the minute from date1 (18:03.94 returns 3) Ok,,, so now in my RedShift i said SELECT SUM( (EXTRACT(hour from date1-date2)*60) + extract(minute from date1-date2) ) So in my POSTGRES db, that returns everything great in total minutes.. Here's what i am…
-
Adding unique key's to dataset?
As with a physical database structure, adding indexes and primary keys help increase the efficiency of SQL execution. Is there a way in DOMO to enforce a primary key or unique constraint? I ask because i have a simple SQL in my dataflow that combines 4 existing datasets, and it is taking quite a long time for the Dataflow…
-
Remove Date Range from card
I am in card analyzer, and i have a quick filter setup for date for the data. How do i get rid of the date picker at the top of the card next to the summary? I want it gone and then the user will use the quick filter to get the data they want. I have everything working, except that filter doesnt move. There is a check box…