Hi All,
I am trying to utilize in built Map chart in the Dashboard but facing issue in it.
Attached is the pic of the same.
Middle chart coming fine with the Color combination required
i.e.
| | | | | Low Range | High Range |
| rgb(192,000,000) | C00000 | Red | <-15 and Below | -15 | |
| rgb(255,192,0) | FFC000 | Amber | >=-15 to <0 | -15 | 0 |
| rgb(146,208,80) | 92d050 | Green | >=0 to <=15 | 0 | 15 |
| rgb(84,130,53) | 548235 | Dark G | 15 and Above | | 15 |
Formulas Used:
| Map 1 | | | |
| vDSFLPvsBUDCERFY% | | | num(Alt((sum({$<DataFlag={'LP'},[MRH COA Level 9]={90001000},CalendarYear={$(vYearSelection)},CalendarMonthNumber={">=1<=12"},[LP Reporting Month]={$(vLPMaxMonth)},CalendarMonthName=>} [VAR LP BUD CER])/ |
| | | | sum({$<DataFlag={'Sales/GP'},Sales={"*"},CalendarMonthNumber={">=1<=12"},CalendarYear={$(vYearSelection)},[LP Reporting Month],CalendarMonthName=>}BUD)),0)*100,'#,##0.0') |
| Map 2 | | | |
| vSalesYTDBudCER% | | | num(ALT((sum({$<DataFlag={'Sales/GP'},Sales={"*"},CalendarMonthNumber={">=1<=$(vMonth)"},CalendarYear={$(vYearSelection)},[LP Reporting Month]=,CalendarMonthName=>}[VAR ACT BUD CER])/ |
| | | | sum({$<DataFlag={'Sales/GP'},Sales={"*"},CalendarMonthNumber={">=1<=$(vMonth)"},CalendarYear={$(vYearSelection)},[LP Reporting Month]=,CalendarMonthName=>} BUD)),0.0)*100,'#,##0.0') |
| | | | |
| Map3 | | | |
| (vGpCERYTD%) | | | if(not isnull(num((sum({$<DataFlag={'Sales/GP'},GP={"*"},CalendarMonthNumber={">=1<=$(vMonth)"},CalendarYear={$(vYearSelection)},[LP Reporting Month]=,CalendarMonthName=>}[VAR ACT BUD CER])/ |
| | | | sum({$<DataFlag={'Sales/GP'},GP={"*"},CalendarMonthNumber={">=1<=$(vMonth)"},CalendarYear={$(vYearSelection)},[LP Reporting Month]=,CalendarMonthName=>} BUD) )*100,'#,##0.0')), |
| | | | (num((sum({$<DataFlag={'Sales/GP'},GP={"*"},CalendarMonthNumber={">=1<=$(vMonth)"},CalendarYear={$(vYearSelection)},[LP Reporting Month]=,CalendarMonthName=>}[VAR ACT BUD CER])/ |
| | | | sum({$<DataFlag={'Sales/GP'},GP={"*"},CalendarMonthNumber={">=1<=$(vMonth)"},CalendarYear={$(vYearSelection)},[LP Reporting Month]=,CalendarMonthName=>} BUD) )*100,'#,##0.0')) ,0.0) |
Inside the Map:
Under Layers:
Dimension used: ISO Code
Location type: Country Code ISO 2
Color:
"Expression" is selected and wrote:
If($(vDSFLPvsBUDCERFY%)>=15,RGB(84,130,53) ,
if($(vDSFLPvsBUDCERFY%)>=0 and $(vDSFLPvsBUDCERFY%)<=15, rgb(146,208,80) ,
if($(vDSFLPvsBUDCERFY%)>=-15 and $(vDSFLPvsBUDCERFY%)<0, rgb(255,192,000),
if($(vDSFLPvsBUDCERFY%)<-15,rgb(192,000,000)
))))
The check - box of Expression is color coded is checked.
Map 1 and Map 3 are coming in Amber color where as Map 2 coming in all the given colors.
Kindly extend your help.
Thanks and Regards,
Pradnya.
