Hi please help me to resolve the below issue.
input file :
| Type Of Circuit | Month | Avg % Uptym |
|---|
| Aug 2011 | 99.713 |
| VPN-NATIONAL | Sep 2011 | 99.95 |
| Jul 2011 | 99.987 |
| Aug 2011 | 99.997 |
| Jul 2011 | 100 |
| MANAGEDSERVICES | Aug 2011 | 100 |
| INSTACC Hosted | Sep 2011 | 100 |
| NPLC | Sep 2011 | 100 |
after formula pivot result is as below:
dimention (Type od circuit,month)
Expression sum(Avg % Uptime)
| Type Of Circuit | Month | Jul 2011 | Aug 2011 | Sep 2011 |
|---|
| INSTACC Hosted | | - | - | 100 |
| MANAGEDSERVICES | | - | 100 | - |
| NPLC | | - | - | 100 |
| VPN-NATIONAL | | - | - | 99.95 |
| - | | 299.987 | 199.71 | - |
again i want to replace null value with 100 which i did using presentation tab.
| Type Of Circuit | Month | Jul 2011 | Aug 2011 | Sep 2011 |
|---|
| INSTACC Hosted | | 100.00 | 100.00 | 100 |
| MANAGEDSERVICES | | 100.00 | 100 | 100.00 |
| NPLC | | 100.00 | 100.00 | 100 |
| VPN-NATIONAL | | 100.00 | 100.00 | 99.95 |
| 100.00 | | 299.987 | 199.71 | 100.00 |
now i want the last result in bar chart. but i am unable to set blank as 100 in bar chart.
Please help. attaching sample qvw for reference
