Fabian Duerr
-
Posts
482 -
Joined
-
Last visited
Community Answers
-
Fabian Duerr's post in Hi All, I have created a combination chart for trend. On X-axis, I have a date in quarter format and on Y-axis, I have numbers. I want to display last 3 quarters on X -axis. Can somebody please help me with this? was marked as the answer
To limit data only in certain visualizations I suggest to work with data limiting expressions. You can find this option in the properties of your visualization under "Data". A data limiting must always evaluate to TRUE or FALSE (boolean)
For the last three quarters you could use:
(YEAR(Max([DATE])) - YEAR([DATE]))*4 + (QUARTER(Max([DATE])) - QUARTER([DATE])) < 3For the last three months you would use:
(YEAR(Max([DATE])) - YEAR([DATE]))*12 + (MONTH(Max([DATE])) - MONTH([DATE])) < 3Here, [DATE] is your date column
If the reference date is not the last date in your dataset but today then replace Max([DATE]) with Today()
-
Fabian Duerr's post in Can you create multiple columns in a Text Area visualization for Filters? was marked as the answer
Edit the text area and make sure that you have two filters within one line (without a line break).
Also make sure that the width of the text area is large enough to fit both filters.
To ensure that the width of the text area is maintained for various window sizes and resolution, please lock the visualization area (Visualizations -> Arrange Vis.-> Lock Vis. Area)