Best Of
Re: Join Issue
@Fadem if your join keys are two text columns, it is likely a data issue. Extra spaces and capitalization are two common reasons why rows don't match when you think they should. I would use the String Operations tile and trim spaces on both ends of your text. I would also convert the fields to upper case. Then try joining on the commonly formatted columns.
Re: Group By Issue
The flow looks like this:
Inverse Amounts configuration:
Join configuration:
Restate Include / Exclude configuration:
rco
Re: Arrow Trend an Color Condition Format
You may want to look into Flex Tables as an option, but usually what I end up doing in these situations is use an HTML Table so that I can customize the Arrows, Colors, Rules, etc.
Below is just a basic example, but you can see how the beast mode can get very complex with even simple examples:
/*
Growth Indicator
*/
CONCAT(
'<div style="" title="% Change from Previous Row">'
, CASE
WHEN
(
/*
VIN Count Growth
(current value - prior value) / prior value
*/
(
/* Sum VIN Count */
SUM(`VIN count`)
-
/* Lag VIN Count */
lag(
/* Sum VIN Count */
SUM(`VIN count`)
) over (order by `Date`)
)
/
/* Lag VIN Count */
lag(
/* Sum VIN Count */
SUM(`VIN count`)
) over (order by `Date`)
) > 0
THEN CONCAT(
'<span style="color:MediumSeaGreen;">'
,'<img height="10px" src="https://upload.wikimedia.org/wikipedia/commons/7/73/Basic_triangle.svg"> '
, /*
String VIN Count Growth
*/
CONCAT(
ROUND(
(
/*
VIN Count Growth
(current value - prior value) / prior value
*/
(
/* Sum VIN Count */
SUM(`VIN count`)
-
/* Lag VIN Count */
lag(
/* Sum VIN Count */
SUM(`VIN count`)
) over (order by `Date`)
)
/
/* Lag VIN Count */
lag(
/* Sum VIN Count */
SUM(`VIN count`)
) over (order by `Date`)
) * 100
, 2)
, '%')
,'</span>'
)
WHEN
(
/*
VIN Count Growth
(current value - prior value) / prior value
*/
(
/* Sum VIN Count */
SUM(`VIN count`)
-
/* Lag VIN Count */
lag(
/* Sum VIN Count */
SUM(`VIN count`)
) over (order by `Date`)
)
/
/* Lag VIN Count */
lag(
/* Sum VIN Count */
SUM(`VIN count`)
) over (order by `Date`)
) < 0
THEN CONCAT(
'<span style="color:red;" title="">'
, '<img height="10px" src="https://upload.wikimedia.org/wikipedia/commons/e/ed/Decrease2.svg">'
, /*
String VIN Count Growth
*/
CONCAT(
ROUND(
(
/*
VIN Count Growth
(current value - prior value) / prior value
*/
(
/* Sum VIN Count */
SUM(`VIN count`)
-
/* Lag VIN Count */
lag(
/* Sum VIN Count */
SUM(`VIN count`)
) over (order by `Date`)
)
/
/* Lag VIN Count */
lag(
/* Sum VIN Count */
SUM(`VIN count`)
) over (order by `Date`)
) * 100
, 2)
, '%')
, '</span>'
)
ELSE '<span style="color:Gray;">-</span>'
END
, '</div>'
)
Re: Arrow Trend an Color Condition Format
This thread may be relevant to you as far as the colored directional arrow.
I made this video a while back about the color options in Domo. It may be helpful to you.
Re: New Guy Here - What's the Point of Apps??
I think it also has a lot to do with interactivity. Apps have more capability with workflows, forms, etc.
I agree with @Data_Devon. If dashboards work for you, use them. There's no need to work through apps if you are monitoring/analyzing metrics without more process needs.
11/18 PRODUCT RELEASE SNEAK: Workflows Data Query and AI Assist
During our feature release in September, we released the DataSet Query Task feature to Workflows. And many of you are still discovering the powerful capabilities of this feature, which allows you to query a dataset and pass the results to subsequent steps in your Workflows.
Now with our text to SQL AI Assistant, you can effortlessly pass results on to the next steps in your workflow, all without needing extensive SQL knowledge. It is as easy as writing simple text, then you can sit back and let AI handle the complexities of the SQL coding. Whether you're a beginner looking to explore your data or a seasoned data analyst needing rapid, complex queries, this tool opens up a world of possibilities to drive efficiency and success across the business.
Product sneak peaks are an exclusive perk for our Community members only 👏
Please note these features are subject to change and could lead to a delay in its deployment for an unknown amount of time.
11/18 PRODUCT RELEASE SNEAK: Pro-code Editor
Our Pro-code editor will now be available to everyone! Build beautiful, innovative, and powerful apps with our cutting-edge web IDE that enables you to create pro-code apps directly within Domo – no CLI needed.
For the developer, write code quickly through bypassing having to download and install packages or configure settings. Developers can build apps directly in the web browser all within the Domo web application.
For the semi-developer, our Pro Code Editor breaks the ceiling of development on Domo Bricks. The new editor helps semi-developers to grow their small pro-code component into much more power complex components or apps.
Elevate your development process and fully realize the creative possibilities with the Pro-code Editor – where innovation meets functionality!
Product sneak peaks are an exclusive perk for our Community members only 👏
Please note these features are subject to change and could lead to a delay in its deployment for an unknown amount of time.
11/18 PRODUCT RELEASE SNEAK: New Table Element in App Studio (Beta)
We’d like to introduce a very exciting update to our table functionality! Our tables will now offer an intuitive, Excel-like interface. These improvements offer a familiar and user-friendly experience that makes it easier to create and edit tables within App Studio. Our update includes all these new capabilities:
- Formatting and Grouping
- Aggregating and Sorting
- Versatile Column Management
- New Calculation Options
You will be able to explore data directly within the App Studio editor, further bridging the gap between Domo and the familiar spreadsheets you love.
Product sneak peaks are an exclusive perk for our Community members only 👏
Please note these features are subject to change and could lead to a delay in its deployment for an unknown amount of time.
11/18 PRODUCT RELEASE SNEAK: Domo Mobile App Customization
We are reimagining our Domo mobile experience for ultimate efficiency and personalization! You will now be able to fully customize your mobile navigation to fit your specific needs. This can be configured for the needs of different departments, groups, or the individual user.
Seamlessly configure the navigation with specific cards, dashboards, or apps – ensuring key content is just a tap away. Elevate productivity and accessibility with personalized mobile pathways curated to be as unique as your role.
Product sneak peaks are an exclusive perk for our Community members only 👏
Please note these features are subject to change and could lead to a delay in its deployment for an unknown amount of time.
11/18 PRODUCT RELEASE SNEAK: Data Freshness Advanced Scheduling
During Domopalooza we released the ability to customize and configure data freshness checks for our Cloud Amplifier Integrations. This gave you the freedom to configure how frequently you would like Domo to check for updated data coming from Cloud Amplifier.
We’ve improved this capability to now include more advanced scheduling options. You’ll have more control over when Domo will check for data updates in your data sources, allowing you to check for updates only when it is necessary. This is similar to how our connector scheduling works. If you only want to check for data updates at the beginning of the week or once a month, now it’s possible with our advanced scheduling options. This will reduce the expense of constantly looking for updates in the data cloud.
Product sneak peaks are an exclusive perk for our Community members only 👏
Please note these features are subject to change and could lead to a delay in its deployment for an unknown amount of time.
