Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Create dynamic table based on dropdown filter choice

Hi,  I'm trying to create a dynamic table as a data source in my report using CALENDAR() function. I'm using this function:    CALENDAR(DATE(YEAR([start_date]),month([start_date]),day([start_date]...
Need Help
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi TomMartens ,

 

Here are my tables: 

 

Table1: 

Period                    Start Date          End_Date

Last Week          13th July,2020          19th July,2020

Last Month          1st Jun ,2020          30th Jun ,2020

 

Table2: KPI table

 

Date                KPI volume

1st Jan,2020        xxx

2nd Jan,2020       xxx

.

.

20th July,2020    xxx

 

I'm looking to create a line trend graph (date vs kpi) for the date period i choose from the dropdown filter. If the filter choice is "Last Week", then the graph shoud be for 13-19 july. 

 

 

Is there any other way to do this other than creating a dynamic table?