MarkSnodgrass Coach

I would try breaking the two conditions out into separate conditions and see what they return. This will help you identify which part is the issue.

I'm referring to up here by clicking on the pencil. Then click on Format Choose Display as Number Hovering over the legend should result in this

Is your y-axis set to a number? Or something else? Make sure it is set to a number by editing the formatting of the y-axis value.

In the chart properties, your data label settings are likely using these two in the text section: %_CATEGORY_NAME %_PERCENT_OF_CATEGORY You can use the same ones in the Hover Text Settings, so that they display the same.

You could pull this off using variables as well as a window function to create a row count. To create a row count, create a beast mode like this: SUM(SUM(1)) OVER(ORDER BY Start) Change Start to whatever field you need to order by in your dataset. Create a variable control. I would use a radio button control that says…

In the value fied, format it as number. Then in the general properties, set Divide Value By to None. That will show the actual number.

You would need to do this in Magic ETL. You can use the filter tile to filter where job_name equals QC_Job and then use the join tile to join back to your main dataset and do a left join on content_id with your main dataset being on the left side of the join. The left join will allow all of your main dataset rows to come…

If you are unable to change how the data is coming in as @ST_-Superman-_ suggests, you can use the LPAD() function to add the leading zero, when necessary. You can do this in Analyzer by creating a beast mode, or in Magic ETL using the formula tile. It would look like this: LPAD(zip,5,'0') This will add a zero to the front…

That is strange. There used to be a map of the world (as the video in the KB article demonstrates) that allowed you select what city you want to use and then would select the correct time zone. This definitely seems like a step backwords and it is missing more than Mountain Time Zone. I am not seeing Pacific Time Zone…

If you only wanted to show dates that are the first of the month you could create a beast mode like this: CASE WHEN DAYOFMONTH(datefield) = 1 THEN datefield END You could also create an include/exclude filter logic and then drag this beast mode into your filters and filter to include: CASE WHEN DAYOFMONTH(datefield) = 1…

The best way to fix this would be to build a Magic ETL dataflow with this dataset as the input dataset. You can then use the Alter Columns Tile to change the data types, or you can click on the Input Dataset and click on Data Handling and choose what type you want to change it to as well as clicking on the wheel cog to…

Yes, you can create a beast mode that simply has this: CURRENT_DATE() You can then use the textbox, dynamic textbox or even a table card to display the field.

In picture 1, I think you need to make it a nested case statement. The way case statements work, they exit once they find a condition that is true. A nested case statement would look like this: CASE WHEN condition1 THEN CASE WHEN condition2 THEN 'Include' ELSE 'Exclude' END ELSE 'Exclude' END

The likely reason that you are running into issues with the two tiles is that you are likely using the same column name in both tiles. This results in the 2nd tile overriding what was in the first tile. I would suggest that in the IC Exception formula tile, you label the field as IC Exceptions. In the END Exception formula…

@SaloniShah happy to help. If you can mark as accepted any of the above answers that helped you, that will help others in the community.

You can create multiple formulas with different field names in the formula tile. You are not limited to 1.

I think what you want is this: (Customer Type != 'END') OR (Customer Type = 'END' AND Bill-To Customer Name IN ('A','B','C') 

While you can write formulas in the filter tile, for this type of logic, I would suggest adding a formula tile before your filter tile where you determine which rows to include or exclude and then you can just filter to include in your filter tile. In your first scenario, your formula tile logic would look like this: case…

I asked the same question to my AE the other day. It seems odd that there is not a link to it from the Tool Downloads section in the Admin Center of the Domo instance where the old Excel and PowerPoint Plug-ins are currently located. Here is a link that will take you to the MS Appstore and filtered to the new Domo add-ins.…

If your data is in 2 rows then you can use the dynamic textbox and use the last and penultimate data to display it like this. If your data is all in 1 row then I would suggest using the Multi-Value card under Gauges and you can use the Gauge Value and Target Value. This gauge has quite a few properties and can be…

I believe these changes are already in the works to give users more granular control over the layout and spacing. It was discussed during the March Community Meetup. You can watch it here: https://www.youtube.com/live/PVQm5-_aJm0?feature=share

Instead of this: Case when discarded_at is NULL and archived_at is NULL then count(invoice_id) else NULL end try this instead: SUM(Case when discarded_at is NULL and archived_at is NULL then 1 else 0 end) Using 1's and 0's with SUM is another way to count items instead of using the COUNT function.

Domo, Please combine these upvotes with the upvotes from an earlier Idea Exchange with the same request. https://community-forums.domo.com/main/discussion/56974/set-the-default-value-of-date-type-variable-to-current-date-or-todays-date

Domo released a new Office add-in at DP23. I would try using it instead. https://www.domo.com/business-apps/add-ins

You might try seeing if any of the Domo Bricks can be extended to do what you want to do. There are several map brick apps in the app store.

Create a beast mode like this might work for you to exclude the prior year entries are excluded if they are from the 2 days that aren't yet in the current year data. CASE WHEN DAYOFYEAR(yourdatefield) > DAYOFYEAR(DATE_SUB(CURRENT_DATE(), INTERVAL 2 day)) THEN 'Exclude' ELSE 'Include' END You would drag this beast mode into…

It might actually be that your IN does not have a space before it so it is reading accountIN as one thing, when it isn't.

@GrantSmith is the Regex guru. He will be able to put something together for you.

Sent you direct message with a link. I am free for a few minutes.

There are not color ranges in this card, but you can assign positive and negative colors. For the formatting, try setting the format on the gauge value and the target value to number. There are also individual formatting options within the chart properties, which can be confusing. I feel your pain there.