Skip to content

    • SQL DataFlows

    SQL DataFlows

    dashboard not reflecting filtered values

    Contributor
    in SQL DataFlows

    I have a dashboard which has filters by semester term and college.
    There is a column for type of housing and a metric in the dashboard. The metric should display upon the filter on college as a whole as it is constant across all terms . However, it displays only upon filtering the terms, as the data is present across rows alongside semester terms.
    How do I achieve the display upon filtering the chapter?
    Can I use a formula of group by saying, when the housing type is constant across all terms then display the constant term?
    If yes how do i achieve that?

    Tagged:

    Answers

    • Domo Employee

      Hi @art_in_sky - could you provide some more information about your data structure? Maybe provide a few rows of data (feel free to change the data, but keep the schema consistent). This would help get an answer to your question.

    • Contributor
      image.png

      the first column is the college and the second column is the semester term. It displays only when term semester is filtered and when college is filtered , it does not display the value that is constant across all terms.

    Welcome!

    It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.
    Sign In

    Welcome!

    It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.
    Sign In

    Quick Links

    Categories