mhouston Contributor

@gbrown how are you filtering? are you filtering on each beast mode where equal to null? (I.e. 3 filters in the filter section?) Because that would filter out any rows where they are null even if the others all null and you'd only get rows where all three are not null.

@damen are you trying to do this in a beast mode?

@Pau you can't use a federated dataset in Magic ETL (see the KB https://domo-support.domo.com/s/article/360049429094?language=en_US). However I did see another thread where @MarkSnodgrass suggested using the dataset copy connector as a workaround:…

@Domomon the syntax is NOT LIKE when you want to be sure it's not anywhere in the string. So: CASE WHEN `campaign` LIKE '%online%' THEN 'Online' WHEN `campaign` LIKE '%residential%' AND `ga_campaign` NOT LIKE '%semi%' THEN 'Residential' ELSE 'Other' END

@sharan_patil you can download a dataset to excel using the 'Export Dataset' option

@Jones01 yes. Locking the dashboard means that your colleagues can't change the dashboard (i.e. cannot remove, reposition cards within it), but if the cards themselves are unlocked, they can still be edited. You can lock all cards on a page using the bulk edit features in the admin panel.

The documentation says that the ds.get() will allow you to download data from domo - you just pass in the dataset id as the argument. (found here: https://github.com/domoinc/domo-python-sdk)

@jrtomici I don't think you can customize the export from Domo, but you could explore the powerpoint plugin which will allow you to customize a powerpoint template and then pull in the data from Domo.

@Rak is it an option to change this globally across your domo instance? In the Admin > Company settings, there is a week display option that you can toggle between Week Number and Week dates: This would be the easiest way to achieve it (without having to convert your dates using a beast mode).

@Cwal it looks like the problem is in the SQL syntax. I think I understand you are trying to exclude both values 'No Code0Bay 0' and 'No Code0NoBay'? So your SQL should be AND, not OR. Also a side question - why are you using the like operator without any wild cards? I think you could just use an equal. I'd rewrite your…

@cpbwg i think you can force it to numeric by multiplying by 1 as a workaround. I tested this in my own instance and the date_diff() function gave me a measure type field without doing this workaround. Have you confirmed you don't have any unexpected values in your dataset? Are your date fields actually date types?

@AttuAk i think you can do this but you will need a couple of the governance datasets. For page name, owner, created date - you can get this from the DomoStats Pages Report. For number of cards - you can either use the pages report in the third party Domo governance connector or you could use the Domostats or you can use…

@apritchett if you could describe/post a screenshot of your card configuration, and the discrepancy between your card row count total and the data warehouse row count total, the community may be able to help find the issue. Without more information it's hard to help find the root cause. Otherwise you may need to submit a…

@apritchett so within that there should be a number of options for the report: are you using the Datasets report? also - do you have access to all the datasets in your instance? I'm not sure, but I wonder if that may impact the number you see in the data warehouse vs what you see in your card

@apritchett which domo governance dataset are you using? I have used the domo governance third party connector with the datasets report and was able to create a card that showed the correct total. Depending on which report you are using, you may have multiple rows per dataset, which would inflate your row count if you are…

@Brightsider you can but you would have to restructure your dataset. You'd need a single date column to filter off of, so you'd want to pivot your data to create a single date column, and then have a new label column that holds the value of "Created" or "Scheduled"

@newbee do you have dataset access? You can get this from the Domo Governance connector using the "Beast Modes"report - then you could create a view on top to filter by the dataset you are concerned with.

@EllaCui in beast mode manager does it show you that it's on a dataset or card anywhere? You may need to put in a ticket with domo support.

building on @ST_-Superman-_ 's comment, there is a check box in the Save As dialog for "DUplicate All Cards" - if you leave this checked, then it will create new copies exactly as he outlined in his comment. If you uncheck this, then you will get a new dashboard, but with all of the original cards on it. So if you make…

@Fadem we use CMIC and I have pulled data in from it. Are you on their cloud environment or locally hosted? If you're locally hosted you can use workbench to pull the data through.

@AaronCrouch I don't believe this is possible in domo at this time, but you could submit it as an idea in the ideas exchange. when you say only one option is selected - do you mean a specific value? one idea to explore could be creating a beast mode on your dataset that hyperlinks to the card you want to show only for that…

@mroker if you authenticated in workbench after the dataset was already created under the other user, I think they will still be the owner on the dataset, and will need to either share it with you or change you to the owner.

@har_d_har1 my first instinct here is that PDP is your best solution. It doesn't have to be hard-coded values - you can assign based on user attributes, or create custom rules. Is there something in your dataset that identifies which ticket belongs to which user? You could use that in your PDP. For example, if you have the…

@charles yes but you have to be an admin. You would save as on the dashboard and then you would need to go into admin -> pages -> edit -> move and then you could make it a subpage

@Goodeman you can do this using rank and window and a formula tile in Magic ETL. You will want to add a rank and window tile in Magic ETL using the lead function so you can get the nextrow's value for event time (based on my understanding that the event time is the first time your agent hits that status). You would…

@Jbrorby yes this has been a hot topic in the domo community and a number of people have been reporting challenges with it. You can upvote @Ashleigh's post (https://dojo.domo.com/main/discussion/55833/silent-updates#latest) where she mentions it to let Domo know that we'd love to see them provide more information around…

@PRC your data is going to need to be restructured to get to the visual you are trying to achieve. You will need a single column (i.e. category) that holds the value of 'Completed', 'Engaged',or 'Transferred' and then use that column in your pivot table row. Data structure: Card: KB Article:…

I'd love to see this added into the domostats or domo governance datasets

@louiswatson are your stages mutually exclusive? if so, I think your next step will be a group by tile for each stage (group by stage and then count panels?) and then an append which will stack your 5 categories together. So i'd think your end dataset goal is: which you'd then build your pie chart off... is this what…

@utkarsh if you group input 1 by department and sum column 1, i would expect that grouping your output by department and summing column 1 would have the same number of rows and the same values from the grouping. Unless your department column in your output is coming from input 2 - then you would have nulls in that column.…