Filled Gauge Chart

user082291
user082291 Member
edited March 2021 in Charting

I have a gauge filled chart built that has been working each month and is now showing an error. The field I am using for the time period is Date Closed and now it makes me pick a Max Or Min. That was never showing before. Is this a change? I am trying to show the Ave Days to Close incidents base on Previous Month compared to one year ago. So a period over period graph using the filled gauge.

My formula for the Gauge Values is the following:

ROUND(AVG(DATEDIFF(`Investigation End Date`,`Investigation Start Date`)),0)

image.png

Nothing seems to work in the Date Filter either. Not sure what it wants.

image.png

Sample of when it did work

image.png

Thank you,

Answers

  • GrantSmith
    GrantSmith Coach

    Hi @user082291

    has something changed with your date fields? Are there now nulls in your date field?


    Can you try an alternate method for calculating date difference by using UNIX_TIMESTAMP?

    ’’’

    ROUND(AVG((UNIX_TIMESTAMP(`Investigation End Date`-UNIX_TIMESTAMP(`Investigation Start Date`))/60/60/24),0)

    ’’’

    simply it’s calculating the number of seconds between the two dates and converting them to data using division


    I’m on mobile so there may be some syntactical errors.

    **Was this post helpful? Click Agree or Like below**
    **Did this solve your problem? Accept it as a solution!**
  • jaeW_at_Onyx
    jaeW_at_Onyx Coach

    @user082291 , convert your card into a table card and confirm that it still retrieves values.


    Also, are you confident that your EndDate and StartDate never contain nulls?

    If it does contain nulls, can you confirm that the math still works as desired.


    ROUND(AVG(DATEDIFF(`Investigation End Date`,`Investigation Start Date`)),0)

    Also, Domo recently (i'd say in the last 5 weeks) changed the functionality of Domo such that you can't wrap aggregate functions (AVG) inside another function (ROUND). This may or may not be part of your problem, but do try removing the ROUND() function and see if it works, first as a table card, then as a gauge.

    Jae Wilson
    Check out my 🎥 Domo Training YouTube Channel 👨‍💻

    **Say "Thanks" by clicking the ❤️ in the post that helped you.
    **Please mark the post that solves your problem by clicking on "Accept as Solution"

Categories