Best Of
New "Domo for Office Add-in"
Hi Domo Experts,
Did you guys try the new "Domo for Office Add-in" published by Domo on MS Office Appstore? I found it very interesting - it's almost like accessing Domo right from the Microsoft Excel. Domo has opened accessibility to almost every element of Domo (and feels like you never need to go to Domo — at least to run the ETL processes or dealing with data.
However, surprisingly, it misses the core feature like advanced filters (using the operators like =, <>, >, <, between etc.) and the ability to create, manage and edit queries to import data dynamically with multiple filters from Domo dataset to excel sheet which were very much available in the older .msi installer plug-in.
More importantly, the new add-in is also not able to detect the connected datasets for importing data which was created using the older plug-in — so if you have created a query to import data to your excel sheet, the new add-in wouldn't be able to detect and refresh the data.
______
Don't you think those features should be available on this new cool and power-packed add-in? Else it would mean you have to manage two different add-ins?
If you think so - please upvote this idea posted for these features on the new Domo Office Add-in.
Thanks!
Pritesh
Re: How can I flip the legend items and the category items in a grouped bar chart?
@bennett_for_you You will need to swap which fields you are using in the X-Axis and Series since the legend is based off of the "Series" field. Alternatively, you could create a separate card for each metric and arrange them in a dashboard with the metric name in the title instead of relying on a legend.
Re: Formating
Since you are concatenating inside your case statement, it becomes a string, so you can't sum it. You will not be able to have one value show up two different ways inside a sum. I would suggest just having your revenue case statement just return a number and the beast mode should work.
Re: etl issues
Are you using Magic ETL? If so, the full quotation marks " are your problem. Instead, just start typing the column name without any quotation marks and then select it from the auto-complete list. Domo uses single back ticks ` if you wanted to try and manually type it, but it is much easier to start typing the name and select it from the auto-complete list.
Re: MYSQL Time
You can try and implement indexes in your MySQL dataflow however I'd HIGHLY recommend rewriting your MySQL dataflow in Magic ETL as MySQL is sequential (it has to wait for each dataset load or step to complete before it can move to the next one) compared to Magic's sequential processing (can do many steps simultaneously).
I've seen improvements of over 90% when converting MySQL to Magic ETL.
Re: Default date in Domo is Sunday, I need it to be Monday
You can customize your starting day of the week you can look into setting up a customized fiscal calendar. This will allow you to define the start of the week.
Re: Variable connected to a Filter Card
Due to how variables work the variable won’t remember the value you selected for a prior value of the variable column. I’d recommend adding this as an idea in the idea exchange