Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, Here i'm in Middle of some critical set analysis
i have region_name
1)WEST
2)NORTH
3) EAST
4) SOUTH
branch_type
1)PT
2)DEPOT
Four groups of Temperature for region (A)
above -10 |
-10.1 to -13.9 |
-14 to -17.9 |
-22 & below |
Groups of Temperature for PT And DEPOT
PT (B)
above -10 |
-10.1 to -13.9 |
-14 to -17.9 |
-18 & below |
DEPOT (C)
above -10 |
-10.1 to -13.9 |
-14 to -17.9 |
-20 & below |
Question first--> i want four(now according to database it can show only for WEST) stack bar chart for all region in which
Percentage as like this--->
Count({$<param_name={'Temperature'}, region_name={'WEST'}>}param_value)
/count(total{$<param_name={'Temperature'}>}param_value)*100
but in four groups of temperature see above for REGION (A) in stack BAR
Question two-->
in another Bar chart for stack style
same for branch_type but
how i can give those grouping (B)&(C) which are different for ST and DEPOT.?
How can i calculate percentage for ST and DEPOT in same Stack Bar chart for Different Temperature GROUP (B)&(C)?
i attached sample data QVW.
Create a bar Chart
Calculated Dimension
=IF(param_value >= -10, 'Above -10',
If(param_value < -10 and param_value > -14, '-10 to -13.9',
If(param_value <= -14 and param_value > -18, '-14 to -17.9',
If(param_value <= -18 and param_value > -22, '-18 to -21.0',
'Below -22'))))
Expression
already given by you...
Create a bar Chart
Calculated Dimension
=IF(param_value >= -10, 'Above -10',
If(param_value < -10 and param_value > -14, '-10 to -13.9',
If(param_value <= -14 and param_value > -18, '-14 to -17.9',
If(param_value <= -18 and param_value > -22, '-18 to -21.0',
'Below -22'))))
Expression
already given by you...
How can i use calculated dimension for PT And DEPOT and their DIFFERENT GROUPS of TEMPERATURE at a tIme in my Bar chart of stack style ?
What i need to change in my EXPRESSION to calculate Percentage for both PT And DEPOT ?
Suppose i want to give color for group of temperature in my stack bar chart so where i have to put color function?