DayBackForFileMaker

Calendar Analytics

DayBackForFileMaker.Analytics History

Hide minor edits - Show changes to output

December 31, 2019, at 07:00 PM by 192.88.134.15 -
Changed line 5 from:
Analytics adds a chart to the [[Gantt Charts | horizon view]] of your calendar, so you can quantify data across the days, weeks, and months you're looking at.
to:
Analytics adds a chart  to your calendar, so you can quantify data across the days, weeks, and months you're looking at.
June 18, 2019, at 08:36 PM by KC Embrey - #TurningOff
Added line 106:
[[#TurningOff]]
August 03, 2018, at 12:31 AM by 192.88.134.15 -
Added lines 60-68:

DayBack applies some styling to the number labels automatically, such as reducing the size of the "after" table if it's more than a single character. You can override some of this in DayBack's [[CSS]].

Here are the classes you can target to change how the before and after labels appear. "label-short" is used when the value in formatting is a single character; "label-long" is used when it's more than one character.

--> .label-after-value.label-long
--> .label-after-value.label-short
--> .label-before-value.label-long
--> .label-before-value.label-long
August 03, 2018, at 12:02 AM by 192.88.134.15 -
Changed lines 58-59 from:
''Coming soon.''
to:

Formatting lets you apply a prefix or suffix to your numbers so they can look like more accurately like currency. You can also control the number of decimal places that show on the chart: leaving decimal places blank will show the numbers at whatever decimal precision they have in your original fields.
July 30, 2018, at 08:32 PM by 192.88.134.15 -
Changed line 17 from:
• What's our estimated revenue three months out? \\
to:
• What's our estimated revenue three months out?
July 30, 2018, at 08:32 PM by 192.88.134.15 -
Added line 19:
Learn more and view some use-case videos here: %newwin% [[https://www.seedcode.com/calendar-analytics-filemaker/ | Calendar Analytics: Examples]].
July 30, 2018, at 03:45 PM by 192.88.134.15 -
Deleted lines 1-3:
'''Coming soon!''' %newwin% [[https://www.seedcode.com/preview-calendar-analytics/ | Analytics]] are coming to DayBack Calendar

Because knowing how often things happen is a different kind of knowing.
July 30, 2018, at 01:14 AM by 192.88.134.15 -
Changed lines 30-34 from:
1. You can chart the values in any [[additional fields]] you've added to DayBack from your FileMaker table.

2. DayBack will also chart the number of items: it will count how many events you have each day, week, etc.

3. Or you can have DayBack add up the duration of your events.
to:
-> '''1.''' You can chart the values in any [[additional fields]] you've added to DayBack from your FileMaker table.

-> '''2.''' DayBack will also chart the number of items: it will count how many events you have each day, week, etc.

-> '''3.''' Or you can have DayBack add up the duration of your events.
July 30, 2018, at 01:13 AM by 192.88.134.15 -
Changed lines 114-122 from:
If you're hiding the settings cog, you should also go to "Administrator Settings" -> "Views" and then setting "Show Measure Settings" to false. That way it won't show settings by default when showing a chart.
to:
If you're hiding the settings cog, you should also go to "Administrator Settings" -> "Views" and then setting "Show Measure Settings" to false. That way it won't show settings by default when showing a chart.



----

!! Limitations

Calendar Analytics is currently only available on the horizon view and is limited to showing one chart at a time. It also employs just one chart type (the line chart you see above). If you have use cases that call for more, please get in touch and %newwin% [[https://www.seedcode.com/contact/" | tell us about them]]. We look forward to expanding analytics based on your feedback
.
July 28, 2018, at 11:14 PM by 192.88.134.15 -
Added lines 43-44:

If you're [[YourOwnEventLayouts | using your own FileMaker layouts]] to edit event, instead of using DayBack's built-in popover, you may not have created any additional fields yet in DayBack' settings scripts and calcs: because the fields are just showing up on your layouts. You'll want to set up additional fields for any fields you'd like to chart with analytics; follow the instructions here to create them: [[additional fields]].
July 26, 2018, at 03:03 AM by 192.88.134.15 -
Changed lines 30-31 from:
1. You can chart the values in any additional field you've added to DayBack from your FileMaker table.
to:
1. You can chart the values in any [[additional fields]] you've added to DayBack from your FileMaker table.
Changed lines 40-41 from:
You're selecting the label of the field that you assigned when you set up the additional field in DayBack: this is the label that shows to the left of the field in DayBack's popover (except for the built-in Title and Description fields, which are just called "Title" and "Description"). So if you elect to chart on a field labeled "Est Hours", DayBack will include values from any active calendar source where there is an additional field named "Est Hours", even if the actual fields in the different FileMaker tables or Salesforce objects have different column names.
to:
You're selecting the label of the field that you assigned when you set up the additional field in DayBack: this is the label that shows to the left of the field in DayBack's popover (except for the built-in Title and Description fields, which are just called "Title" and "Description"). So if you elect to chart on a field labeled "Est Hours", DayBack will include values from any active calendar source where there is an additional field named "Est Hours", even if the actual fields in the different FileMaker tables have different column names.
Changed lines 64-67 from:
''Coming soon.''

----

to:

The orange dotted line in the screenshot above is the threshold for your chart. It's optional, and it's used to quickly show if you're meeting your goals. To turn the threshold off, just clear the "Value" field in the setting's Threshold tab (don't set it to zero).
Changed lines 69-70 from:
You can change the appearance of the threshold by manipulating DayBack's [[CSS]]. Here are the current values for threshold line:
to:
You can change the appearance of the threshold in settings or by manipulating DayBack's [[CSS]]. The reason to use CSS if you'd like to go further than the options provided in settings or if you'd like to set up calendar-specific threshold appearance. For example, you may have one source, Forecast Revenue, where crossing the threshold is a good thing and you'd want the threshold green. Another source may represent your production capacity and crossing the threshold would mean overscheduling your team: that threshold would probably be one of the caution colors like orange.

You can make calendar-specific CSS by including the name of the calendar as a class. For example, you may have one source were exceeding the threshold is a good thing (like exceeding your sales forecast) and another where exceeding is a bad thing (exceeding would mean you've overextended yourself). So you can create a threshold style for each source. Here's the CSS above set to only apply to a calendar named "Sales Forecast" (use the case-sensitive calendar name with spaces and the "@" sign removed):

-->.SalesForecast .ct-area.ct-threshold-above {
--->    fill: orange !important;
-->}

If you'd like to make the changes in CSS, here
are the current values for threshold line:
Deleted lines 92-96:
Note that you can make calendar-specific CSS by including the name of the calendar as a class. For example, you may have one source were exceeding the threshold is a good thing (like exceeding your sales forecast) and another where exceeding is a bad thing (exceeding would mean you've overextended yourself). So you can create a threshold style for each source. Here's the CSS above set to only apply to a calendar named "Sales Forecast" (use the case-sensitive calendar name with spaces and the "@" sign removed):

-->.SalesForecast .ct-area.ct-threshold-above {
--->    fill: orange !important;
-->}
July 26, 2018, at 02:58 AM by 192.88.134.15 -
Added line 21:
July 26, 2018, at 02:58 AM by 192.88.134.15 -
Changed lines 16-20 from:
• When do I need to begin work on this project?
Do we have the capacity to take on this new job?
Have I blocked off enough time to meet this deadline?
How often are we exceeding our goals?
What's our estimated revenue three months out?
to:
• When do I need to begin work on this project? \\
Do we have the capacity to take on this new job? \\
Have I blocked off enough time to meet this deadline? \\
How often are we exceeding our goals? \\
What's our estimated revenue three months out? \\
July 26, 2018, at 02:57 AM by 192.88.134.15 -
Changed lines 25-26 from:
!! Chart Data
''Coming soon.''
to:
!! Chart Data: What Can I Measure

There are three options for charting your data.

1. You can chart the values in any additional field you've added to DayBack from your FileMaker table.

2. DayBack will also chart the number of items: it will count how many events you have each day, week, etc.

3. Or you can have DayBack add up the duration of your events.
 
!!! Additional Fields

Select this first option and you'll see a list of the fields available for analysis. This will include the additional fields in any currently selected source along with the title and description fields. You'll see just the fields you've set up as text or number fields--those are the only kinds DayBack can perform math on. And when it comes to text fields, DayBack can only include them in the chart if all they include is a number. So if your text field contains solely "6", that will get added to that day's/week's total; if the field contains "6 lawnmowers", it won't be included.

You're selecting the label of the field that you assigned when you set up the additional field in DayBack: this is the label that shows to the left of the field in DayBack's popover (except for the built-in Title and Description fields, which are just called "Title" and "Description"). So if you elect to chart on a field labeled "Est Hours", DayBack will include values from any active calendar source where there is an additional field named "Est Hours", even if the actual fields in the different FileMaker tables or Salesforce objects have different column names.

This means that if you give your additional fields the same names in DayBack you can aggregate data across different calendar sources. Pretty cool.

For multi-day events, DayBack will apportion the field value across each day. So if you're charting an additional field named "Est Hours" and have 20 hours estimated for a 4-day event, DayBack will count 5 hours of that estimate against each of those four days.

!!! Number of Items

With this option selected, DayBack will chart the number of events for each day, week, or month. It's simply counting all the events you've filtered into view. For example, if you have installation teams that can install 5 units per day, you can set the threshold at "5" and easily see which days your installers may be overbooked.

!!! Duration

Like the "number of items" option, this setting asks DayBack to count up the events you've filtered into view, but it counts their duration. So if you're blocking off time to work on a presentation you can filter for "Presentation" and DayBack will tell you how much time you've blocked off over the next few weeks.
July 26, 2018, at 02:56 AM by 192.88.134.15 -
Changed line 10 from:
%newwin, width=500% [https://www.seedcode.com/wp-content/uploads/2018/07/AnalyticsPreviewHero_FMPn.png | https://www.seedcode.com/wp-content/uploads/2018/07/AnalyticsPreviewHero_FMPnsm.png]]
to:
%newwin, width=500% [[https://www.seedcode.com/wp-content/uploads/2018/07/AnalyticsPreviewHero_FMPn.png | https://www.seedcode.com/wp-content/uploads/2018/07/AnalyticsPreviewHero_FMPnsm.png]]
July 26, 2018, at 02:55 AM by 192.88.134.15 -
Changed line 10 from:
%newwin, width=500% [[https://46p2yg36reid1zp9ic1aj732-wpengine.netdna-ssl.com/wp-content/uploads/2018/07/AnalyticsPreviewHero.png | https://46p2yg36reid1zp9ic1aj732-wpengine.netdna-ssl.com/wp-content/uploads/2018/07/AnalyticsPreviewHero_sm.png]]
to:
%newwin, width=500% [https://www.seedcode.com/wp-content/uploads/2018/07/AnalyticsPreviewHero_FMPn.png | https://www.seedcode.com/wp-content/uploads/2018/07/AnalyticsPreviewHero_FMPnsm.png]]
July 26, 2018, at 02:54 AM by 192.88.134.15 -
Changed line 10 from:
to:
%newwin, width=500% [[https://46p2yg36reid1zp9ic1aj732-wpengine.netdna-ssl.com/wp-content/uploads/2018/07/AnalyticsPreviewHero.png | https://46p2yg36reid1zp9ic1aj732-wpengine.netdna-ssl.com/wp-content/uploads/2018/07/AnalyticsPreviewHero_sm.png]]
July 26, 2018, at 02:53 AM by 192.88.134.15 -
Added lines 9-20:



The chart responds as you reschedule items so you can quickly see if your plans are lining up with your goals. Now you can see the consequences of your decisions right in the calendar.

Analytics is designed to answer questions like these:

• When do I need to begin work on this project?
• Do we have the capacity to take on this new job?
• Have I blocked off enough time to meet this deadline?
• How often are we exceeding our goals?
• What's our estimated revenue three months out?
July 26, 2018, at 02:52 AM by 192.88.134.15 -
July 26, 2018, at 02:52 AM by 192.88.134.15 -
Deleted lines 3-6:
-> • chart event data across time
-> • compare values across statuses and resources
-> • track progress against goals

Added lines 7-13:

Analytics adds a chart to the [[Gantt Charts | horizon view]] of your calendar, so you can quantify data across the days, weeks, and months you're looking at.

----

[[#data]]
!! Chart Data
Changed lines 16-17 from:
[[#data]]
!! Chart Data
to:
----

[[#formattng]]
!! Number Formatting
Changed lines 22-23 from:
[[#formattng]] 
!! Number Formatting
to:
----

[[#threshold]]
!! Threshold: Charting Against Goals
Changed lines 28-31 from:
[[#threshold]]
!! Threshold: Charting Against Goals
''Coming soon.''

to:
----
Added lines 53-54:

----
July 24, 2018, at 09:03 PM by 192.88.134.15 -
Changed line 2 from:
'''Coming soon!''' Analytics is coming to DayBack Calendar
to:
'''Coming soon!''' %newwin% [[https://www.seedcode.com/preview-calendar-analytics/ | Analytics]] are coming to DayBack Calendar
July 24, 2018, at 08:59 PM by 192.88.134.15 -
Changed line 51 from:
You can turn this feature off by adding the following CSS to DatBack. This will remove the round button used to bring up the chart:
to:
You can turn this feature off by adding the following [[CSS]] to DayBack. This will remove the round button used to bring up the chart:
July 24, 2018, at 08:58 PM by 192.88.134.15 -
Changed lines 47-65 from:
-->}
to:
-->}

!! Turning Analytics Off

You can turn this feature off by adding the following CSS to DatBack. This will remove the round button used to bring up the chart:

-->.measure-button-container {
---> display: none !important;
-->}

Note that you can remove Analytics from shares by simply adding .share-only above, so the first line reads .share-only .measure-button-container {

If you want to show the chart but not let people adjust the chart settings, you can remove the settings cog with this:

-->.measure-settings-show {
---> display: none !important;
-->}

If you're hiding the settings cog, you should also go to "Administrator Settings" -> "Views" and then setting "Show Measure Settings" to false. That way it won't show settings by default when showing a chart.
July 18, 2018, at 08:54 PM by 192.88.134.15 -
Changed lines 27-28 from:
You can change the appearance of the threshold by manipulating DayBack's CSS. Here are the current values for threshold line:
to:
You can change the appearance of the threshold by manipulating DayBack's [[CSS]]. Here are the current values for threshold line:
Changed lines 39-42 from:
.ct-area.ct-threshold-above {
    fill: orange !important;
}
to:
-->.ct-area.ct-threshold-above {
--->    fill: orange !important;
-->}
Changed lines 45-47 from:
.SalesForecast .ct-area.ct-threshold-above {
    fill: orange !important;
}
to:
-->.SalesForecast .ct-area.ct-threshold-above {
--->    fill: orange !important;
-->}
July 18, 2018, at 08:53 PM by 192.88.134.15 -
Changed lines 29-34 from:
.threshold-line {
    stroke: orange;
   stroke-dasharray: 15;
   stroke-linecap: round;
   stroke-width: 4px;
}
to:
--> .threshold-line {
--->    stroke: orange;
--->   stroke-dasharray: 15;
--->    stroke-linecap: round;
--->    stroke-width: 4px;
-->
}
July 18, 2018, at 08:52 PM by 192.88.134.15 -
Changed lines 23-47 from:
''Coming soon.''
to:
''Coming soon.''

!!! Threshold colors

You can change the appearance of the threshold by manipulating DayBack's CSS. Here are the current values for threshold line:

.threshold-line {
    stroke: orange;
    stroke-dasharray: 15;
    stroke-linecap: round;
    stroke-width: 4px;
}

The stroke-dasharray is how long the dashed lines are. So smaller number would create more dashes closer together. Keep in mind that the CSS here is being applied to SVG elements so it is a bit different than styling a standard HTML element. As you can see above they are styles that don't exist for regular divs.
Here is the CSS for the chart area which exceeds the threshold:

.ct-area.ct-threshold-above {
    fill: orange !important;
}

Note that you can make calendar-specific CSS by including the name of the calendar as a class. For example, you may have one source were exceeding the threshold is a good thing (like exceeding your sales forecast) and another where exceeding is a bad thing (exceeding would mean you've overextended yourself). So you can create a threshold style for each source. Here's the CSS above set to only apply to a calendar named "Sales Forecast" (use the case-sensitive calendar name with spaces and the "@" sign removed):

.SalesForecast .ct-area.ct-threshold-above {
    fill: orange !important;
}
July 17, 2018, at 11:55 PM by 192.88.134.15 -
Added line 1:
(:Title Calendar Analytics:)
July 17, 2018, at 11:54 PM by 192.88.134.15 -
July 17, 2018, at 11:54 PM by 192.88.134.15 -
Changed line 7 from:
Because knowing how often things happen is a different kind of knowing.''
to:
Because knowing how often things happen is a different kind of knowing.
July 17, 2018, at 11:54 PM by 192.88.134.15 -
Changed line 1 from:
'''''Coming soon!''' Analytics is coming to DayBack Calendar
to:
'''Coming soon!''' Analytics is coming to DayBack Calendar
July 17, 2018, at 11:53 PM by 192.88.134.15 -
Changed line 1 from:
'''''Coming soon!''' Analytics is coming to DayBack Calendar in August of 2018. c
to:
'''''Coming soon!''' Analytics is coming to DayBack Calendar
July 17, 2018, at 11:53 PM by 192.88.134.15 -
Changed lines 3-5 from:
# chart event data across time
compare values across statuses and resources
track progress against goals
to:
-> • chart event data across time
-> • compare values across statuses and resources
-> • track progress against goals
July 17, 2018, at 11:53 PM by 192.88.134.15 -
Changed lines 1-7 from:
'''''Coming soon!''' Analytics is coming to DayBack Calendar in August of 2018. You'll be able to chart event data across time, compare statuses and resources, and track progress against goals. Because knowing how often things happen is a different kind of knowing.''
to:
'''''Coming soon!''' Analytics is coming to DayBack Calendar in August of 2018. c

# chart event data across time
compare values
across statuses and resources
track progress against goals

Because
knowing how often things happen is a different kind of knowing.''
July 17, 2018, at 11:47 PM by 192.88.134.15 -
Changed lines 6-7 from:
!! Chart Data[[#data]]
to:
[[#data]]
!! Chart Data
Changed lines 10-11 from:
!! Number Formatting[[#formattng]]
to:
[[#formattng]]
!! Number Formatting
Changed lines 14-15 from:
!! Threshold: Charting Against Goals[[#threshold]]
to:
[[#threshold]]
!! Threshold: Charting Against Goals
July 17, 2018, at 11:47 PM by 192.88.134.15 -
Changed line 12 from:
!! Threshold: Charting against goals[[#threshold]]
to:
!! Threshold: Charting Against Goals[[#threshold]]
July 17, 2018, at 11:46 PM by 192.88.134.15 -
Changed line 12 from:
 !! Threshold: Charting against goals[[#threshold]]
to:
!! Threshold: Charting against goals[[#threshold]]
July 17, 2018, at 11:46 PM by 192.88.134.15 -
Changed line 9 from:
[[#formattng]] !! Number Formatting
to:
!! Number Formatting[[#formattng]]
Changed line 12 from:
[[#threshold]] !! Threshold: Charting against goals
to:
 !! Threshold: Charting against goals[[#threshold]]
July 17, 2018, at 11:46 PM by 192.88.134.15 -
Changed line 6 from:
[[#data]] !! Chart Data
to:
!! Chart Data[[#data]]
Changed line 13 from:
''Coming soon.''
to:
''Coming soon.''
July 17, 2018, at 11:46 PM by 192.88.134.15 -
Changed lines 1-13 from:
'''''Coming soon!''' Analytics is coming to DayBack Calendar in August of 2018. You'll be able to chart event data across time, compare statuses and resources, and track progress against goals. Because knowing how often things happen is a different kind of knowing.''
to:
'''''Coming soon!''' Analytics is coming to DayBack Calendar in August of 2018. You'll be able to chart event data across time, compare statuses and resources, and track progress against goals. Because knowing how often things happen is a different kind of knowing.''

!! Introduction to Calendar Analytics
''Coming soon.''

[[#data]] !! Chart Data
''Coming soon.''

[[#formattng]] !! Number Formatting
''Coming soon.''

[[#threshold]] !! Threshold: Charting against goals
''Coming soon
.''
July 17, 2018, at 11:43 PM by 192.88.134.15 -
Added line 1:
'''''Coming soon!''' Analytics is coming to DayBack Calendar in August of 2018. You'll be able to chart event data across time, compare statuses and resources, and track progress against goals. Because knowing how often things happen is a different kind of knowing.''
(855) SEEDCODE
[email protected]
Follow us: