Custom Radio button in filter and prompts

A prompt or a presentation variable can be added to a dashboard by going the Filter and Prompt page.  Incorta dashboard prompt or a presentation variable may not look like a radio button but the functionality is the same.

Option 1: Use a formula column as a prompt

If you don't want to see the individual values but only the two non overlapping values: Parent Store and Children Store, a formula column based prompt can be used.

1. Drag and drop the new formula to the prompt area, names it "Parent/Child Store"

2. Enter a formula like this:

CASE(IN(schematable.storeid, 1,2, 3), "Parent Store", IN(schematable.storeid, 11, 12, 21, 22, 31, 32), "Children Store", "Others")

The  three values "Parent Store", "Children Store", "Others" will be shown in the list of values.

The user will be allowed to select both value as the prompt can support multiple select.

Option 2: Use Presentation Variable

If you want to see all three values as All, Parent Store, Child Store. Since these values meanings are not exclusive, we can use a presentation variable.

1. Create a table with the three values.

It can be CSV file or a dummy table with a SQL like this:

SELECT "All" FROM DUAL
UNION ALL
SELECT "Parent Store" FROM  DUAL
UNION ALL
SELECT "Child Store" FROM DUAL

2. Create a presentation variable

Drag and Drop New Variable

Enter info like the one below:

 

Drag the column from the table created in step 1, so those three values will be shown to the users.

3. Add an Applied Filter

Drag and Drop New formula

This formula will return a boolean

case($STORE_SELECTION="All", 1=1,
$STORE_SELECTION="Parent Store", IN(schematable.storeid, 1,2,3),
$STORE_SELECTION="Child Store", IN(schematable.storeid, 11, 12, 21, 22, 31, 32),
1=0)

Depending on the selected value from the presentation variable, different filters will be applied to the entire dashboard.

 

Hope this helps.