cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
lacubrious_d Frequent Visitor
Frequent Visitor

Custom Date Range for a Couple of Visualisations

Hi guys,

 

I've got a report that looks at all time data, however I want to set up two of the widgets to look at data from the last 30 days. Can anyone please suggest a solution?

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
vishnurk Frequent Visitor
Frequent Visitor

Re: Custom Date Range for a Couple of Visualisations

If you want to create measure that always calculate for last 30 days as of today for this then you can try as below:

 

Say you have a measure quantity sold for each days

 

last_30days_quantity_sold = CALCULATE(SUM(<quantity_sold column>),FILTER(ALL(<tablename>),datecolmn name>TODAY()-30))

2 REPLIES 2
Community Support Team
Community Support Team

Re: Custom Date Range for a Couple of Visualisations

Hi @lacubrious_d,

 

There are two solutions. 

1. Add a Visual Level filter. 

2. Add slicers and edit the Interaction. 

Custom_Date_Range_for_a_Couple_of_Visualisations

 

 

Best Regards,
Dale

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
vishnurk Frequent Visitor
Frequent Visitor

Re: Custom Date Range for a Couple of Visualisations

If you want to create measure that always calculate for last 30 days as of today for this then you can try as below:

 

Say you have a measure quantity sold for each days

 

last_30days_quantity_sold = CALCULATE(SUM(<quantity_sold column>),FILTER(ALL(<tablename>),datecolmn name>TODAY()-30))