Forum Discussion
ROG
Responsive Resident
Responsive Residentfilter in a shape needed.
Hey guys, I have some shapes which I use as traffic lights based on the variance, and one them needs to be filtered for a specific channel. Since it's not possible to add a filter to a shape, wha...
Hi all, I figured out a way to add a filter with a pai chart. You just need to create 3 metrics based on RAG.
1st metric with a logic to glad number below the target. RED
KPI colourR TopUps = IF([KPI Var TopUps] <-0.05, 1,0)2nd logic to flag numbers on the target AMBERKPI colourA TopUps = IF([KPI Var TopUps]>=-0.1 &&[KPI Var TopUps] <0 ,1,0)
3rd logis is for numbers greater than zero. Which would be GREEN.
Once you have these thre metrics, you can add them to the slicers in the PIE chart, and add the respective colours.
ROGResponsive Resident
Responsive ResidentHi all, I figured out a way to add a filter with a pai chart. You just need to create 3 metrics based on RAG.
1st metric with a logic to glad number below the target. RED
KPI colourR TopUps = IF([KPI Var TopUps] <-0.05, 1,0)
2nd logic to flag numbers on the target AMBER
KPI colourA TopUps = IF([KPI Var TopUps]>=-0.1 &&[KPI Var TopUps] <0 ,1,0)
3rd logis is for numbers greater than zero. Which would be GREEN.
Once you have these thre metrics, you can add them to the slicers in the PIE chart, and add the respective colours.
3rd logis is for numbers greater than zero. Which would be GREEN.
Once you have these thre metrics, you can add them to the slicers in the PIE chart, and add the respective colours.