How can I have multiple Pivot Table and Charts from the same source and use separate grouping and filtering for each one? I have two charts: one I want to show Weekly data and the other should show Monthly data. Whenever I change one, it updates the other. ...
let say i have one table, which have data like: name status bob single bob single jane null tina null shane married i want if status "single or data null" it means single. so if data empty script can read it as single and can count together. so i can show result like: Single Married 3 ...
I want do like this, but for another case that not function. This is my example table: Date Model No Line Range Lot Status 2010-08-01 KD-G435 1 01 1-100 013A accept 2010-08-01 KD-G435 2 01 1-100 013A accept 2010-08-01 KW-TC800 ...
I have a spreadsheet corresponding to entries of a user, their estimation, and the actual value (say, of hours for a particular project), which we can represent in CSV like: User,Estimate,Actual "User 1",5,5 "User 1",7,7 "User 2",3,3 "User 2",9,8 "User 3",6,7 "User 3",8,7 I'm trying to build a report on these users, to quickly see whi...
I have two tables, one parts_raised and another is parts_detail. parts_raised: SN(int),Job_Number(int),Category(varchar),Part_code(int),technician(varchar),Time (timestamp), Parts_detail: Part_code(int),Value(int),Descriptions(text), part_code is same in both table. How can i write query for achieving total count of jobs,and ...
Hail to the fellow programmers and query writers, I have this beautiful query SELECT ID, [1] AS coL1, [15] AS coL2, [2] AS coL3, [16] AS coL4, [12] AS coL5 FROM MY_TABLE PIVOT (sum(INT_VALUE) FOR FUND_CODE IN ([1],[2],[15],[16],[12])) AS p --GROUP BY ID, [1] , [15] , [2] , [16] , [12] ORDER BY ID ASC That returns me data like this:...
I'm trying to turn the following ResultSet Meetings Covers Date TypeName 1 3 2010-10-14 Breakfast 1 1 2010-10-14 LunchCooked 2 4 2010-10-15 Breakfast 1 3 2010-10-18 Breakfast 1 3 2010-10-19 Breakfast 1 1 2010-10-19 LunchSandwich 1 ...
I have the following code in a T-Sql query, I am getting the following error message and I am not really sure what is causing the error. I am writing the Pivot statement to be dynamic b/c I do not know the columns that will be returned. Error Message: Msg 8156, Level 16, State 1, Line 9 The column 'Title - Endorsement Fee / END8' was s...
Hi, I'm trying to use the Access Partition function to generate the bins used to generate a histogram chart to show the frequency distribution of my % utilization data set. However, the Partition function only shows the category bin ranges (e.g. 0:9, 10:19 etc) only for the categories that have a count. I would like it to show up to 1...
I have the following data returned buy a simple SQL query. The Number of sites could change, but X,Y,Z are fixed (they are different types of accidents, and the data stored represents the number of occurances) | Site | X | Y | Z | -------------------- A 1 2 3 B 4 5 6 C 7 8 9 I need to get it to the ...