Power BI Field Explained

Available Power Bi fields to create new visualization

Here is an article that we have put together to explain all the tables and their fields which is available in our Power BI Desktop app. You can drag and drop these fields to create a new visualization.

Below are the 37 fields:

accessLogs (Member accessed Log)

ID: Access Logs ID (Unique to row in the table / System generated ID per row)
Date: Member Access Date

Member ID: Members unique identification number


assessmentStageStats
(Assessment Stage Statistics)

ID: Assessment Stage Statistics ID (Unique to row in the table / System generated ID per row)

Idea ID: Unique Idea ID

Stage ID: Assessment Stage unique ID

Assess Completed Count: Count of the completed Assessment stage

Assessed Question Count: Count of Assessment questions

Total Rank: Total rating on the Assessment stage

Average Rank: Average rank on Idea in the Assessment stage


buildteamStageStats
(Build Team Stage Statistics)

ID: Build Team Stage Statistics (Unique to row in the table / System generated ID per row)

Idea ID: Unique Idea ID

Stage ID: Build Team Stage unique ID

Team Members: Number of Team members add/joined/filled

Team Positions: Total Team position to be filled

Completion Percentage: % of position filled


campaignGroups
(Campaign Group)

ID: Campaign Group ID

Community ID: Community Unique ID

Name: Campaign Group Name

Order Number: Campaign Group listing order number


campaigns
(Campaigns)

ID: Campaign ID

Name: Campaign Title

Followers: Number of campaign followers


estimateStageStats
(Estimate Stage Statistics)

ID: Estimate Stage Statistics ID (Unique to row in the table / System generated ID per row)

Idea ID: Unique Idea ID

Stage ID: Estimate Stage unique ID

Completed Count: Count of Estimate stage completion

Average Return: Average returns calculated


functionalStages
(Stage Function)

ID: Functional Stage ID (Unique to row in the table/ System generated ID per row )

Community ID: Community unique ID

Funnel ID: Unique Funnel ID

Key: Stage key

Label: Stage Name

Sequence No: Stage sequence number in listing order

Disabled: True/False value

Stage Function ID: Stage Function Unique ID

Stage Marker ID: Stage Marker Unique ID

Stage Group ID: Stage Group unique ID

Stage Group Label: Stage Group Label (Values are Active / Completed)

Stage Function Label: Stage Function Name

Stage Market Label: Stage Marker Name

Note: Stage Group Label - There are 2 types of stages Active and Completed. Red highlighted stages are Completed.

 

fundsStageStats (Fund Stage Statistics)

ID: Fund Stage Statistics (Unique to row in the table/ System generated ID per row)

Idea ID: Unique Idea ID

Stage ID: Fund Stage unique ID

Target Amount: Target amount set on Fund stage

Balance: Remaining amount on Fund stage

Collection Percentage: Percentage of funds collected

Fund Unit: Unit used for Funds eg: $, Hour, Token, etc


Funnels
(Funnels)

ID: Funnel ID

Community ID: Community Unique ID

Funnel Name: Name of Funnel


groupMemberships
(Group Membership)

ID: Group Memberships ID (Unique to row in the table/ System generated ID per row)

Group ID: Group unique ID

Member ID: Member unique ID


groups
(Groups)

ID: Group Unique ID

Name: Group Name


ideaFieldResponseDetails
(Idea Field Response Details)

ID: Idea Field Response Details ID (Unique to row in the table/ System generated ID per row)

Idea ID: Unique Idea ID

Question ID: Idea custom field question ID

Field Type: Idea Custom field, field type

Question: Idea custom field question

Answer: Idea custom field answer


ideaFieldResponses
(Idea Field Responses)

ID: Idea Field Responses ID (Unique to row in the table/ System generated ID per row)

Community ID: Community unique ID

Idea ID: Idea unique ID

Question ID: Idea custom field question ID

Question Option ID: Idea custom field question option ID

Created At: Idea custom field creation date

Modified At: Idea custom field modified date


ideaFields
(Idea Fields)

ID: Idea Custom Field ID

Community ID: Community unique ID

Required: If this field is required field, value in True/False

Private Field: If this field is a private field, value in True/False

