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

albertodac
albertodac Member
in Magic ETL

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,

 

Best Answers

Answers

  • cmarkum
    cmarkum Contributor

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

  • kshah008
    kshah008 Contributor

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

  • albertodac
    albertodac Member

    @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
    Unknown
    Answer ✓

    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?

  • kshah008
    kshah008 Contributor

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

  • sarahbaker
    sarahbaker Member

    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
    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
    seeitall00 Member

    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
    kshah008 Contributor

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

  • seeitall00
    seeitall00 Member

    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]
    [Deleted User] Member

    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
    Godiepi Coach
    Answer ✓

    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

    Domo Arigato!

    **Say 'Thanks' by clicking the thumbs up in the post that helped you.
    **Please mark the post that solves your problem as 'Accepted Solution'
  • btm
    btm Domo Employee
    Answer ✓

    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? 

  • mdelorey
    mdelorey Domo Employee
    Answer ✓

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

    Retired Domo Alum
  • [Deleted User]
    [Deleted User] Member

    @mdelorey and @btm

     

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

     

    Regards,

     

  • albertodac
    albertodac Member

    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]
    [Deleted User] Member

    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
    seeitall00 Member

    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
    MackDaddy Member

    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.

Categories