Comments
-
Yes, but does it differ at all from a normal card view? Is there a way to know that it was viewed in excel?
-
Did some testing here and the closest you can get in the activity log is to look in the Browser_Details field. I believe there will be a unique (or unique-ish) value there for this type of activity. You could look for that exact match or may notice a pattern if you have a few users doing this it will likely be a similar…
-
Yep! You can use the "Cards and Datasets" report from the Domo Governance Datasets connector. This will give you every card and its associated dataset. You can then use the activity log report from Domostats connector to group the total views by card ID and then join with the Cards and Datasets dataset on Card ID. You…
-
I used a DDX brick + a webform. This is the DDX brick I am using: https://www.domo.com/appstore/app/ddx-html-table-app/overview 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…
-
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. https://www.domo.com/appstore/connector/domostats/overview
-
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 https://community-forums.domo.com/main/categories/ideas
-
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: https://www.w3schools.com/sql/func_mysql_date_format.asp 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: https://domo-support.domo.com/s/article/360042933754?language=en_US
-
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: https://help.mysidewalk.com/en/articles/3126175-what-is-normalization-and-when-should-i-normalize 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…
-
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.
