I am trying to calculate the number of times an event has occurred during a certain time frame. We can schedule this event twice a week each for the year. I can pull in the number of events to a single score but wanted to use a gauge data visualization.
I want to display # of events that occurred in contrast to max possible, preferably to date. The max field can accomplish this by manually updating the field. For example, if 11 events occurred between now and 6/26 (25 weeks) I can show 11 and manually enter in the max field 25 to get the display I want.
The question is how can I add a calculated value or have the max field update to display the number of weeks from Jan 1st to the current date? on the tooltip it says this field can have some automation but does not explain how.
