Skip to main content
Announcements
SYSTEM MAINTENANCE: Thurs., Sept. 19, 1 AM ET, Platform will be unavailable for approx. 60 minutes.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

pie chart

Hello together,

i have a question about the pie chart. I have the table with the dates:

 

LieferdatumBefuellt_Datum
20.12.201620.12.2016
16.12.201618.12.2016
14.12.201614.12.2016
12.12.201612.12.2016
10.12.201611.12.2016
08.12.201609.12.2016
05.12.201605.12.2016
03.12.201603.12.2016
30.11.201630.11.2016

Now I wanted to show

If (Lieferdatum = Befuellt_Datum) than "okay"

If (Lieferdatum > Befuellt_Datum) than "okay"

If (Lieferdatum < Befuellt_Datum) than "wrong"

and this integrated in a pie chart. How is that possible?

10 Replies
Not applicable
Author

While loading you can

If (date(Lieferdatum,'DD.MM.YYYY') >= date(Befuellt_Datum,,'DD.MM.YYYY'),'okay',

If (date(Lieferdatum,,'DD.MM.YYYY') < date(Befuellt_Datum,''DD.MM.YYYY'),'wrong'))