Is there a feature in Domo similar to Tableau's level of detail expressions (LOD)

Hi,

I am trying to do some cohort analysis calculations and I wonder if there is something similar to Tableau's level of detail expressions? It is better to explain what I mean by looking at this link with some LOD examples:

http://www.tableau.com/about/blog/LOD-expressions

Thanks,

Quick Links

Accepted answers

unknown

Looking at the cohort analysis example you linked to, it seems to be a pretty straightforward chart. Is the struggle that the dimensions you need aren't currently in the data?

If so, you can use beastmode to create year columns based on the date field eg YEAR(`acquisitiondate`) and use this as a way to create your dimensions. Create a stacked bar with the date selector at All Time by Year. Use revenue as your series and then your beastmode category (acqusition date) as the segmentation.

Is this what you're looking for?

Godiepi

This is actually very very simple to pull up using a stacked bar card in Domo, without the need of an app already created or building an app from scratch.

This is an example that might give you an idea of how it's done.

Hope it helps you

Screen Shot 03-30-17 at 12.42 PM.PNG

btm

Hey @DaniBoy,

To piggy back on @Godiepi and @Kung-fu_Panda's great responses I thought it would help to give an example DataSet and a couple quick screenshots of how the visuals were recreated to look like the example provided in https://www.tableau.com/about/blog/LOD-expressions.

@seeitall00 - Does this help and what you were looking for?

CohortAnalysis.xlsx

Screen Shot 2017-03-30 at 2.02.12 PM.png

Screen Shot 2017-03-30 at 2.01.51 PM.png

Screen Shot 2017-03-30 at 1.59.26 PM.png

mdelorey

@seeitall00: I agree with the other answers here. Hopefully you find @btm's example helpful. But since @DaniBoy mentioned me, I also wanted to provide this direct answer to your additional request for clarification "Is there a feature in Domo similar to Tableau's level of detail expressions (LOD)"

Yes, we accomplish data transformation and calculated values through a combination of native ETL and calculated field capabilities (Beastmode, in Domo speak). But in general, we give our users interfaces that are easier to interact with and don't require them to even do things like write LOD-type calculations. There is a lot of good info in our Help Center about both ETL and Beastmode features.

Here are some links to get you started:

Beastmode functions https://knowledge.domo.com/Visualize/Adding_Cards_to_Domo/KPI_Cards/Transforming_Data_Using_Beast_Mode/02Beast_Mode_Functions_Reference_Guide
Beastmode examples https://knowledge.domo.com/Visualize/Adding_Cards_to_Domo/KPI_Cards/Transforming_Data_Using_Beast_Mode/04Sample_Beast_Mode_Calculations
Creating a Beastmode https://university.domo.com/videos/watch/NpYjMxdzqoBStETSICh_uB8-k1IwZeqY
Magic ETL and other ETL options https://university.domo.com/videos/label/prepare
ETL docs https://knowledge.domo.com/Prepare

All comments

cmarkum

Domo has a Custom App that you can puchase that pretty much matches that. You could also build it using the App builder.

kshah008

@albertodac, did cmarkum's reply help you out?

albertodac

@kshah008 @cmarkum
Thanks for your input.
I am looking for something that could be quickly used as part of beast mode calculations and not having to go through a custom app.

unknown

Looking at the cohort analysis example you linked to, it seems to be a pretty straightforward chart. Is the struggle that the dimensions you need aren't currently in the data?

Is this what you're looking for?

kshah008

@albertodac, tagging you to check out Kung-fu_Panda's reply out.

sarahbaker

What is the name of the custom app? I have searched the app store and could not find anything about it. Is it in the app store?

unknown

Beastmode is a basic function in the cards themselves that allow you write basic MYSQL like functions to manipulate labels or values.

Not sure if there are custom apps that provide similiar functionality.

seeitall00

Can someone please name the App or answer the original question?

" Is there a feature in Domo similar to Tableau's level of detail expressions (LOD)"

kshah008

