I have a requirement where I have four fields :
1. AverageValue (of a month for some parameter A)
2. ActualValue (on each date for that month for the parameter A)
3. DeviationValue (AverageValue-ActualValue/Average Value --> on each date for the month)---> this field will be color coded based on the devation percentage
4. Each Date for the month with ActualValue
For example say for the month of february the average value is 5:
AverageValue ActualValue DeviationValue(%) Date
5 8 -60 02/06/2017
5 7 -40 02/08/2017
5 9 -80 02/10/2017
I want to display the Deviation value with the color coding in the Calendar Visualization for each month (in this example say February).
I know we need to use time chart command , but some how I am not getting the output . Please help.
... View more