Best Of
Re: Add a condition on line plot to toggle between AVG and SUM conditions
The issue is with the count portion, are you looking for distinct row counts you can CONCAT all of the fields together:
COUNT(CONCAT(Plant, Group, Code, Month, Name, Part Number1, Part Number2))
Re: Booking date and shipment date formula
I would use the QUARTER() function and the YEAR() function to ensure that you get the expected result. It would look something like this:
CASE WHEN QUARTER(dt) = QUARTER(CURRENT_DATE()) AND YEAR(dt) = YEAR(CURRENT_DATE()) THEN 'Same'
ELSE 'Different'
END
Re: Bar chart years not in sequence
Hi @Gunjan , drag the date field being used in the x-axis into the “sorting” section of card analyzer. Then choose “ascending”.
Re: Remove dates from a card with a beastmode?
You can create a beastmode to flag certain dates and then select to either include or exclude those dates by adding the beastmode to the filter section.
Re: I have a column of part numbers and I need to exclude any rows where a part number has a character
You can use the split columns tile in Magic ETL to split up your string by looking for the comma. You would do multiple splits in that tile so that you can get to the 3rd and 4th entries. You can then do a filter tile where you filter out entries that have the values you want to exclude. Here's a KB article on the split columns tile.
You can also use the SPLIT_PART function to do this in a formula tile.
Re: I lost connction to DOMO. get "Could not authenticate user"
This happens when your password has changed or expired. You will need to click on the key icon on the left of workbench and then click on re-authorize. It should open a browser and have you enter your credentials and a code. After you enter that, be sure and click on the save icon in workbench in the top right where you clicked re-authorize or else your credentials won't be updated. After this, close and re-open workbench and your jobs should re-appear.
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