Best Of
Re: Zoom Meetings Datasets - Meeting Subject
The connector does seem to be geared towards past meeting information. If you can find the right API call in Zoom's API documentation here: https://marketplace.zoom.us/docs/api-reference/zoom-api/
You could look at bringing it by building your own API connector, or try using the JSON No-Code Connector. You can also send the specific API to call to Domo Support and they will forward it to the connector team, who could look into adding it, but that may take some time.
Hope this helps.
Re: Period over Period (MOM/YOY) option in Multi-Value card for 2 months prior
@NathanDorsch glad I was able to help. If you can accept any answers that helped you, that will help others in the community.
Re: Period over Period (MOM/YOY) option in Multi-Value card for 2 months prior
@NathanDorsch Yep! That did it! Thanks!
Re: Is there a way to delete a column in a dataset?
@NathanDorsch I haven't seen a connector where I can choose which columns I want to import. However, I often build an ETL on top of my source dataset, so that I can select which columns I want and rename them as necessary using the select columns tile in Magic ETL. This also gives me the flexibility to swap out the source dataset, if necessary, and I don't have to do anything to any cards because they are tied to the output dataset of the ETL rather than the source dataset.
Hope this helps.
Re: Use power function in beast mode or in the formula while creating ETL
Yes, that will work in a card beast mode. Just keep a close eye on the parentheses. You had one too many in what you just sent.
Re: Calculated Field - Outstanding Invoice Count with date constraints
That formula won't validate as constructed. I would re-write it like this, assuming you have a due date field:
SUM(case when `type` IS NULL and DATEDIFF(`duedate`,CURRENT_DATE()) <=14 then 1 else 0 end)
This assumes type is actually null and not an empty string. I am using sum instead of count because we need to only count certain ones and we are using ones and zeros to do that. I'm assuming the due date is beyond the current date and so we are looking to see if it is within 14 days.
Hope this makes sense.
Re: Hi, I'm getting an error doing DateDiff bw two date fields where Nulls exist in one data
@AeyaiSaengkeo that's great to hear! If you can accept any answers that helped you, that will help others in the community.
Re: Can you combine 3 different columns in a pie chart?
If I am understanding you correctly, you could make a percentage beast mode for each type, like this:
Easy Client Pct: Easy Clients / Easy Clients + Medium Clients + Hard Clients
Medium Client Pct: Medium Clients / Easy Clients + Medium Clients + Hard Clients
Hard Client Pct: Hard Clients / Easy Clients + Medium Clients + Hard Clients
You might also consider using the Unpivot tile in Magic ETL, so that your data is restructured to something like this:
PM Client Type Count
Jim Easy 53
Jim Medium 23
Jim Hard 11
John Easy 12
....
Here's the KB article on the Unpivot tile if you haven't used it before.
https://domohelp.domo.com/hc/en-us/articles/360044951294-New-Magic-ETL-Tiles-Pivot#3.
Re: Increase width in ComboBox component
That appears to be a limitation of the combo box card type. I would actually submit this as a bug, because it should at least match the width of the component when the text is that long. You can send an e-mail to support@domo.com to let them know of the issue.
Re: Hi, I'm getting an error doing DateDiff bw two date fields where Nulls exist in one data
Thank you Mark. Using the PeriodDiff did it for me. Thank you so much.
