Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
In a line chart, I want to show the production values for two different periods. What is the best way to realize this?
Use if statement in the background color
If(Dim2 = 'XYZ', Yellow(), Blue())
The color isn't the problem... How to show the second line with a different timestamp?
May be like this as your calculated dimension
Dual(Date & Chr(10) & AddYear(Date, -1), Date)
Hi,
front end solution could be:
or
but I would suggest to use the calculated dimension expressions in the script to generate additional fields you could use in the charts instead.
hope this helps
regards
Marco
Thanks Marco for your examples. They are helpful for my problem, but not the complete solution. The two dates belong to two different (independent) fields, with a selection for both fields...
A_Timestamp A_Percentage
18-04-2016 54.6
19-04-2016 76.4
B_Timestamp B_Percentage
20-05-2016 12.4
21-05-2016 54.3
22-05-2016 65.3
Thanks for your answer, but my problem is unfortunately more difficult. See below...