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

damen
damen 🟠
edited November 1 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

  • 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 🟠
    edited November 1

    @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!