i have measure the YTD SALES AND LYYTD SALES i have validated theris no error
in view and model .but in eI have created two measures — YTD Sales and LY YTD Sales — in my tbl_t_linvhdr.view file.
The LookML has been validated successfully with no errors in both the view and model files.
However, when I open Explore → tbl_t_linvhdr, the measures are not visible.
Only the dimensions (like docdate, amount, etc.) are appearing.
Below is a sample of the code I used:
measure: ytd_sales {
type: sum
sql:
CASE
WHEN EXTRACT(YEAR FROM ${docdate}) = EXTRACT(YEAR FROM CURRENT_DATE)
AND ${docdate} <= CURRENT_DATE
THEN ${amount}
ELSE 0
END ;;
label: “YTD Sales”
}
measure: ly_ytd_sales {
type: sum
sql:
CASE
WHEN EXTRACT(YEAR FROM ${docdate}) = EXTRACT(YEAR FROM CURRENT_DATE) - 1
AND ${docdate} <= CURRENT_DATE - INTERVAL 1 YEAR
THEN ${amount}
ELSE 0
END ;;
label: “LY YTD Sales”
}
My model file includes the correct view reference:
include: “/views/**/tbl_t_linvhdr.view”
and the explore is properly joined to this view.
Still, these measures don’t appear in Explore. Could you please help me understand why and how to make them visible?xplore the measure not showing