Hello everyone,
I have a code below I created for formatting on a look. I was able to drill-down a week ago. However, as of this week I am no longer able to drill-down. When I click on the measure, it does nothing and goes nowhere. Can someone please help.
measure: count_for_production_task_monitors {
type: count
html:
{% if tasks.business_days_until_due_grouping._value <= 0 and count_for_production_task_monitors._value ❤️ %}
<a href="#drillmenu" target="_self" style='background: Light Salmon; padding-left: 80%; padding-right: 5%; text-align:right;'>{{ rendered_value }}</a>
{% elsif tasks.business_days_until_due_grouping._value <= 0 and count_for_production_task_monitors._value<5 %}
<a href="#drillmenu" target="_self" style='background: Salmon; padding-left: 80%; padding-right: 5%; text-align:right;'>{{ rendered_value }}</a>
{% elsif tasks.business_days_until_due_grouping._value <= 0%}
<a href="#drillmenu" target="_self" style='background: Red; padding-left: 80%; padding-right: 5%; text-align:right;'>{{ rendered_value }}</a>
{% elsif tasks.business_days_until_due_grouping._value > 0 and count_for_production_task_monitors._value ❤️ %}
<a href="#drillmenu" target="_self" style='background: Light Yellow; padding-left: 80%; padding-right: 5%; text-align:right;'>{{ rendered_value }}</a>
{% elsif tasks.business_days_until_due_grouping._value > 0 and count_for_production_task_monitors._value <5 %}
<a href="#drillmenu" target="_self" style='background: Yellow; padding-left: 80%; padding-right: 5%; text-align:right;'>{{ rendered_value }}</a>
{% elsif tasks.business_days_until_due_grouping._value > 0 %}
<a href="#drillmenu" target="_self" style='background: Orange; padding-left: 80%; padding-right: 5%; text-align:right;'>{{ rendered_value }}</a>
{% else %}
<a href="#drillmenu" target="_self">{{ rendered_value }}</a>
{% endif %}</a>;;
drill_fields: [production_task_types_details*]
}