Set analysis

sspawar88 — Tue, 14 Jul 2015 12:57:30 GMT

in one Bar chart in which dimension is region_name and expression is :

Count({$<param_name={'Temperature'},param_value={'<=-1'}>}param_value)/

Count(total <region_name>{<param_name={'Temperature'},param_value={'<=-1'}>}param_value)*100

in another bar chart in which dimension is branch_type and expression is :

Count({$<param_name={'Temperature'},param_value={'<=-1'}>}param_value)/

Count(total <branch_type>{<param_name={'Temperature'},param_value={'<=-1'}>}param_value)*100

In Pivot table i have two dimensions region_name and branch_type and expression is :

Count({$<param_name={'Temperature'},param_value={'<=-1'}>}param_value)/

Count({1<param_name={'Temperature'},param_value={'<=-1'}>}param_value)*100

Can i get the same value in pivot table same as both bar charts ?

Re: Set analysis

Mon, 20 Jul 2015 09:39:18 GMT

Hi,

Possibly yes! Looks fine to me

it would be best if you could experiment with the data and show what you've got