-
Hide graphic until filters are selected
I have a line graph that looks like Salvador Dali had at it until the two required filters are set. I tried using an If statement that did improve the way it looks when nothing is selected, choosing either filter turns it back into cubism. CASE WHEN PARENT_BRAND IS NULL THEN 0 WHEN PRODUCT_CATEGORYIS NULL THEN 0 ELSE…
-
Filters and a formula for market share
I'm struggling to create a dynamic market share calculation. Current calc is done via ETL and is too rigid, and frankly imprecise because the calc is at a monthly level, not the timeframe in which the dashboard may be currently filtered. I really need a Beast Mode solution. The core formula is simple: X sales / all sales…
-
HTML Bricks - need color-coding at cell level in a pivot
I have a pivot table that requires formatting the font in cells based on values. For context, the columns are the top 10 brands by sales, the rows are retailers. I was able to hack this by using M-etl and creating essentially a flat table; it worked but when I updated the dataset and any of the columns changed I had to…
