Filter to only show Relevant Dimension Values
Morning Sisense community! I have my Fact Table and a related Dimension Table. My dimension table contains more unique values than are actually present in the fact table. When I use a field from the Dimension Table as a filter, the filter displays all values from the dimension, even those that have no corresponding fact records. I only want the filter to show dimension values that are relevant to the data in the fact table. Example Tables: fact_table dimension_table id dim_id dim_id dim_name 1 1 1 one 2 2 2 two 3 1 3 three 4 2 4 four fact_table and dimension_table have a relationship in the EC based on dim_id Desired Outcome: In the filter based on dim_name, I only want to see "one" and "two", but currently, I see all four: "one," "two," "three," and "four." How do I achieve my desired outcome?
Pivot Widget - Hide row values in columns category.
Hi, we have requirement to use a report field only for sorting in pivot widget, this field should not be displayed on the report. Need to hide the entire row which contains values 1,2,3,4,... used only for sorting as shown in the screenshot below the SGD field. How can we hide the entire row?Scatter Map Color Break By
According to Documentation for Scatter Map widget, in the Color section only a numeric field can be used. Has anybody managed or found an alternative on how to use a text field instead? We would like for the Scatter map to be color-coded based on a text field. eg. If i have stores from Walmart or Costco, to be able to color code them differently. (blue for Walmart stores & red for Costco)
