is it possible to display the difference between two value by using a gauge chart?
I have two fields "Alter Wert" and "Neuer Wert" which both represent a date:
If the date in "Alter Wert" is further in the past than the date in "Neuer Wert" I would like the gauge chart to have the red light at the top shown , if the date in "Alter Wert" is newer the green light at the bottom is supposed to show.
Thought I could maybe use variables, but can't figure it out by myself and could need some help.
is it also possible to have the color changed when there is more than one value selected with different combinations of "Alter Wert" and "Neuer Wert".
Example: Select "Geschäftsjahr=2016" - two values (BelegNr) possible, but none directly selected. Therefore, the gauge chart displays only gray. However, since one value is considered critical ("Alter Wert" smaller than "Neuer Wert") the red light would be required.
So, I need to include the condition to have the red light shown whenever there is one or more values critical, even in combination with non-critical values.