About Lisha_Nandwani

Lisha_Nandwani · 03-04-2020

I need to showcase a date range (start date - end date) (as a dimension) in the format ‘Month Day, Year’, and when applying a filter on it, the date ranges should be sort as dates not as strings.

Lisha_Nandwani · 03-16-2020

I found the solution for this to split the dimension: dimension: date_range { sql: ${start_date};; html: {{ rendered_value | date: ‘%b %d, %Y’ }} - {{ end_date._value | date: ‘%b %d, %Y’ }};; } dimension: period_filter { sql: concat(${start_date}, ’ ...

My Stats

Lisha_Nandwani's Bio

Badges Lisha_Nandwani Earned

Recent Activity

need date range to sort as per dates not string

Re: need date range to sort as per dates not string