Moderator Only: If this field is a moderator only field, value in True/False

Title: Name of Idea Custom Field

Global: If this field is a Global field, value in True/False

Sequence No: Idea custom field sequence order.

Created At: Idea custom field creation date

Modified At: Idea custom field modified date

Idea Field Options: These are single choice or multi select fields list

Field Type ID: Idea custom field ID

Field Type Label: Field type name


ideaLabels
(Idea Labels)

ID: Idea Labels ID (Unique to row in the table/ System generated ID per row)

Idea ID: Idea unique ID

Label ID: Label unique ID

Label: Label Name


Ideas
(Ideas)

ID: Idea ID

Type: Type 0 is idea (1 is for comments)

Idea Number: Idea Number

Title: Idea Title


ideaStats
(Idea Statistics)

ID: Idea Statistics ID (Unique to row in the table/ System generated ID per row)

Campaign ID: Campaign unique ID

Stage ID: Stage unique ID

Submitter ID: Member ID of the Idea author/submitter

Idea ID: Idea unique ID

Comment Count: Count of comments

Net Vote: Net vote on idea

View Score: View score on idea

Kudo Count: Count of kudos on idea

Smart Score: Smart score on idea

View Count: View count on idea

Follower Count: Count of idea followers

Location ID: Location ID recorded from the member's browser location.


ideaTags
(Idea Tags)

ID: Idea Tags ID (Unique to row in the table/ System generated ID per row)

Idea ID: Idea unique ID

Tag ID: Tag unique ID

Tag: Tag name

Tag Count: Count of tags


ideateStageStats
(Ideate Stage Statistics)

ID: Idea Stage Statistics (Unique to row in the table/ System generated ID per row)

Idea ID: Idea unique ID

Stage ID: Stage unique ID

Up Vote: Number of Up Votes

Down Vote: Number of Down Votes

Net Vote: Number of Net Votes


ideaViewActivities
(Idea View Activities)

Campaign ID: Campaign unique ID

Idea ID: Idea unique ID

Total Members: Number of members who viewed ideas


kudoStats
(Kudo Statistics)

ID: Kudo Statistics ID (Unique to row in the table/ System generated ID per row)

Campaign ID: Campaign unique ID

Member ID: Member unique ID

Given Count: Count of given kudos

Received Count: Count of received kudos

Date: This is a timestamp when the kudo (Received & Given) records are updated

Kudo Type: Regular/Special kudo type

Kudo Type ID: Kudo Type ID (If it is a Regular kudo or Special Kudo)


linkedIdeas
(Linked Ideas)

ID: Linked Ideas ID (Unique to row in the table/ System generated ID per row)

Idea ID: Idea unique ID

Linked Idea ID: Linked Idea ID

Qualifier: Link qualifier (Similar ideas, Related ideas, substantially Equivalent ideas etc)

Member Name: Linked by Member Name

Creation Date: Linked Idea added date

Modification Date: Linked idea modified date


locations
(Location)

ID: Location ID

IP: These are browser specific IP addresses

City: City Name

Region: Region Name

Country: Country Name

Longitude: Longitude

Latitude: Latitude


memberFieldResponseDetails
(Member Field Responses Details)

ID: Member Field Response Details ID (Unique to row in the table/ System generated ID per row)

Member ID: Member Unique ID

Question ID: Member profile question ID

Field Type: Member profile question field type

Question: Member profile question

Answer: Answer to Member profile question


memberFieldResponses
(Member Field Responses)

ID: Member Field Response ID (Unique to row in the table/ System generated ID per row)

Member ID: Member unique ID

Question ID: Member profile question ID

Option ID: Member field answer ID


memberFields
(Member Fields)

ID: Member Fields ID

Community ID: Community Unique ID

Required: If Member Profile Question is Required, value in True/False

Private Field: If Member Profile Question is Private field, value in True/False

Moderator: If Member Profile Question is only visible to Moderator, value in True/False

Question: Member profile Question

Created At: Member profile Question creation date

Modified At: Member profile Question modified date

Profile Question Options: These are single choice or multi select fields list

Field Type ID: Member profile Question field ID

Field Type Label: Member profile Question field name


