コメント
-
I used a DDX brick + a webform. This is the DDX brick I am using: For your webform, you'll also want a column with values that can correspond to a PDP policy. My Webform: DDX Brick code: Javascript: var domo = window.domo; var datasets = window.datasets; var myDataTable = document.getElementById('myDataTable'); // Data…
-
Chart Properties > General > Transpose
-
Not really. You could get creative with images though. For example, I have a page in Domo where an image in the top left of the page changes depending on what product is selected. You could do the same and have a dynamic image that changes based on which user logs in.
-
Do you see it through the Domostats connector? I find that more helpful than the activity log in Admin because it is a dataset that can be joined with other data sources.
-
For cards you can look at the Card History: For dashboards (and cards and dataflows) you can use the activity log. You won't always know what changed, but you can see by who and when changes are made.
-
Strange, you should be able to remove them. I would reach out to Domo support!
-
Does your user have the Manage all Cards, Pages and Apps (App Studio) and Edit App (App Studio) grants?
-
A kebab icon will appear when you hover to the right of the filter view name, see below: Click it and then "Delete" will appear:
-
Agreed that this is unhelpful. I would recommend adding this idea to the
-
Create a beastmode and use it as a filter: CASE WHEN `Time` = MAX(`Time`) THEN 'In' ELSE 'Out' END Not sure what format your time field is in, but you'll need to make sure it is in a datetime format for this to work.
-
Okay, you can just add the filter as a quick filter but not filter any values. By default it will select all and then they can change the filter as they like. If new values are added, they will show by default.
-
You could do this in the ETL or a beastmode using the DATE_FORMAT() function: DATE_FORMAT(`yourDateField`,'%d/%m/%y')
-
Have you saved the beastmode to the dataset?
-
You could look at using Inline Editor for something like this:
-
If you are selecting all values, is there a reason you would even apply a filter? Because not applying a filter at all would select all values
-
Hmmm I just tested and I can see a vast range of dates. Do you have other filters applied that may be limiting the data?
-
Oh it should be under my answer. If not no worries, @Grant.Stowell will get it marked! Thanks @kcalhoun!
-
If that is the case, you could add a path to your ETL that filters to only rows with null values for Div and then append those to the rest of your data.
-
Would global date filters be acceptable? See below:
-
You could use a filter on your card like this: CASE WHEN DAYOFMONTH(CURRENT_DATE()) = 1 AND DateField < CURRENT_DATE() AND DateField >= CURRENT_DATE() - INTERVAL 1 MONTH THEN 'In' WHEN DAYOFMONTH(CURRENT_DATE()) != 1 AND DateField >= LAST_DAY(CURRENT_DATE()) + INTERVAL 1 DAY - INTERVAL 1 MONTH AND DateField <=…
-
Yes you can do it in a beastmode. LEFT(`FSJ No.`,4) Then bring that field into your table twice, once without modification and once as a count aggregation.
-
If I were asked to do this, I would append the data in Magic ETL and create 2 new fields: A date column that contains both sales and return dates A flag to indicate if that row is a sale or a return Then in a beastmode you could do your calculation: COUNT(CASE WHEN `NewFlagField` = 'Return' THEN `Reason` END) /…
-
In MagicETL you are only previewing 100 rows. I see in the second image that there are 1,737 unique values for the BMI Work Number in your final output data. It appears that the data is there and that there are also null values for that field.
-
You could normalize the data: Or just divide by a thousand, or ten thousand and then use a chart type that allows for multiple axis labels (left and right) and be sure to label the axis that has been adjusted to read "In thousands" for example.
-
I am pretty sure it is one of the "Domo Sneaks" things coming but not yet available. The product release yesterday was just for the AI Service Layer. You can use Domo GPT in models in Domo. Chat is coming in the future.
-
Just create a beastmode field that references the field you are using to filter. Example below: Then use this as your filter for the right side. You can also use filter exceptions.
-
I've checked the Alpha, Community and my personal instance and it isn't available in any of them. It may require a feature switch. I've reached out to my CSM to see if this is the case.
-
No, you would use two columns to identify the grouping as shown below:
-
You have the right idea. Group By tile grouping by Employee ID and Month and aggregating max date. Is that what you've done? Could you share a screenshot of your group by configuration?
-
Yes you can use inline editor for this: You could also utilize variables to do "what if" calculations: