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.