April 13, 2015

# Single Parameter with 4 KPI's

Posted by Sankarmagesh Rajan Apr 13, 2015

Step:1

Create one [Show Selection] and add list as Actual and Target.

Step:2

Create calculation as

case [Target parameter]

when "Actual" then [Actual Value]

when "Target" then [Target Value]

end

Step:3

Create 2nd calculation as

case [Actual parameter]

when "Actual" then [Actual Qty]

when "Target" then [Target Qty]

end

Step:4

Drag this two calculations into row.

Step:5

Show parameter and select Actual or target.

Note:

if you want to show multi measure in single axis

Drag measure name into column and measure value into row.

Remove other measure and add only calculated data.

# Dynamic measure selection and aggragation selection with parameter

Posted by Sankarmagesh Rajan Apr 13, 2015

# Step:1

Create parameter [Measure Parameter] list as sales, profit and Unit Price

# Step:2

Create parameter [Agg Measure Parameter] list as Sum and Avg

Step:3

Create calculation as follows [Measure Agg Calc]

IF [Measure Parameter] ="Sales" and [Agg Measure Parameter] ="SUM" then SUM([Sales])

ELSEIF [Measure Parameter] ="Profit" and [Agg Measure Parameter] ="SUM" then SUM([Profit])

ELSEIF [Measure Parameter] ="Unit Price" and [Agg Measure Parameter] ="SUM" then SUM([Unit Price])

ELSEIF  [Measure Parameter] ="Sales" and  [Agg Measure Parameter] =”Avg” then AVG([Sales])

ELSEIF [Display Selection] ="Profit" and [Agg Measure Parameter] ="Avg" then AVG([Profit])

ELSEIF [Measure Parameter] ="Unit Price" and [Agg Measure Parameter] ="Avg" then AVG([Unit Price])

END

# Step:4

Drag this [Measure Agg Calc] into column and drag any of dimensions into row

# Step:5

Show Parameter control and select Kpis.

# Dynamic Measure Parameter

Posted by Sankarmagesh Rajan Apr 13, 2015

# Step:1

Create parameter [Measure Parameter] list as Sales, Profit and Unit Price

# Step:2

Create calculation as follows [Measure Calc]

case [Measure Parameter]

when "Sales" then [Sales]

when "Profit" then [Profit]

when "Unit Price" then [Unit Price]

end

# Step:3

Drag this [Measure Calc] into coloumn and drag any of dimensions into row

# Step:4

Show Parameter control and select Kpis.

# Top & Bottom with other customers

Posted by Sankarmagesh Rajan Apr 13, 2015

By using Index( ) in calculated filed and drag that calculated field in rows shelf we can achieve this.Please find the attached twbx.I hope this solves your problem

Step1: Create calc field called index ie index( )

Step2: Drag the customer name and calc field index into row shelf.

Right click customer name descending and sort via field [sales]

Step3: create [Top N] parameter with integer data type

Step 4:Create calc field called top10? Title Top 10 calculations – Top10?

if [Index]<=[Top N] THEN "Top N"  ELSE IF [Index]>=SIZE()-[Top N]

THEN  "Bottom n"  else “Others” end end

Drag calculation field Top 10? Into filter then select top n and bottom n.

Drag the new calculation into row.

show parameter control and type 10,20 etc

By date: By tag: