Need help on Date Filter

[Anonymous]

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

[vivek_niti]

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

[Anonymous]

Thanks for your reply

Quarter field is derived from month field in  backend itself

[Anonymous]

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

[Anonymous]

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

[Anonymous]

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

[Anonymous]

Hi Balkumar I am also used same logic but not getting result