@seeitall00, please feel free to open up a new thread for better exposure to your question ?

seeitall00

Instead of telling me to post the same question in a new thread you could have answered my questition... or do you not know Domo?

What's the point of having two threads with the same question in it? Is there anyone here who works for Domo and knows the software? A "I don't think so..." from a domo user is not the kind of answer I am looking for. A yes/no ... here you can find it/here is how you do it... would be actually helpful.

[Deleted User]

Thanks for your reply!

@btm @mdelorey Can you guys confirm if we have this as a custom app?

@seeitall00 have you looked through our ideas exchange to see if this has been suggested yet?

We will get clarity on this for your shortly.

Regards,

Godiepi

This is actually very very simple to pull up using a stacked bar card in Domo, without the need of an app already created or building an app from scratch.

This is an example that might give you an idea of how it's done.

Hope it helps you

Screen Shot 03-30-17 at 12.42 PM.PNG

btm

Hey @DaniBoy,

CohortAnalysis.xlsx

Screen Shot 2017-03-30 at 2.02.12 PM.png

Screen Shot 2017-03-30 at 2.01.51 PM.png

Screen Shot 2017-03-30 at 1.59.26 PM.png

mdelorey

Here are some links to get you started:

Beastmode functions https://knowledge.domo.com/Visualize/Adding_Cards_to_Domo/KPI_Cards/Transforming_Data_Using_Beast_Mode/02Beast_Mode_Functions_Reference_Guide
Beastmode examples https://knowledge.domo.com/Visualize/Adding_Cards_to_Domo/KPI_Cards/Transforming_Data_Using_Beast_Mode/04Sample_Beast_Mode_Calculations
Creating a Beastmode https://university.domo.com/videos/watch/NpYjMxdzqoBStETSICh_uB8-k1IwZeqY
Magic ETL and other ETL options https://university.domo.com/videos/label/prepare
ETL docs https://knowledge.domo.com/Prepare

[Deleted User]

@mdelorey and @btm

THANK you for chiming in, looks like we have some great content and solutions on this topic!

Regards,

albertodac

Hi guys,

Thanks a lot for your answers.

@DaniBoy It would be great if these smart solutions are covered in easy to find articles in Domo's university. Even better if the cards with the solutions could be easily downloaded. Is there a "Beast Mode examples" app where people could easily learn beast modes with real life examples?

[Deleted User]

Albert,

We review the top solutions and search terms in Dojo with the Domo U team every month to make sure we have related articles.

I will make sure this gets added to the top of the list. If we add new content in our knowledge base and in Domo U on this topic I will update this thread.

Thanks!
Dani

CC @JeriLarsen

seeitall00

I'm sorry but i don't see a solution or great content here... and the fact that it took almost a year to get here should not be cause for celebration.

If a stacked bar chart is all you have to offer in this matter the question needs to be answered with a clear no. Even though the stacked bar chart (or the %_PERCENT_OF_CATEGORY data label settings) uses a form of LOD calculation, I have no way of using these results to do further calculations with and the ways addressed here are limited in the most extreme ways.

"But in general, we give our users interfaces that are easier to interact with and don't require them to even do things like write LOD-type calculations."

I'm sorry but how does Domo remove the need to use LOD-type calculations? I have the option of adding the logic and calculation to the ETL SQL or to learn to live without it. In these "solutions" I see little more than far stretched workarounds and I feel somewhat irritated that this is being sold as some sort of fantastic feature. I almost feel as though I walked into an applestore...

Please don't misunderstand me here, I don't what to pick a fight or criticize your product in an undeserving manner but this is already weak solely for the way you handled my request to answer a months old question. When you work with a software that has issues or isn't self explanatory in every way, it is super frustrating when you don't get the answers you need to proceed. And I have seen many posts here that have succumb similarly. I also find it strange, that the person answering a question gets to decide if that actually answers the question. That should be in the hands of the person asking...

MackDaddy

