Comments (4)
Version? DDL of the table?
from metabase.
from metabase.
Can reproduce with something as simple as:
Postgres 15.1
Metabase 1.49.14
CREATE TABLE li_daily_tech_report (
id SERIAL,
date date,
tech text,
inspections_completed integer,
appts_completed integer,
meters_total integer,
outside_meters integer,
inside_meters integer,
door_hangers integer,
wait_time integer,
dispatches integer,
poe_seals integer
)
INSERT INTO li_daily_tech_report (date, tech, inspections_completed, appts_completed, meters_total, outside_meters, inside_meters, door_hangers, wait_time, dispatches, poe_seals)
VALUES
(CURRENT_DATE - 1, 'Tech A', 5, 2, 20, 10, 10, 1, 30, 5, 0),
(CURRENT_DATE - 2, 'Tech B', 3, 1, 15, 5, 10, 0, 45, 3, 1),
(CURRENT_DATE - 3, 'Tech C', 7, 3, 25, 15, 10, 2, 60, 6, 2),
(CURRENT_DATE - 4, 'Tech D', 2, 0, 10, 4, 6, 0, 20, 2, 0),
(CURRENT_DATE - 5, 'Tech E', 8, 4, 30, 20, 10, 3, 90, 7, 3),
(CURRENT_DATE - 6, 'Tech F', 4, 1, 18, 9, 9, 1, 40, 4, 1),
(CURRENT_DATE - 7, 'Tech G', 6, 2, 22, 11, 11, 2, 70, 5, 2),
(CURRENT_DATE - 8, 'Tech H', 1, 0, 8, 3, 5, 0, 10, 1, 0),
(CURRENT_DATE - 9, 'Tech I', 9, 5, 35, 17, 18, 4, 100, 8, 4),
(CURRENT_DATE - 10, 'Tech J', 5, 2, 20, 10, 10, 1, 30, 5, 0),
(CURRENT_DATE - 11, 'Tech K', 3, 1, 15, 5, 10, 0, 45, 3, 1),
(CURRENT_DATE - 12, 'Tech L', 7, 3, 25, 15, 10, 2, 60, 6, 2),
(CURRENT_DATE - 13, 'Tech M', 2, 0, 10, 4, 6, 0, 20, 2, 0),
(CURRENT_DATE - 14, 'Tech N', 8, 4, 30, 20, 10, 3, 90, 7, 3),
(CURRENT_DATE - 15, 'Tech O', 4, 1, 18, 9, 9, 1, 40, 4, 1),
(CURRENT_DATE - 16, 'Tech P', 6, 2, 22, 11, 11, 2, 70, 5, 2),
(CURRENT_DATE - 17, 'Tech Q', 1, 0, 8, 3, 5, 0, 10, 1, 0),
(CURRENT_DATE - 18, 'Tech R', 9, 5, 35, 17, 18, 4, 100, 8, 4),
(CURRENT_DATE - 19, 'Tech S', 5, 2, 20, 10, 10, 1, 30, 5, 0),
(CURRENT_DATE - 20, 'Tech T', 3, 1, 15, 5, 10, 0, 45, 3, 1);
You will see something similar to the following in the logs:
analyze.classify :: Based on classification, updating these values of Field 3887 ''inspections_completed'': {:has_field_values :auto-list, :semantic_type :type/Category}
from metabase.
dupe of #33888
from metabase.
Related Issues (20)
- Set all namespaces to INFO and allow the admin to change the log level at runtime
- Cannot search within tables in "Pick your starting data" modal
- `Lib.isNumber` returns `false` for aggregation-based columns after join is removed
- Add a new SDK card setting
- [Epic] Simple Metrics Overview Page
- Wrong entity names and headings when X-raying Custom Expressions
- X-raying a Date field in an X-ray is broken
- Click to sum/average
- Using Azure Workload Identities to Rotate Database Credentials
- JDBC connection setup on startup, but fail to run SQL with overflow call to c3p0 checkoutResource HOT 2
- [Epic] Multi-dimensional / Sunburst Pie chart
- Visual regression tests for PDF dashboard export in embedding context
- Empty section title rendered in dashboard filter column mapping HOT 1
- FE - e2e - Cover dashboard drills with tests
- [Epic] Serialization fixes
- Proper E2E round-trip test (with on-disk YAMLs)
- extract-and-log-one should become extract-one
- [serdes] Transfer Collection to use spec
- move storybook to optional dependencies
- TypeError: onClick is not a function
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from metabase.