Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Team,
Hope all are doing good.
I need help on date filter.
Actually I have time filters like Year,Quarter and MOnth.
The issue is if I select any year and followed by any quarter the data is filtering and displaying on dashboard.
But the main issue is coming when I change the quarter filter selection the data is not filtering instead the selections are clearing..
.This issue could be due to Quarter is derived from Month.I think we can derive Quarter directly based on user selections on the Fly instead of getting it from DM .How to do this.
Thanks In advance
Best Regards
Anusha K
Hi,
Instead of creating the quarters at the front end, I would suggest you to create a separate calendar and then link the calendar with the transactions.
Regards,
Vivek
Thanks for your reply
Quarter field is derived from month field in backend itself
Hi Anusha have you used same datecolumn to calulate Year,Qtr,Month ?
can you share the YEAR ,QTR ,Month calculation part from your script
Thanks
BKC
use below code to calculate the Year, QTR and Month
LOAD DISTINCT
Year(Temp_Date) * 100 + Month(Temp_Date) as [Period],
Year(Temp_Date) as [Year],
Month(Temp_Date) as [Month],
Date(Temp_Date, 'YYYY-MM') as [Year - Month],
'Q' & Ceil(Month(Temp_Date) / 3) as [Quarter]
;
Thanks
BKC
Hi BalKumar,
we are getting the fields like this
[Payment Date] as Prod_Date,
Year([ Payment Date]) as Year,
Month([Payment Date]) as Month,
if(IsNull([Payment Date]) = 0, 'Q'& Ceil(Month([Payment Date])/3)) As Quarter
Hi Balkumar I am also used same logic but not getting result