members
(Members)

ID: Member ID

Name: Member Name

Email: Member Email address

Username: Member @mention name

Last Successful Login: Last successful login date


memberScores
(Member Scores)

ID: Member Scores ID (Unique to row in the table/ System generated ID per row)

Community ID: Community unique ID

Member ID: Member unique ID

Points: Member Points

Campaign ID: Campaign unique ID


memberStats
(Member Statistics)

ID: Member Statistics ID (Unique to row in the table/ System generated ID per row)

Campaign ID: Campaign unique ID

Member ID: Member unique ID

Idea Count: Count of Ideas

Comment Count: Count of Comments

Vote Count: Count of Votes

Points: Member Points

Kudos: Kudos received by the member


monthlyEngagedActionStats
(Monthly Engaged Action Statistics)

ID: Monthly Engaged Action Statistics (Unique to row in the table/ System generated ID per row)

Campaign ID: Campaign unique ID

Idea ID: Idea unique ID

Member ID: Member unique ID

Year: Member Engagement Year on Idea

Month: Member Engagement Month on Idea

Idea Count: Count of Ideas by member

Vote Count: Count of Votes by member

Comment Count: Count of comments by member

Idea Stage Change Count: Count of Idea stage change

Tag Count: Count of tag

Share Count: Count of Idea share

Link Count: Count of idea linked

Label Count: Count of label

Kudo Count: Count of kudos

Total Activity Count: Count of Activity


monthlyMemberScores
(Monthly Member Scores)

ID: Monthly Member Scores (Unique to row in the table/ System generated ID per row)

Campaign ID: Campaign unique ID

Member ID: Member unique ID

Points: Member Points earned

Monthly Number: Month number

Year: Year


refineStageStats
(Refine Stage Statistics)

ID: Refine Stage Statistics ID (Unique to row in the table/ System generated ID per row)

Idea ID: Idea unique ID

Stage ID: Stage unique ID

Question Count: Refine Question count

Answer Count: Refine answer count

Completed: All completed refinement questions with answers


reviewscaleStageStats:
(Reviewscale Stage Statistics)

ID: Reviewscale Stage Statistics ID (Unique to row in the table/ System generated ID per row)

Idea ID: Unique Idea ID

Stage ID: Reviewscale Stage unique ID

Completed Count: Count of Reviewscale stage completed

Value Score: Value score received on Reviewscale

Cost Score: Cost score received on Reviewscale

Impact Ratio: Impact Ration received on Reviewscale


stageChangeHistories
(Stage Change Histories)

ID: Stage Change Histories ID (Unique to row in the table/ System generated ID per row)

Campaign ID: Campaign unique ID

Idea ID: Idea unique ID

Current Stage ID: Stage unique ID (Idea in current stage)

Duration: Duration of idea in stage

Stage Change Date: Stage change date


stageFields
(Stage Fields)

ID: Stage FIeld ID

Stage ID: Stage unique ID

Title: Stage field name

Creating Date: Stage field creation date

Field Type ID: Field type unique ID

Field Type Label: Field type name


votes
(Votes)

ID: Votes ID

Campaign ID: Campaign unique ID

Contribution ID: Contribution ID recorded in case of vote on comment, it will consider Comment ID and in case of vote on Idea, it will consider Idea ID)

Member ID: Member unique ID

Vote: Vote registered value 1 or -1

Type Label: The value "idea" is for votes on Ideas and the value "comment" is for votes on comments

Type ID: Vote type value 1 or 0


weeklyEngagedActionStats
(Weekly Engaged Action Statistics)

ID: Weekly Engaged Action Statistics ID (Unique to row in the table/ System generated ID per row)

Campaign ID: Campaign unique ID

Idea ID: Idea unique ID

Member ID: Member unique ID

Year: Year

Week: Week number

Idea Count: Count of Ideas

Vote Count: Count of Votes

Comment Count: Count of Comments

Idea Stage Change Count: Count of idea stage change

Tag Count: Count of tags

Share Count: Count of shares

Link Count: Count of Link ideas

Label Count: Count of label names

Kudo Count: Count of kudos

Total Activity Count: Count of total activity