Best Of
Re: Dashboard question
@Crystal_Z perhaps you do not need to switch datasets. You can have one card with summary views and another with detailed views. As long as the column you click on exists in both datasets then when you filter the summary one it should filter the detailed one.
Ashleigh
Magic ETL - copy/paste JSON definition to clipboard
During the Technical User Group kickoff call, @john_stevens dropped some knowledge on us that just blew my mind. As seen in the gif below, you can copy Magic ETL tiles to the clipboard, and then paste into a text editor and it will give you the JSON definition of those tiles. That definition file can then be edited and repasted into the Magic canvas to produce new tiles. This can be incredibly helpful if you're wanting to edit Magic in bulk and don't want to use the Java CLI. I'm really excited to try this out more!
-Elliott 😁
![[Deleted User]](https://us.v-cdn.net/6032830/uploads/defaultavatar/nZ5X977MOM3Z6.jpg)
Re: Dashboard question
Hi @Crystal_Z
Currently it's not possible to dynamically change the dataset on a daashboard dynamically. You can use a drill path to display a different card with a different dataset but that would only apply to that single card and not your entire page.
Re: Improving Dataset performance by removing unused columns
This is a long article, but definitely worth a read to understand the Domo architecture.
I would start with the view itself and trim things there. Beyond the number of columns, I would look at the types of joins and aggregations you are doing to ensure they are as efficient as possible. To further refine, you should only need to go back "one level" to the datasets that are used by the view and limit the columns in there.
Hope this helps.
Re: Copying values from a table card as text
That is not possible right now. You could submit it as an enhancement in the Ideas Exchange section of the Dojo. This allows it to be voted up by other people in the community and then the development team can consider including it in their product roadmap.
Re: Copying values from a table card as text
@user12621 I think if you use an HTML table it will let you copy through right click. Those tables do not look as good as a mega table though. I struggle with the same issue!
Ashleigh
Re: How do I open the datasource editor
the directions you reference are not for Domo, but for Google. In Domo, if you want to edit an ETL for a dataset, the easiest way is to go to a dataset or dataflow in the datacenter and find your dataset and then go to the far right and click on the wrench and choose Edit. If edit is not an option, you likely don't have permissions to edit ETLs. Here is a link to more information.
https://domohelp.domo.com/hc/en-us/categories/360003124753-Transforming-Data-in-Domo
Hope this helps.
Re: How to Do a Silent Install of DOMO Workbench
It doesn't appear their are any switches available for the workbench exe, which limits your options. You could try creating an msi package via some online tools and then you will be able to deploy it via Group Policy. You could also reach out to your CSM or Domo Support to see if they have an msi package available.
Re: Facebook Ads Advanced connector - values do not match FB Interface
Hi @user17472, have you checked this issue through with Domo support [https://domo-support.domo.com]?
amehdad