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
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
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