There are times when writing LOD type expressions in SQL code or Magic ETLs simply take too long to process. I've got a dataset of 70M rows and when I want to do a quick analysis at a specific levle of granularity, it doesn't make sense to go build an entirely new dataset that is shaped differently.

I'd love if DOMO could see the value and use of why LOD type expressions are so beneficial because it allows you to keep one dataset that solves multiple uses vs. multiple datasets/dataflows for various purposes.

other categories

Product Ideas
Have a Domo product enhancement idea? Submit or upvote on ideas in the Ideas Exchange.
Ideas Exchange
Suggest & vote on new features you would like to see implemented in the Domo Product.
Data Connections
Ask questions about Connectors, Workbench, Cloud Amplifier and get best practices from Domo peers
Connectors
Connectors, Custom Connectors, Writeback
Workbench
Ask questions about Workbench, a secure, client-side solution for uploading your on-premise data to Domo.
Cloud Integrations
Ask questions about Cloud Integrations and Federated Data connection to your data warehouse or lake.
Data & ETL
Ask questions about Magic ETL, SQL DataFlows, DataFusion, Dataset Views and get best practices from Domo peers
Magic ETL
Ask Magic ETL questions and get answers from Domo peers
SQL DataFlows
Ask SQL DataFlow questions and get answers from Domo peers
Datasets
Ask DataFusion and Dataset Views questions and get answers from Domo peers
Visualize & Apps
Ask questions about Beast Mode, Cards, Charting, Dashboards, Stories, Variables and get best practices from Domo peers
Dashboards
Ask Cards, Dashboards, and Stories questions and get answers from Domo peers
App Studio
Ask questions about building apps in App Studio.
Pro-code Components
Ask questions about pro-code components and Domo Bricks and get answers from Domo peers.
Charting & Analyzer
Ask questions about charting and Analyzer and get answers from Domo peers.
Calculations & Variables (Beast Mode)
Ask questions about using calculated fields and Variables (Beast Modes) in Analyzer.
AI & Data science
Ask questions about DomoAI and get answers from Domo peers.
Domo AI & AI Chat
Ask questions about AI Chat and AI assistants.
Managing AI
Ask questions about managing AI with AI Playground, AI projects, AI models, and more.
Jupyter Workspaces
Ask questions about Jupyter Workspaces, Notebooks, and file share.
Automate
Ask questions about App Framework, Workflows, Domo Bricks, Domo Developer, API and get best practices from Domo peers
Workflows
Ask questions about Task Center, building automations with Domo Workflows, and executing JavaScript or Python code with Code Engine.
Alerts
Ask questions about managing alerts in Domo and get answers from Domo peers.
Distribute
Ask questions about Domo Everywhere, Scheduled Reports, Mobile and get best practices from Domo peers
Domo Everywhere
Ask questions about embedded analytics with Domo Everywhere.
Reporting
Ask questions about Scheduled Reports, Report Builder, and Slideshow Publications.
Manage
Ask questions about Governance Administration, Approvals, Teams, Alerts, and Buzz and get best practices from Domo peers
Governance & Security
Ask questions about People, Groups, Roles, Sandbox, Activity log, Buzz, Teams, Approvals and PDP and get best practices from Domo peers
Navigation & Productivity
Ask questions about navigation, Projects & Tasks, Goals, and Buzz chat.
APIs
Ask APIs and Developer.domo.com questions and get answers from Domo peers
Add-ins & Plugins
Ask questions about plugins, Microsoft add-ins, and other third-party software integrations.
Domo Community Gallery
Watch how our Customers are using Domo to solve their complex problems.
Product Releases
Domo support and product teams are here to live-answer questions about the most recent product releases. Please post questions in this Forum board for all users to benefit (rather than submitting a support ticket).
Domo University
Questions or discussions related to Domo University, trainings and certifications
Community Forums
Getting Started
Welcome to Domo's Community Forums! You'll find everything you need to get started in this category.
Community Announcements
Get the latest from Domo's Community Team.
Social Groups
Archive
Old or outdated content that could still be found helpful.