1 trend using 2 columns of data

user0010327
user0010327 Member
in Archive

Is there a recommended chart type or beast mode calculation to show a trend with 2 series data points:

e.g. I want to show the trending count of active users; start date is one column, and end date is another. I do not want to show cummulative users (which does not account for cancels/end dates) or gross adds.  Is this possible? What is the recommended approach or beast mode workaround? Thanks.

Comments

  • codysirwin
    codysirwin Domo Employee

    To make sure I'm understanding this correctly, do you have a data grid that looks something like this?

     

    User IdStart DateEnd Date
    12017-01-012017-02-14

     

    In order to do what you are doing, we may need to move to Magic ETL or DataFlow.  Normally in this kind of scenario, we join that table to a calendar dimension table (We have some Domo Dimesions DataSets available.  If you'd like to use one, please reach out to your CSM or Support) and do some simple greater than or less than logic to identify number of active users.

     

     


    Cody Irwin
    Manager, Technical Solutions
    **Say “Thanks” by clicking the “heart” in the post that helped you.
    **Please mark the post that solves your problem by clicking on "Accept as Solution"
  • user0010327
    user0010327 Member

    Thanks, Cody. That is exactly it.

  • codysirwin
    codysirwin Domo Employee

    As an example, say we used a date dimension table that had a row for every day between January 1, 2017 and December 31, 2017 - Let's call it date_dimension.  

     

    We could join that to our main DataSet - let's call it original_data - like this (using MySQL syntax):

     

    SELECT

    a.`date`

    b.*

    FROM `date_dimension` a

    LEFT JOIN `original_data` b ON a.`date` >= b.`start_date` AND a.`date` <= b.`end_date`; 

     

    From there, we could build a card using the a.`date` column as our x axis and the b values for a count of users.


    Cody Irwin
    Manager, Technical Solutions
    **Say “Thanks” by clicking the “heart” in the post that helped you.
    **Please mark the post that solves your problem by clicking on "Accept as Solution"
  • user0010327
    user0010327 Member

    It has been 21 days, and neither domo support nor individual customer reps have not been able to assist or fulfill the request for calendar dimension tables.  

     

    Sounds like this is not a realistic solution if it cannot be fulfilled.  Any other ideas or suggestions from the community or domo superusers?

     

     

Categories