-
Date is changing from M/D/Y to the number week in the year.
I have a grouped and stacked card that is showing revenue for the last 3 weeks. I have the date filter set up to show last 3 weeks filtered by week. However, the data format is showing the number of weeks in the year instead of the week start date that is in the actual data. My column 'Week Start Date' has Sunday dates on…
-
How can I take multiple columns and create new rows based on the data?
We input some data through a form that is very limited in how it organizes the data. It currently looks similar to this (these are the column headers): Date / Manager / State / District / Site / Type of Inspection / 1 - Category of Violation / 1 - Violation / 1 - Plan of Correction / 2 - (same 3 column titles) / 3 - (same)…
-
Previous Year and Year over Year showing 2017 and not a rolling year
I'm building out some financial cards. I pick a date range for previous year and the card looks great. It is showing March - February (based on month). However, when I go to show year over year it defaults to showing January 2017-December 2017 with the variance. I'd like it to show a rolling previous year so next month it…
-
Time Differential
I'm trying to calculate how much time on average an employee spends at a location. We have a clock in and clock out time. Currently, I have the forumula set up as: SEC_TO_TIME(Avg(TIME_TO_SEC(`Time Out`) - TIME_TO_SEC(`Time In`))) This works fine for almost everything I need. However, if an employee clocks in between…
-
Count Summary Number
I'm having an issue adding up multiple columns to present an overall summary in a pie chart. Below is a sample of the columns. These are scored given by managers during visits to their sites. I'm trying to combine the two to create a chart that shows the total number of mastered, in place, not in place, or blank. I thought…