Can anyone help me on the below queries
1.How to calculate Halfyear and Financial year for given date(ex:OrderDate).
2.Sales growth TY vs LY (TY=This Year and LY=Last Year) using KPI object with conditioning color.
3.YTD sales, LY YTD sales and Year salary.
Color code: TY YTD<LY YTD, RED arrow down
Color code: TY YTD>LY YTD, Green arrow Up
4.Make a Point Map object showing City wise sales across the globe. Bubble size should vary with sales amount.
TY YTD<LY YTD, RED , TY YTD>LY YTD, Green