Questions tagged [customcolumn]
54 questions
1
vote
1 answer
Xlsxwriter Custom Column Formatting issue
I am sure there is a more efficient way to write the code but the issue i am having is in my dataframe 2 of my columns (dtypes are objects that represent dates in format yyyy-mm-dd). When I use xlsxWriter everything else is coming out exactly as i…
jas
- 49
- 4
1
vote
1 answer
Angular Material Table with Sticky and Custom Width Column
I need a table that can be customized by the sticky and width of a column.
By now I found something if I put a custom class that has a width: 150px on th and td, the sticky attribute when I scroll horizontally doesn't know to calculate the…
BiTza Ioan
- 29
- 1
- 5
1
vote
0 answers
Wordpress add custom boolean value column
How to add a custom column in wordpress for all image attachments, i need to set a boolean value for all existing image uploads.
Something i tried to write add_post_meta() function to be written in functions.php
Akshay Patwari
- 11
- 3
1
vote
2 answers
ReadOnly Property in Custom Column Types in Sharepoint
I'm creating a custom column in a feature for Sharepoint. It is essentially this:
Ray Booysen
- 28,894
- 13
- 84
- 111
1
vote
1 answer
Dax Calculation with logic in power bi data analytics
Need help in Data Analytics Calculations.
Currently, I am getting historical data for consumption as follows:
on above data, I am adding custom columns for calculating exact consumption(gallons) in no. of days. like:
Now, I have to plot month wise…
Priyanka Mane
- 517
- 2
- 9
- 23
1
vote
1 answer
SQL - Make a custom table with month based columns and year based rows
I am trying to make an awesome custom table which counts the amount of rows and organises them so that if there are three rows with a date in January 2013, four in March 2014 and five in October 2014 the table would show up as:
Jan Feb Mar Apr…
user1877408
- 137
- 1
- 11
0
votes
2 answers
Adding shared fields to a SharePoint calendar to sync with an Outlook calendar
I have set up MOSS 2007 Enterprise with a calendar that I have added custom columns to. We have synced this calendar in Outlook, and it works great creating and editing events from either SharePoint or Outlook.
The issue is that I want to be able…
Jeremy Sullivan
- 995
- 1
- 14
- 25
0
votes
1 answer
Power Query: Identifying duplicate unique values and retaining the latest entry based on date and time
In a table visual, the requirement is:
Unique ID
Date
Total
1002
5/15/23 6:34 AM
9.8
1007
5/15/23 6:28 AM
6.7
1003
5/15/23 4:01 AM
3.2
1009
5/15/23 3:16 AM
4.4
1009
5/15/23 2:39 AM
4.5
1001
5/15/23 12:59 AM
9.9
1005
5/15/23 12:41…
datadane
- 3
- 2
0
votes
2 answers
Replace column data of one data table with column data from another table based on a condition
I have 2 data tables connected in my powerbi workbook.
My objective is to replace a column data with a column data from another table in powerbi.
Below is the sample example.
Table 1:
Customer
Action…
0
votes
0 answers
Return Ask Price for Another Symbol in the Options Chain Column
Is there any reason the following ThinkScript code ends up returning NaN in the options chain custom column I'm working on?
As far as I can tell, this should just be giving me the current GOOG ask price in the column row. If I remember correctly,…
user21254518
- 1
- 1
0
votes
2 answers
Max Group Filter Power Query
I'm trying to use the following code to get a new added column with information about a max value from a given field.
But what I would want is to have the possiblity to group a table where I filter it by a condition where the Custom column value…
chaosKnight
- 21
- 7
0
votes
0 answers
Max Per Group Power Query
I'm using this code for creating a custom column!
max per group
let
Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
#"Changed Type" = Table.TransformColumnTypes(
Source,
{{"Column1", type text}, {"Column2",…
chaosKnight
- 21
- 7
0
votes
1 answer
Laravel Model's custom column name
I'm developing a new software that will eventually replace an old one, still in production.
The new software needs to access old's DB for specific models that will (in the future, not at this stage) will be replaced to local ones, but I'm developing…
0
votes
1 answer
Saved value is not displayed in custom datagridview column
So I've made a custom DataGridView-Column which is showing a DropDown for multiselecting different values and displaying them with a separator.
Picture of Cell with dropdown and selectedvalues
It's working fine so far, but the saved value is not…
Stevy G.
- 16
- 4
0
votes
1 answer
Please help me resolve my Excel Power Query / Custom Column Error
I'm attempting to create an aging buckets analysis through the use of Excel Power Query.
Thus far I've created a column calculating the age of each record. The step I'm currently on is to categorize each record into age buckets such "31-60 days…
Lwazi Mace
- 15
- 4