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,
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?
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
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?
@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:
Domo has a Custom App that you can puchase that pretty much matches that. You could also build it using the App builder.
@albertodac, did cmarkum's reply help you out?
@kshah008 @cmarkumThanks 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.
@albertodac, tagging you to check out Kung-fu_Panda's reply out.
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?
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.
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)"
@seeitall00, please feel free to open up a new thread for better exposure to your question ?
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.
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,
@mdelorey and @btm
THANK you for chiming in, looks like we have some great content and solutions on this topic!
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?
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
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.
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.