Forum Discussion
Helper IIUsing a filter for custom date periods, how I display 2 separate graphs with 2 different time period
HI MyWeeLola,
In fact, you not need to create a new table. The switch function are used to confirm the period duration which will be used in the calculate expressions.
For example:
The MTD the period duration is month, the YTD is year, QTD is quarter.
For above scenario, you can add a variable with switch function to convert them to days, then you can use this as condition in expressions.
Regards,
Xiaoxin Sheng
Helper IIAnonymous
Thank you for the response.
Would the following work in principle?
On the result of the switch statement, I could set a min and max date. I would then either create or filter a second date table based on those values, and then apply at date range to the second graph.
What would bite me using that methodology?
Lola
HI MyWeeLola,
In fact, you not need to create a new table. The switch function are used to confirm the period duration which will be used in the calculate expressions.
For example:
The MTD the period duration is month, the YTD is year, QTD is quarter.
For above scenario, you can add a variable with switch function to convert them to days, then you can use this as condition in expressions.
Regards,
Xiaoxin Sheng
- MyWeeLola
Anonymous
Thank you for the response. I got it working with the second table. That you for your time. It is appreciated.
Lola