回答:要先把日期截出来再用CONVERT转换SELECT CONVERT(DATE, LEFT(YourDateColumn, 8)) AS ConvertedDateFROM YourTableName--------------------------------------------或者拼接后转换SELECT CONVERT(DATETIME, SUBSTRING('20230301150037', 1, 8) + '-' + SUBSTRING('20230301150037', 9, 2) + '-' + SUBSTRING('20230301150037' 11, 2) + ' ' + SUBSTRING('20230301150037', 13, 2) + ':' + SUBSTRING('20230301150037', 15, 2) + ':' + SUBSTRING('20230301150037', 17, 2) ) AS ConvertedDateTime
回答:2024-03-05换成对应的日期参数WITH LS AS (SELECt 1 AS ID , '2024年3月5日' AS RIQI, 1500 AS CHANCH FROM DUAL UNION ALL SELECt 5 AS ID , '2024年3月6日' AS RIQI, 1600 AS CHANCH FROM DUAL UNION ALL SELECt 9 AS ID , '2024年3月7日' AS RIQI, 1700 AS CHANCH FROM DUAL UNION ALL SELECt 13 AS ID , '2024年3月8日' AS RIQI, 1800 AS CHANCH FROM DUAL UNION ALL SELECt 17 AS ID , '2024年3月9日' AS RIQI, 1800 AS CHANCH FROM DUAL )SELECT'日' AS FL,TO_CHAR(TO_DATE( RIQI, 'YYYY"年"MM"月"DD"日"' ),'yyyy-MM-dd') AS RQ ,SUM(CHANCH) AS CHANCHFROMLSWHERE TO_DATE( RIQI, 'YYYY"年"MM"月"DD"日"' ) >= TO_DATE('2024-03-05', 'YYYY-MM-DD' )AND TO_DATE( RIQI, 'YYYY"年"MM"月"DD"日"' ) < TO_DATE('2024-03-05', 'YYYY-MM-DD' )+5GROUP BY TO_DATE( RIQI, 'YYYY"年"MM"月"DD"日"' )UNION ALL SELECT'周' AS FL, TO_CHAR(TO_DATE( RIQI, 'YYYY"年"MM"月"DD"日"' ), 'YYYY-IW') AS week_number, SUM(CHANCH) AS CHANCHFROM LSWHERE TO_CHAR(TO_DATE( RIQI, 'YYYY"年"MM"月"DD"日"' ), 'YYYY-IW') = TO_CHAR(TO_DATE('2024-03-05', 'YYYY-MM-DD' ), 'YYYY-IW')GROUP BY TO_CHAR(TO_DATE( RIQI, 'YYYY"年"MM"月"DD"日"' ), 'YYYY-IW')UNION ALL SELECT'月' AS FL, TO_CHAR(TO_DATE( RIQI, 'YYYY"年"MM"月"DD"日"' ), 'YYYY-MM') AS week_number, SUM(CHANCH) AS CHANCHFROM LSWHERE TO_CHAR(TO_DATE( RIQI, 'YYYY"年"MM"月"DD"日"' ),'YYYY-MM') = SUBSTR('2024-03-05', 1,7 )GROUP BY TO_CHAR(TO_DATE( RIQI, 'YYYY"年"MM"月"DD"日"' ), 'YYYY-MM')
回答:SQL SERVER:SELECT 姓名, 爱好值FROM ( SELECT 姓名, value AS 爱好值, ROW_NUMBER() OVER (PARTITION BY 姓名 ORDER BY (SELECT NULL)) AS rn FROM 你的表名 CROSS APPLY STRING_SPLIT(爱好, ',')) AS subqueryORDER BY 姓名, rn;
回答:你可以设置条件属性-新值,达到显示为空的效果,没办法单独隐藏一个单元格
回答:思路:时间字段+1天,之后左右关联(除数值外都需要添加关联关系) 时间字段=时间字段+1天,关联得到的数据就是昨天的
回答:把公式用到的单元格包一下SUM()试一下
回答:年份放到颜色后,月度只保留月,不要年月显示
回答:In FineBI, the concept of Model View and Associated View exists to fulfill different needs and purposes in data analysis. Let's break down the differences and the reasons for creating relationships between tables twice.Model View in Analysis Subject:Purpose: Model View is specifically designed for data modeling and defining relationships between tables. It's a place where you can create complex data relationships, such as one-to-one, one-to-many, and many-to-many relationships.Relationships: In Model View, you establish relationships between tables to define how they are connected. This is necessary for accurate data retrieval and analysis. For instance, a sales order table might be related to a customer table with a one-to-many relationship, indicating that one customer can have multiple orders.N:N Relationship: Model View supports N:N relationships, where multiple records in one table can be related to multiple records in another table. This is typically achieved through an association table or bridge table that holds the keys of both related tables.Associated View in Public Data:Purpose: Associated View is mainly used for data presentation and quick data analysis. It's a simplified version of a data model, suitable for less complex analysis tasks or for users who don't require the full power of Model View.Relationships: In Associated View, relationships are typically predefined and less flexible than in Model View. This is because Associated View focuses on ease of use and quick analysis, rather than complex data modeling. It typically supports one-to-one and one-to-many relationships but not N:N relationships.N:N Relationship Limitation: The absence of N:N relationships in Associated View is a limitation by design. It reflects the fact that Associated View is not intended for handling complex data relationships. Instead, it's geared towards simpler analysis tasks where N:N relationships are not commonly required.In summary, the reason for creating relationships between tables twice in FineBI is to cater to different use cases and levels of complexity. Model View offers full flexibility and support for complex relationships, while Associated View provides a simplified interface for quick analysis tasks. The absence of N:N relationships in Associated View reflects its focus on simplicity and ease of use.
回答:是因为报表设置了双向扩展吗?参考:Excel双向扩展格导入https://help.fanruan.com/finereport/doc-view-1083.html --------------------------------------------------------------------------------------------------https://help.fanruan.com/finereport/doc-view-4547.html#ca8bcb3bf0a2b719
回答:编辑组件,设置组件控制范围
1085
1085
36
10