Best Of
Re: Concat summary numbers
I'd try putting a space between the two just incase, like ' '.
But your logic is sound, that should have worked.
Re: Hi Team, Need help in converting a string value to date.
What does your function look like? You should be able to do something like this:
STR_TO_DATE(`str_field`, '%b-%y')
Re: Case statement not working
Case statements are evaluated from the top down and will stop when they find a condition that's true.
Because you have
WHEN STR_CONTAINS(AdditionalRecruiter,',') THEN AllRecruiter
At the top of your case statement the other two below it won't ever get evaluated. Put the N/A and N/B conditions above this to have them evaluated first.
Re: Hi Team, Need help in converting a string value to date.
You can use the STR_TO_DATE function in a beast mode or a formula tile in a magic ETL to convert a string to a date based on the format string.
Documentation:
Re: Is there a way to get a list of all fields being referenced in cards by a dataset?
Yep! There is a Domo Governance Dataset called "Card Fields and Beastmodes" that has the data you are looking for.
Re: How to Execute a Workflow From Another Workflow?
You can take your result object of your first workflow (which would be your output dataset) and make it the input dataset of your second workflow. To use these objects as "parameters" against your main dataset in your second workflow, you can set a constant of 1 on both datasets and join on that value. This will make it so your input parameter is repeated on every row of your main dataset. You can then use a filter tile to filter against your parameter.
Hope that make sense.
Re: Date change in workbench
@mroker This sounds like a timezone mismatch between your Domo instance and the source data. You will likely have to add a Timezone conversion transformation to your workbench job to match the timezone of your Domo instance.
Re: WE NEED YOUR FEEDBACK: What topics would you like to see at Domopalooza 2024?
Also requesting in person.
I'd love to see a panel or Domo Innovators or something so people know who to ask in the community for what.
Re: Fixed Function - More complicated function
You've got a few too many closing parenthesis and aggregate functions.
Are you wanting the filter none to apply to the engagements AND the page views or just the page views?
Try something like this:
SUM(`Website Engagements`) / SUM(SUM(`Page Views`) FIXED (FILTER NONE))
This will get the fraction of engagements of the total page views.
