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 …
When building a Symbol + Stacked Bar chart, you can set colors for the bars and symbols but are unable to conditionally format colors for the sybmols. In the example above, the field 'net' is construc…
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 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 ite…
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” colu…
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…
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…