Daniel Simpson
Activity overview
Latest activity by Daniel Simpson-
Daniel Simpson commented, Ah yes sorry I see what you mean. Here is what I would do. Create a text box and enter "The revenue in MONTH PLACEHOLDER YEAR PLACEHOLDER for item category CATEGORY PLACEHOLDER was ...
-
Daniel Simpson commented, Hi Stephen, Create a textbox and enter your standard text. Then click the dynamic content braces to the right this allows you to insert desired content. You can then apply local criteria to the t...
-
Daniel Simpson commented, Solution: if sum(0, 0, m1) = 0 then 0 else if sum(1, 0, m1) = 0 then 0 else (sum(0, 0, m1) / sum(1, 0, m1)) - 1 I was unaware the delimiter could be numerical other than zero. Now I know. Note: Th...
-
Daniel Simpson created a post, 2 column headers - Variance Between This Year and Last Year UNDER Day of the Week
I'm curious as to how a measure is inserted for ((TY vs LY) -1) for each day of the week as below:
-
Daniel Simpson commented, Assuming 'Var - %' is a calculation, you need to select calculations then select 'Var - %' then you can select '# Format numbers' and apply formatting to only the desired columns.
-
Daniel Simpson created a post, Sliders
Really struggling to create a date slider visualisation (start date and end date) for the user to select their own date range. Can anyone explain?