Best Of

Re: August Community Highlights 🏫🎨✈️: Tell us where you've traveled to this summer!

Romania and Albania!

ColemenWilson

2

Re: Additional Functionality when charting by Week

@RobertPenridge Great ideas! Wanted to add some info here for you or others that might find this thread:

For option 1, if your business has a rule for which day of the week your weeks start, or has specific week boundaries for a fiscal calendar, check out this article, Domo can get your fiscal calendar installed into your instance for use in charting: Using a Fiscal Calendar (domo.com)

I think for some charts part of Option 2 is already available by using the Date output format in the Chart properties, hopefully this is helpful!

I do think it would be nice to have those other options there too, to change whether starts/ends are displayed, and show some sort of week begin/end messaging alongside the axis.

JasonAltenburg

2

Re: Views keeps converting time to UTC

@HowDoIDomo I would check the timezone of the dataset used for the view. If it is not the same timezone as your instance, it may be trying to convert it.

MichelleH

1

Re: Fetch data from a dataset using the Domo.js library and display it in DDX Brick

If you set all three of the datasets (dataset0, dataset1, dataset2) to your dataset, you can remove the Example Sales Data. But be careful, removing it without changing all can wipe out the brick.

ArborRose

1

Re: Cache configuration

@LearningNinja - Editing the TTL on an existing federated connection should clear the cache.

JoshMillheim

1

Re: Substitute for if / then statements

COALESCE(`(A2) Posted Bill Rate`, `(A1) Original Bill Rate`) + COALESCE(`(B2) Posted Bill Adj`, `(B1) Original Bill Adj`)

COALESCE takes the first non-null value in the parameters passed. So this is saying Use A2 Posted Bill Rate if it's not null, otherwise use (A1) Original Bill Rate. Add that to B2 otherwise add it to B1.

GrantSmith

1

Re: How to Duplicate Rows

This will be easier in the near future with the Join tile ON clause and the Series (row generator) tile. For now, the solution to this problem is described here. There's more than one answer; the more complicated one involves generating a series table within the flow, the simpler ones assume you've built a series table as a DataSet in Domo with Webforms or a file upload.