-
How can I make a series of goals on a stacked chart?
Hello! I am trying to make a chart look like this: I have a data set that has goals and I want the series to be the goal milestones and the filled in line to be an operators total sales. I am unsure if there is a chart that can do this or I have a workaround because there are very many goals. My data set looks like this: I…
-
Beast Mode as Chart Label
Hello! I am using the filled gauge chart and was wondering if you could use a beast mode for a label. I am wanting to show if the the target value has been met or not. So it will say either "On Track" and if it hasn't been met it says "Behind Target." I used a case statement to capture that in a beast mode, but don't know…
-
Beast Mode To Find Cumulative Progress Towards a Goal
Hello, I am currently using a filled gauge and I need to create a beast mode that takes the number of days in a month(needs to account for all 12 months) / days total of the month and multiply it by the goal of the month, which will always be 3. Any help appreciated, I have not been able to get my head around what this may…
-
Extract Quarter Value from Date Field and Return First Date of that Quarter
Hello, I need to extract the quarter from a date so it returns that quarter it falls into (example: 01/01/2023 falls into Q1. Instead of Q1 I want it to return the first day of that quarter. Example: DATE 01/05/2023 QTR DATE 01/01/2023 To note I am making a beast mode to do this in a view. I have already tried to use DATE…
