0

Custom Radio button in filter and prompts

Hi everyone,

Can I create a custom radio button in filter and prompts with filter value is [all, parent store(which storeid is 1,2,3), children store(which storeid is  11, 12, 21, 22, 31, 32)]

Thank you so much.

3replies Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
  • 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.

    Like
      • Nopu Nguyen
      • Human
      • Nopu_Nguyen
      • 1 mth ago
      • Reported - view

      Dylan Wan Thank you for replying,

      I have did follow option 2 but at step 3, I can not save the formula because below error

      Formula cannot be saved. No matching signature found for function: "case" with params: [BOOLEAN, BOOLEAN, BOOLEAN, BOOLEAN, BOOLEAN, BOOLEAN, BOOLEAN], Hint for schema formula columns: check that there is no nested schema formulas

      Like
      • Nopu Nguyen
      • Human
      • Nopu_Nguyen
      • 1 mth ago
      • 1
      • Reported - view

      Dylan Wan thank you, I have resolved it, I change 'case' to 'if' and it work for me.

      Thanks so much. !

      Like 1
Like Follow
  • Status Answered
  • 1 mth agoLast active
  • 3Replies
  • 21Views
  • 2 Following

Product Announcement

Incorta 5 is now Generally Available