How to create a Filter Of Time based on a combo with different time

143kishornaidu
143kishornaidu
in Modeling
Screenshot 2024-07-31 200724.png

Here i want to have a time filter based on the combo . Where user filter highlighted(Red Colour) year . then dynamically the time filter should be applied 2025 to 2026

Answers

  • Dikshant
    Dikshant

    @143kishornaidu - Let me know if you need this type of filtering capability.

    If you select FY24, all FY24 months get filtered.

    image.png

    If you select FY25, all FY25 months get filtered.

    image.png

    If the filter is blank, then both FY24 and FY25 months will be visible.

    image.png

    Let me know if you requirement is little different with this one.

  • 143kishornaidu
    143kishornaidu
    edited August 5
    Screenshot 2024-07-31 200724.png

    My requirement is User should Filter the combos in Rows . Like if they filter combo 1. On the time dimension which in column need to show only only where non-zerovalue only for the combo 1

  • Dikshant
    Dikshant

    In this case, you need to pivot the combo list and week both in rows.

    Combo 1

    Week 1

    Combo 1

    Week 2

    Combo 2

    Week 1

    Combo 3

    Week 1

    Combo 3

    Week 2

    Combo 3

    Week 3

Categories