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

damen
damen 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?


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

Answers

  • McSQL
    McSQL 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"
  • damen
    damen 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.


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