-
Tableau-like parameter actions
Hi all, I'm trying to use a filter inside an aggregation. My data looks like this: On a page, I want to add a slicer/filter that would allow a user to choose a fruit. This would filter the line chart below which would show % of count that the fruit makes up each day. So if a user selects apple, the line chart would have a…
-
How to conditionally format color on Stacked Bar + Symbol Chart
I have a dataset that looks like this: Each row is a day an employee was active. If this was the employee's first day, Hire Flag = 1, else 0. If this was the employee's last day, Term Flag = 1, else 0. I am building a chart to show hires, terms and net over time. It looks like this: I am using a Symbol + Stacked Bar chart…
-
Tableau-like Parameter actions
I am trying to allow a user to filter a chart that uses an aggregation. My data looks like this: I want a user to be able to choose 'Apple' and then the ensuing line chart would show percentage of items each day that were apple (40% over 1/1, 30% over 1/2, and 60% over 1/3). In tableau, I would set up a parameter (p_fruit)…
-
Nested Filters
Hi all, I’ve run into a puzzle on a dashboard and am wondering if you have advice. (See screenshot for dummy data to illustrate the issue). All charts in the dashboard are filtered by the “State” column. Initially, we were going to just have the user select their “State” in a filter. The issue is that “State” is kind of a…
-
Sorting 100% Stacked Bar by category
I have a 100% Stacked Bar Chart for net hours worked. Each bar is an employee and is broken into net hours by pay category (OT1.5 vs. OT2.0 vs. Reg). I want to sort the chart so that the employee with the lowest percentage of OT1.5 is on top and the employee with the largest percentage is on bottom. I started by fiddling…
-
Aggregating a column in Beast Mode
Is it possible to aggregate an entire column in a beast mode calculation within analyzer? (I have found videos explaining this within a SQL ETL, but not as a calculated field in analyzer). For example: In the table below I want to divide the value in the "efficiency" column by the averge of all values in the column. Right…
