Best Of
Add Emphasis Controls to Line Graphs
Emphasis Controls in a line graph would allow card creators to choose which line (from a Series of lines) should be emphasized. I think this is most valuable if the emphasis is "locked" (can't be changed by users). Alternatively, it could act as a "default" emphasis (allowing users to change emphasis by hovering over other lines or the legend).
Today, this emphasis can be added by user actions, but it isn't preserved by default or shown to other users. If a line graph has a Series of lines, users can hover over one line or an entry in the Legend. Doing so emphasizes that line. Other lines turn a light grey color, and their value labels are hidden. The emphasized line has value labels added.
This emphasized view is a classic strategy for data visualization. In the textbook "Stortytelling with Data" with Cole Nussbaumer Knaflic, Chapter 4 is dedicated to this kind of strategy. Academic research into the psychology of vision has proven that certain pre-attentive attributes (like color, hue, and size) in data visualizations will capture a user's attentive immediately and with great effect. This medium article also discusses some examples, including a line graph with emphasis: https://medium.com/microsoft-power-bi/data-storytelling-101-the-magic-of-pre-attentive-attributes-522da9785f36
This is especially powerful when we want to visualize "noisy" data. Imagine a line graph with 100 lines. It's visually confusing, overwhelming, with no clear focus. Viewers likely can't read data labels. A lot of data is visually "lost" due to overlaps. Emphasizing just one of these lines allows us to tell a clear story: this might represent an average, a new methodology, or an outlier. And the rest of the data is preserved for context, making it clear how the data we're emphasizing relates to the rest of the data we have.
Currently, Analyzer can get close to this functionality if we add color rules turning all lines grey and then a rule coloring our preferred line. What this can't achieve is allowing data labels on just the emphasized line, though. A control in analyzer to emphasize one line in a line graph would support this classic data viz strategy, empowering better storytelling.
Looking for Guidance on Google Analytics and LinkedIn Analytics Reporting in Domo
@MarkSnodgrass and I have been working on a Member Engagement Dashboard and have had success connecting Salesforce Marketing Cloud. However, we've run into some challenges with Google Analytics and LinkedIn Analytics. We've attempted to build the connections ourselves, but the reports and available data don't seem to align with the metrics we're hoping to track. We thought we'd reach out to the Domo community to see if others have encountered similar challenges or have recommendations on the best approach.
Our goal is to create a consolidated view of member engagement across:
- Website activity (Google Analytics)
- Email engagement (Salesforce Marketing Cloud)
- Social media engagement (LinkedIn)
Some of the metrics we're hoping to track include:
- Website sessions and page views
- Traffic to key member resources and program pages
- Email opens, clicks, and engagement trends
- LinkedIn impressions, engagement, and follower growth
- Overall trends that help us understand how members are interacting with our content across channels
We're specifically looking for recommendations on:
- The best connectors or datasets to use
- Whether we're accessing the correct reports within Google Analytics and LinkedIn
- Any ETL transformations that may be necessary
- Best practices for structuring a dashboard that combines engagement data across these channels
For context, this dashboard is intended to help us better understand how members engage with our digital content and communications over time.
Any guidance would be greatly appreciated. Thank you!
Significant improvements to AI Chat
For participants in the AI Library beta, we are excited to announce some significant improvements to AI Chat.
Users now have the ability to ask complex, multi-part questions about their data, enabling more nuanced and detailed inquiries.
Additionally, the system can now handle questions that span across multiple DataSets. While cross-dataset joins and unions are not supported, the system can query multiple datasets independently and synthesize the results to provide comprehensive answers.
AI Chat can perform more in-depth analysis with longer conversations, giving users the ability to engage in extended discussions about their data without losing context.
AI Chat now includes support for unstructured data in the form of Documents, broadening the types of information that can be analyzed and queried.
Finally, AI Chat fully supports visualizations of your data. You can now ask AI Chat to ‘Show’ you a card or ‘Create’ a card on your current dashboard or App.
Custom CSS for App Studio Apps (+ maybe code injections)
Would love if App Studio allowed for custom CSS and potentially JS code injections. This would bridge the gap between the no-code App Studio and the all-code bricks. I am imagining something similar to Squarespace's setup (but for reports instead of a website) where everything is no-code unless you specifically go to the custom CSS and code injection settings. Non-coders would not even notice the option is there, but it would be amazing for users with more specific styling and functionality needs who don't want the work or maintenance of the pro-code editor.
I would love this feature since my team builds cards in the Card Analyzer because it is quick, easy, and accessible to all coding levels. Building in the pro-code editor is somewhat off-limits since it requires coding knowledge to maintain and edit, but at the same time we are limited by very simple App Studio theme settings. With this feature, the coders on the team could customize styling while still allowing everyone to work on the content of the app. I would imagine JS code injections would not affect card functionality (otherwise the pro-code editor would be more useful), just the app elements. Personally, I would prioritize custom CSS over code injections, but both would be great!
katrina
Re: Need to display total count to be displayed on Grouped bar chart.
One trick you can do is turn on tooltips. Put something in there you can count like names or an ID. Then go to dataset labels in text put in %_TOOTIP1
Made you a video on it:
If you or anyone else wants to see more of my Domo tips, you can signup for my newslettere here:
AND / OR subscribe to my YouTube channel:
Re: Taking an average of the dataset an comparing
@damen Made you a little video I hope this is what you need:
The issue is you might want to use a variable instead of a dropdown filter because if you use a filter you are taking data out of the chart which is ruining the average.
https://www.dashboarddudes.com/newsletter-sign-up
Need to display total count to be displayed on Grouped bar chart.
How to display a total rows count for each individual. Our major need to show the total inside the same chart.No option in chart properties to select show total rows count under data label settings.Is it possible to display a total for each series in a domo grouped bar chart.
Pari
More Versatile Tabs Positioning in App Studio
I really like the tab Elements, I think it's a very efficient use of space on a dashboard. However, I would like to be able to position cards NEXT to them. Currently, I can only position cards above or below them.
- Here is what I’m able to do currently:
- What I would LOVE to be able to do, is to clean this view up by positioning the tabs beside a taller card, especially in the “Auto Width” view where I have plenty of left and right real estate to play with.
- In this example below, I’ve put a large spacer element where I would like to position the tabs. I think this would work great and would give users a lot of variety in design options.
Has anyone used the Indeed Connector?
Hi, my company is exploring utilizing the Indeed Connector in Domo. We are hopeful that this connector may improve some internal processes but have had hardships with Indeed in the past.
For anyone who has experience with this connector:
(1) Did the data provided eliminate or at least significantly reduce the need to manually pull/review performance metrics from the Indeed platform?
(2) Have you encountered any issues from the Indeed side that interrupted the connection? Indeed seems to constantly be changing their rules and accessibility, so I am curious if the API Publisher Key or the data being provided by it has ever been changed, especially to be more restrictive or disruptive to down funnel configurations (e.g. data labels/format, etc. being altered).
Pass Variables into a MagicETL from Workflows.
With the new workflow features on the horizon, I think it would be immeasurably valuable to pass output variables from workflows into Magic ETLs since workflows can execute ETLs already. For example:
An 'audit' workflow is triggered that evaluates a dataset for various criteria. As part of the evaluation it sets output variables. At the end of the workflow, it triggers a MagicETL via API but can pass in those variables to said MagicETL as part of it's execution.
Inside the MagicETL, assuming you pre-defined some optional "input parameters", those then become the values from your workflow execution. This would allow MagicETLs to be much more dynamic as those variables can be used in various MagicETL tiles to control things like filtering, formulas, or change the way my output dataset outputs a Replace/Append/Partition dynamically.
The scenerio I think best fits this idea is if I had some workflow that tries to identify missing data in a dataset by looking for missing dates in their entirety along with statistical analysis on historical record counts on that same day of the week for those missing dates. Once those dates are identified, I can pass those dates from my workflow into the MagicETL. Those dates can then be used in my ETL to only reprocess data for those missing dates as part of using them in my Filter tile and possibly change my output dataset configuration away from Parition replace to Append so those missing records are just appened to the dataset.
Another scenerio would be if I triggered a workflow the moment a new user logged in. Maybe I want to trigger a MagicETL related to a business process to get them inserted into various system level datasets we designed for auditing/monitoring and apps we've built. The workflow could trigger various ETL's, passing in that user as a variable to act as filter so the ETLs are only doing work on that one person. This would be much more efficient and ensure faster processsing speeds.
DomoDork