How do you create a chart that shows month over month difference

jlabbe
jlabbe
in Card Building

Sorry - I'd created this in the regular Dojo area; didn't realize I needed to post it here.  So feel free to remove from regular post area.

 

How do you create a chart that shows month over month difference? Like Excel pivot when you sum and can do "difference from".  Is this something that can easily be done or do you need to create something via magic ETL?

Best Answer

  • Apollo
    Apollo
    Answer ✓

    Hi jlabbe,

    The best way to achieve this is to create a running total column in a dataflow. (If needed I can PM you on how to create this)
    Once we get the running total column in your dataflow. We can calculate the difference from month to month in a beast mode. 

    Thank you,


    I work for Domo

Answers

  • Apollo
    Apollo

    Hi,

    We currently have period over period charts that let you compare month over month.
    Here is a usefull article on how these charts work. 
    http://knowledge.domo.com?cid=buildingpop 
    Period over period
    Please let me know if you have any questions.




    I work for Domo
  • jlabbe
    jlabbe

    Hi,

    I don't think I explained what I need very well.  Here is an example of the summed data:

     

    Jan - 10 widgets 

    Feb - 20 widgets (cummulative - includes Jan/Feb)

    Mar - 35 widgets (cummulative - includes Jan/Feb/Mar)

    Apr - 50 widgets (cummulative - includes Jan/Feb/Mar/Apr)

    May - 100 widgets (cummulative - includes Jan/Feb/Mar/Apr/May)

     

    I want my graph to only show the increase (so difference from previous month.  I believe the period over period will only compare months.

     

    Jan - 10 widgets

    Feb - 10 widgets

    Mar - 15 widgets

    Apr - 15 widgets

    May - 50 widgets

     

    If that's still in period over period I'll take another look.

     

    Thanks, Joanne

  • pbansal
    pbansal

    @Apollo: I can't access the link for Period over Period chart. 

    Prachi Bansal
  • Apollo
    Apollo

    Can you Try this link?
    http://knowledge.domo.com?cid=buildingpop 

    Thanks,

    I work for Domo
  • pbansal
    pbansal

    @Apollo: Even this doesn't work. I am getting this error:

    "You do not have permissions to view this page."

    Prachi Bansal
This discussion has been closed.

Categories