Data_Devon Contributor

Resurrecting this…. @david_cunningham I still don't fully understand how to Cartesian Join on the date dimension table. I oversimplified our dataset, so the screenshots you provided couldn't translate directly to our data. I want to join these two datasets to see how many appointments we have scheduled compared to how many…

I've had a similar issue in the past wherein a number was imported into Domo and inadvertently rounded. The number was an ID number, so rounding it renders the ID useless. (I.e. ID Number 999 and Domo rounded it to 1000 😐) The work around I found was to uncheck the "Use Raw Numbers" at the File upload point. This imports…

Hi ColinHaze, sounds like you've got a sweet thing going! I've always just applied a second layer to the drill path so that the filtered card is filtered yet again. If you are drilling in place, and you want those filters to also apply globally to the entire dashboard, then it should do that automatically. Just go to your…

Hi Brewha51! Within your dataflow "Settings" tab, you can set the time that the Dataflow will update. You could just have it update every night so its always fresh. Then, you could set an alert that triggers when the dataflow updates, and that alert could send the update to everyone. Am I on the right track here?

That makes sense @david_cunningham. Thank you for your thorough explanation. I see the quote of what must of been a previous question and response, but I don't see a link to the original post that your answer responded to. Perhaps that isn't important but wanted to be sure I wasn't missing something. Thank you David!!

Thanks David_Cunningham for a quick response! So, to clarify, I'll need to remap all of the actual columns so that they match exactly how Budget columns are reported. This is what I was afraid of 😂 "Please expand upon your aggregating up to a daily budget/actual" comment. Our actuals are on a daily basis and our budget is…

What about using the "Textbox" chart type, and then using [date] as the Text. This would then just be a simple caption that's populated by the date field within the dataset. That seems too easy so I must be missing something, ArborRose.

Awesome!! THat worked! Thank you Sean_Tully. Disappointed that Domo doesn't offer that solution natively, but I knew there would be a workaround.