Best Of
URL in a card
Hello, I want to create a link to go to the user's profile in Domo.
I have this BM
With a textbox type card, the hyperlink does not work for me because it puts all the text.
It only works for me with a table, but I have no way to hide the lines or the header.
Linking subdashboards
How can I link different subdashboards and make them run when embed? I've tried chaging the interaction linking different pages by using the “Link to any content” option but it doesn't work when embed
alliu
Re: How to Aggregate DateTime Differences
@JedP - this is great. Thanks for sharing.
@AnnaYardley - this seems like the kind of post that might make a better blog post then a Dojo topic as it really isn't a question, just a well thought out solution to a common problem.
Re: Divide numbers from same column based on criteria from another column
You can use a case statement for this
SUM(CASE WHEN `category` = 'DAU' THEN `users` END) / SUM(CASE WHEN `category` = 'MAU' THEN `users` END)
Then make sure to graph based on your date field. You can change the aggregation function if you need something different.
Re: Compare last 12 complete months to prior 12 months
Have you tried period over period chart type? Select your date range and how you want it graphed (by week, month, qtr, etc). And then select compare to 1 year ago.
Re: Add dynamic columns in variable dashboards
Great feedback Anna! This is a request we've heard from several customers and we do have a potential solution for this in mind, however, I don't have a specific timeline on when we'll be able to release this yet. Thanks for helping us improve Variables!
Re: Update to Grants!
Totally agree. Especially grant for datasets - currently only 2 options: share and edit. Need 3d: view only (ability to remove share and edit options).
stasia
Re: Compare last 12 complete months to prior 12 months
Yes, the problem I'm having is I don't want to show the current month. How do I show just the last 12 complete months? And then propertly compare them to the prior 12 months (without having an extra one comparing against today's month).
Re: Export to PDF error - images
@ArborRose Have you tested whether it will work when exporting to PowerPoint? If that works, you could always re-save the PPT as a PDF once it's downloaded.
