I am creating a heat map based on two category fields(calculated fields), The plot comes correctly but I want to show null pairs also, eg when data is not present for particular pair categories, it does not display the categories in the Axis, I want it to at least show category pair and show value 0.
‘BMI category’ calculated on the User’s BMI
ifelse(
BMI > 18 AND BMI <= 20, ‘[18, 20]’,
BMI > 20 AND BMI <= 22, ‘[21, 22]’,
BMI > 22 AND BMI <= 24, ‘[23, 24]’,
BMI > 24 AND BMI <= 26, ‘[25, 26]’,
BMI > 26 AND BMI <= 28, ‘[27, 28]’,
BMI > 28 AND BMI <= 30, ‘[29, 30]’,
BMI > 30 AND BMI <= 32, ‘[31, 32]’,
BMI > 32 AND BMI <= 34, ‘[33, 34]’,
BMI > 34 AND BMI <= 36, ‘[35, 36]’,
BMI > 36 AND BMI <= 38, ‘[37, 38]’,
BMI > 38 AND BMI <= 40, ‘[39, 40]’,
‘Above 40’
)
‘Risk Score’ category based on ‘Avg Risk Score’ field of User.
ifelse(
{Avg Risk Score} > 0 AND {Avg Risk Score} <= 10, ‘(0, 10]’,
{Avg Risk Score} > 10 AND {Avg Risk Score} <= 20, ‘(10, 20]’,
{Avg Risk Score} > 20 AND {Avg Risk Score} <= 30, ‘(20, 30]’,
{Avg Risk Score} > 30 AND {Avg Risk Score} <= 40, ‘(30, 40]’,
{Avg Risk Score} > 40 AND {Avg Risk Score} <= 50, ‘(40, 50]’,
{Avg Risk Score} > 50 AND {Avg Risk Score} <= 60, ‘(50, 60]’,
{Avg Risk Score} > 60 AND {Avg Risk Score} <= 70, ‘(60, 70]’,
{Avg Risk Score} > 70 AND {Avg Risk Score} <= 80, ‘(70, 80]’,
{Avg Risk Score} > 80 AND {Avg Risk Score} <= 90, ‘(80, 90]’,
{Avg Risk Score} > 90 AND {Avg Risk Score} <= 100, ‘(90, 100]’,
‘No Data’
)
When I plot a Heap map based on these values, the heat map looks like the below
But I want to chart to be like
Is there a way to achieve this?
Thanks and Regards,