how can i create a calculated field based off buckets?

damen · 2022-10-31T20:47:02+00:00

There was an error rendering this rich post.

damen

Hi all,

Recently I created pricing buckets for the amount of loan a borrower took out. This works

Right now, we have two different visuals that show 2021 vs 2022

This is ok but we would rather be able to see both of these graphs in one with the different years in different colors. Is there any way to do this?

The only way I know how to set up a period over period visualization is with the year on the x axis - which in this case doesn't work.

Find more posts tagged with

Card Builder

Beast Mode

Accepted answers

GrantSmith

Wrap your beast mode in a case statement to check for this year and then another to check for last year

This Year Count:

CASE WHEN YEAR(`Fiscal Date`) = YEAR(CURDATE()) THEN
  COUNT(`Field`)
END

Last Year Count:

CASE WHEN YEAR(`Fiscal Date`) = YEAR(CURDATE())-1 THEN
  COUNT(`Field`)
END

You can then put both of these beast modes as your y value / series values and make sure you select a group type bar chart.

All comments

GrantSmith

Wrap your beast mode in a case statement to check for this year and then another to check for last year

This Year Count:

CASE WHEN YEAR(`Fiscal Date`) = YEAR(CURDATE()) THEN
  COUNT(`Field`)
END

Last Year Count:

CASE WHEN YEAR(`Fiscal Date`) = YEAR(CURDATE())-1 THEN
  COUNT(`Field`)
END

You can then put both of these beast modes as your y value / series values and make sure you select a group type bar chart.

damen

The 'graph by' setting is set to graph by year. Not sure why the output is like that.

DavidChurchman

I don't think you want 'graph by' since it's not really a time series. You're using the year as a categorical variable and applying it as the series value. I would get rid of the 'graph by', and then double check your sorts