Skip to content

    • Charting

    Charting

    Can I use a year filter in a column while simultaneously not using it while building a table?

    Contributor
    edited November 2022 in Charting

    On the left is a breakdown of all 2022 loans by county - on the right is an all time breakdown by county.

    Is there any way to include these both in the same table? im having trouble trying to show both instances in the same visualization

    Any suggestions?

    image.png


    If this helps, feel free to agree, accept or awesome it!

    Answers

    • Domo Employee

      Assuming this data is in the same dataset, you can do the use beast mode to get the two numbers side by side. The beast mode would look something like

      sum(case when year(`date`)=year(NOW()) then `value` else 0 end)

      **Say β€œThanks" by clicking the thumbs up in the post that helped you.
      **Please mark the post that solves your problem by clicking on "Accept as Solution"
    • Contributor
      edited November 2022

      @McSQL Yeah i thought of doing the same thing -- for whatever reason when I add the '2022' formula into the values field, it wants to change the entire dataset with it.

      image.png image.png


      If this helps, feel free to agree, accept or awesome it!

    Welcome!

    It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.
    Sign In

    Welcome!

    It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.
    Sign In

    Quick Links

    Categories