Average check amount

user07693
user07693 Member
in Charting

Hi all,

 

I have the following data:

 

Date               Check amount

10/11/2017        $50

10/11/2017        $60

10/17/2017          $55

 

I need to build a graph showing average daily check so on a X asis I will have two dates: 10/11/2017 and 10/17/2017 with the values (50+60)/2 and 55 respectively. Please help

Best Answer

  • RGranada
    RGranada Contributor
    Answer ✓

    Hi,

     

    Try this layout:

     

    2017-10-12_154422.png

     

    Where BT_Date is the following Beast Mode:

     

    CONCAT(MONTH(`Date`),'/',DAY(`Date`),'/',YEAR(`Date`))

     

    Hope this helps.

    Ricardo Granada 

    MajorDomo@Lusiaves

    **If the post solves your problem, mark it by clicking on "Accept as Solution"
    **You can say "Thank you" by clicking the thumbs up in the post that helped you.

Answers

  • RGranada
    RGranada Contributor
    Answer ✓

    Hi,

     

    Try this layout:

     

    2017-10-12_154422.png

     

    Where BT_Date is the following Beast Mode:

     

    CONCAT(MONTH(`Date`),'/',DAY(`Date`),'/',YEAR(`Date`))

     

    Hope this helps.

    Ricardo Granada 

    MajorDomo@Lusiaves

    **If the post solves your problem, mark it by clicking on "Accept as Solution"
    **You can say "Thank you" by clicking the thumbs up in the post that helped you.
  • ST_Superman
    ST_Superman Domo Employee

    @RGranada Just so I understand, what is gained by concating the date field like that?

  • RGranada
    RGranada Contributor

    Just did it to avoid having more than two dates in the x-axis....

    If we just try to convert the date to a string, due to a currently identified Bug DOMO would still assume the Beast Mode as a data and show all the dates between the populated records.

     

    Is there a better way to achieve it?

     

    Regards,

    Ricardo Granada 

    MajorDomo@Lusiaves

    **If the post solves your problem, mark it by clicking on "Accept as Solution"
    **You can say "Thank you" by clicking the thumbs up in the post that helped you.
  • ST_Superman
    ST_Superman Domo Employee

    No, that makes perfect sense.  If he wanted to graph the average check by week or month, or to be able to select the level of granularity, he would just keep the date field without the beastmode.  The downside there is that when you are looking at the day view, he would also see any empty days in the x axis.  

     

    Thanks for the explanation!

  • user07693
    user07693 Member

    thanks a lot, perfect!

This discussion has been closed.

Categories