Is having two bar chart lines possible?

Q&A
, ,
1

View image below. It is showing by month, the count of cases, grouped by their credit quality, and a line showing the predicted default rate for that month.

image
image729×471 33.7 KB

The default rate line is being shown by month. So for example January is a 10% default rate, and February is 15%. However this has little impact on the OVERALL default rate due to the count being low.

Main Question: Is it possible to add another line which shows our portfolio predicted default rate - ‘all-time’ predicted default. This is so i have a line showing predicted default rate per month, and how this affects the overall predicted default rate.

I have tried with reference lines, but these are straight lines and does not show the impact month by month.

2

Hi @HarveyB-B

you only want to add a new line with same x-axis? Because you can use more lines within the chart.

grafik

BR

3

The problem is that it is the same calculated field. I think where it is filtered to a date it adjusts the calculation to include cases from that date onwards. I guess i can copy the field but make sure it keeps date PRE FILTER ?

4

How would i take my PD field (calculation for predicted default), and make it so it doesn’t change if i apply a date filter?

image

End result should be that the top one would show the average PD for each month, the bottom one would show the overall PD.

5

Hi @HarveyB-B,

Could you adapt your second calculation to use a LAC-W function?

As a simple example (note, I’m grouping by years not months), if my PD calculation was just
avg(Profit)
And my second PD calculation “PD2” is
avgOver(Profit, [truncDate("YYYY",{Order Date})], PRE_FILTER)

Then if I plot these in a stacked combo chart and add a date filter, by limiting the date filter to the last month of 2020 I can see the different values take effect:

image
image1124×706 64.4 KB

Does this offer a solution and meet your requirement?

Many Thanks,
Andrew