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,

Find more posts tagged with

Accepted answers

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?

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

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

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

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

@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

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

All comments

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

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

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

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

@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.

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

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?

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

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

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

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?

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

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.

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

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)"

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

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

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

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.

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

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,

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

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

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

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

@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

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 and @btm

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

Regards,

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

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?

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

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

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

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...

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

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.

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

Quick Links