Inforiver
FormulaPricingProductAll Products
Reporting & Writeback Matrix Docs
Reporting & Writeback Matrix Docs
  • Introduction to Inforiver
    • Why Inforiver
    • Get Started
      • Installing Inforiver for yourself
      • Installing from AppSource
      • Installing Inforiver for your organization (Org visual)
      • Inforiver Writeback Matrix pre-requisites
        • Whitelist Inforiver IPs
        • Admin consent for Inforiver's Entra ID
          • Basic consent
          • Full admin consent
      • Inforiver Customer Portal
        • Billing Admin
          • Update Profile
          • Update Subscriptions
        • License Admin
      • Licensing
        • License renewal
      • Registering Inforiver on Azure AD (Entra ID)
  • Working with Inforiver
    • 1. Build your first Inforiver report
    • 2. Displaying information
      • Report interface
      • Layout options
      • Templates
      • Basic formatting
        • Number formatting
        • Cell, header & value formatting
        • Totals & subtotals
        • Insert blank rows
      • Basic inline charts
    • 3. Basic interactions
      • Explore & filter data
        • Search & Filter
        • Explorer
        • Top N + others
      • Sort & reorder data
      • Show/hide values
      • Manage column widths
      • Manage hierarchies
      • Create visual hierarchies
      • Pin rows & columns
      • Blend measures
      • Dynamic measure headers
      • Context menus
        • Column gripper
        • Row gripper
      • Actions
        • Rails
        • Toolbar options
        • Keyboard shortcuts
        • Reset
    • 4. Adding business logic and formulae
      • Insert calculated rows
        • Template rows
      • Insert calculated columns
      • Insert manual input rows
      • Insert manual input columns
        • Number
        • Dropdown
          • Dropdown options from semantic models
          • Lookup visuals for dropdowns
        • Text, checkbox & date
        • Writeback Matrix features
        • Importing data
      • Invert sign
      • Editing cells
      • Quick formula
      • Visual column inside visual measures
      • Manage inserted rows
      • Manage inserted measures & columns
      • Pivot data
      • Insert image URLs
    • 6. Working with charts
      • Sparkline charts
      • Stacked charts
      • Bullet charts and clustered bar charts
      • Waterfall charts
      • Bar and pin charts
      • Change/deviation charts
    • 5. Conditional formatting
      • One-click options
      • Create rule
        • Rules (If conditions)
        • Color scale & data bars
        • Classification
        • Ranking
      • Manage rules
    • 7. Planning, budgeting & forecasting
      • What-if analysis & simulations
      • Goal Seek
      • Scenarios (Writeback Matrix only)
      • Budgeting & allocations
      • Forecasting
        • Date rollover and extending forecasts
        • Editing forecasts and reforecasting
        • Autoclose forecasts
        • Distribute deficit
        • Row level forecast
        • User Access Control
        • Common Scenarios
          • Forecast using a Blank Template
          • Forecast using Existing Data
          • Adding Forecasts for Periods unavailable in the model
          • Creating daily and weekly forecasts
      • Set version
    • 8. Paginated reporting
      • Pagination
      • Header & footer
        • Text
        • Images
        • Charts
        • KPI cards
      • Report layouts (Report+)
      • Display and themes
    • 9. Commenting and collaboration
      • Notes
      • Comments
        • Data-level comments
        • Assign & track tasks
        • Track changes
        • Report-level comments
        • Comment settings
    • 10. Exporting reports
      • Export to PDF & Excel
        • Excel export - operational boundaries
      • Ad hoc emails
      • Snapshot (Writeback Matrix only)
        • Comparing snapshots
    • 11. Scheduling reports
      • Create new subscription
        • Select a report
        • Set subscription frequency
        • Select destination(s)
          • Email
          • OneDrive
          • Microsoft Teams
          • SharePoint
        • Review & save subscription
      • Manage your subscriptions
      • Administration
    • 12. Data writeback
      • Settings
        • General Settings
        • Data Settings
        • Destination Settings
        • Writeback security settings
        • Writeback time-out & batch size settings
        • Advanced Settings
      • Destinations
        • Azure SQL (Managed DB)
        • Azure SQL
        • Microsoft SQL Server
        • Synapse Dedicated SQL Pool
        • Azure Data Lake Storage
        • Databricks
        • Snowflake
          • Setting up Snowflake OAuth
        • Amazon Redshift
        • BigQuery
        • SingleStore
        • SAP HANA
        • Oracle
        • PostgreSQL
        • MySQL
        • OneDrive
        • SharePoint
        • Dataverse
        • Fabric Warehouse
        • Fabric lakehouse
        • Fabric SQL
        • URL as destination
      • Logs
      • Reading mode
    • 13. Context awareness
    • 14. Manage aggregation
      • Row aggregation
      • Column aggregation
    • 15. Managing Inforiver Writeback Matrix visuals
      • Inforiver deployments in Power BI pipeline setup
      • Duplicating Writeback Matrix Visuals - Best Practices
      • Recommended practices while working with Power BI desktop
    • 16. Approval workflows
    • 17. Collaborative adjustment workflows
    • 18. Variables
      • Variable types
        • Number
        • Select
        • Text
        • Date
        • Date range
        • Boolean
        • Button
      • Variable bookmarks
  • Admin Console
    • Manage Profile
    • User management
      • User Roles and Permissions
      • Create custom roles and policies
    • Settings
      • General
      • Generate builds - on prem
      • Forecast
      • Holidays
      • API token
      • Writeback
      • Managed DB
      • Assets
    • Onboarding actions
    • Writeback
  • Display settings
    • General settings
    • Hierarchy settings
    • Number settings
    • Miscellaneous settings
    • On-load scripting
  • Formula syntax
    • Conditional statements
      • IF
      • IFNA
      • SWITCH
      • FILTERIF
    • Logical functions
      • AND
      • IN
      • ISBLANK
      • ISEMPTY
      • ISNUMBER
      • NOT
      • OR
      • XOR
    • Math functions
      • ABS
      • AVERAGE
      • AVERAGEEXNEG
      • AVERAGEEXZERO
      • AVERAGEEXZERONEG
      • AVERAGEIF
      • CEILING
      • COUNT
      • COUNTIF
      • DIVIDE
      • EVEN
      • EXP
      • FLOOR
      • INDEXOF
      • LOG
      • ODD
      • MAX
      • MIN
      • NORMDIST
      • NORMSDIST
      • NORMINV
      • NORMSINV
      • PCT
      • POWER
      • RAND
      • RANDBETWEEN
      • ROUND
      • ROUNDDOWN
      • ROUNDUP
      • MROUND
      • SORT
      • SQRT
      • SUM
      • PMT
    • Text formatting functions
      • CONCATENATE
      • HYPERLINK
      • LEFT
      • LOWER
      • MID
      • PROPER
      • REPLACE
      • REPT
      • RIGHT
      • TEXT
      • TRIM
      • UPPER
      • VALUE
    • Date functions
      • DATEADD
      • DATEDIFF
      • DAY
      • DATE
      • DATE.SET
      • DATE.FORMAT
      • SOWEEK
      • SOMONTH
      • SOQTR
      • SOYEAR
      • EOWEEK
      • EOMONTH
      • EOQTR
      • EOYEAR
      • NETWORKDAYS
      • ADDDAYS
      • ADDWEEKS
      • ADDMONTHS
      • ADDQTRS
      • ADDYEARS
      • FROMEXCELDATE
      • MONTH
      • NOW
      • PERIOD_RANGE
      • TODAY
      • TOEXCELDATE
      • YEAR
    • Time intelligence functions
      • AGGREGATE
      • FILTER
      • COLUMN_PERIOD
      • LASTNDAY
      • LASTNMONTH
      • LASTNQTR
      • LASTNYEAR
      • MONTHPERIOD
      • MOVINGAVERAGE
      • MOVINGSUM
      • MTD
      • NEXTNDAY
      • NEXTNMONTH
      • NEXTNQTR
      • NEXTNYEAR
      • QTD
      • QTRPERIOD
      • SHIFT
      • TOTALYTD
      • TOTALQTD
      • TOTALMTD
      • VALUEAT
      • YEARPERIOD
      • YTD
    • Other operators
    • Identifiers
      • CLOSEDPERIOD
      • COLUMN.DATE
      • COLUMN.PARENT
      • COLUMNS
      • CURRENT_PERIOD
      • DESCENDANTS
      • FORECAST.CLOSED_END
      • FORECAST.CLOSED_START
      • FORECAST.OPEN_END
      • FORECAST.OPEN_START
      • GROUP INDEX
      • HAS
      • HAS_ALL
      • HAS_SOME
      • LEAVES
      • LEVEL
      • LOGGEDIN_EMAIL
      • LOGGEDIN_NAME
      • MATCH
      • MAXDATE
      • MEMBERS
      • MINDATE
      • RELATIVE
      • RELATIVE_COLUMN
      • ROW.PARENT
      • ROW.LABEL
    • Scripting functions
      • DISPLAYTOAST
      • EXPORT
      • LAYOUT
      • SETCFRULE
      • SETFILTER
      • SETFILTERBYINDEX
      • SETVISIBILITY
      • SHOWBETWEENPERIOD
      • SHOWCLOSEDFORECAST
      • TOPN
      • DISPLAY SETTINGS
        • SETBLANKLABEL
        • SETSUPPRESSZEROS
        • SETRAGGEDHIERARCHY
        • SEPARATOR
        • SETCOMBINECOLUMNHEADER
        • SEMANTICFORMAT
        • SHOWNULLAS
        • SHOWZEROAS
        • SINGLECHILD
    • Statistical Functions
      • RANK
      • RANKEQ
      • RANKAVG
    • Miscellaneous functions
      • FETCH
      • LOOKUP
    • Measure/Column selection functions
      • GETCOLBETWEENPERIODS
      • GETMEASURE
  • Advanced topics
    • Audit log
    • Backup & restore report config
    • Enterprise themes
    • PowerPoint integration
    • Drill down and roll up in performance mode
  • Infobridge
    • 1. Create bridge
    • 2. Add source to bridge
    • 3. Bridge Interface
    • 4. Manage queries
      • Query transformations
        • Append
        • Join
        • Duplicate
    • 4. Manage sources
    • 5. Insert rows from bridge
    • 6. Insert measure from bridge
    • 7. Manage Integration of visuals
    • 8. Manage Bridges
    • 9. Data transformations
      • Pivot table
      • Group by
      • Add Column
      • Pivot column
      • Rename column
      • Find and Replace
      • Remove measure
      • Filter rows
      • Sort
      • Text functions
      • Unnest
      • Round
      • Extract Comments
      • Import and export
    • 10. Integrating forecasts
    • 11. Collaborative adjustments
  • Accessibility shortcut keys
  • Inforiver Reporting Matrix FAQs
  • Inforiver Writeback Matrix FAQs
  • Leveraging Power BI bookmarks
  • Performance Optimization Options in Inforiver
  • Video tutorials
  • Resources
  • Release Notes
    • Inforiver Writeback Matrix
      • Inforiver Writeback Matrix May 2025 - v4.5 - Audit redesign, Writeback optimizations, and more
      • Inforiver Writeback Matrix May 2025 - v4.4.5
      • Inforiver Writeback Matrix May 2025 - v4.4.3
      • Inforiver Writeback Matrix April 2025 - v4.4.2
      • Inforiver Writeback Matrix April 2025 - v4.4.
      • Inforiver Writeback Matrix March 2025 - v4.3 - Time series formulae
      • Inforiver Writeback Matrix - March 2025 - v4.2
      • Inforiver Writeback Matrix March 2025 - v4.1
      • Inforiver Writeback Matrix Feb 2025 - v4.0 - User permissions, High-performance mode, Input rules
      • Inforiver Writeback Matrix January 2025 - v3.9 - Fabric support, upgraded variables interface
      • Inforiver Writeback Matrix December 2024- v3.8 - Improved Scheduler Performance & Other Enhancements
      • Inforiver Writeback Matrix December 2024 - v3.7 - Merge rows, new rounding functions & More
      • Inforiver Writeback Matrix November 2024 - v3.6.2 - Import from Google Sheets & More
      • Inforiver Writeback Matrix October 2024 - v3.6 - Approval Workflows & Other Enhancements
      • Inforiver Writeback Matrix October 2024 - v3.5 - Lookup visuals & more
    • Inforiver Reporting Matrix
      • Inforiver Reporting Matrix March 2025 - V3.3.5
      • Inforiver Reporting Matrix March 2025 - V3.3.3 -New formatting and export options
      • Inforiver Reporting Matrix Nov 2024 - v3.3 - Variables
Powered by GitBook
On this page
  • 1. Add comments
  • 2. Mention other users
  • 3. Reply to comments
  • 4. Comments column
  • 5. Roll-up comments
  • 6. Email notifications

Was this helpful?

  1. Working with Inforiver
  2. 9. Commenting and collaboration
  3. Comments

Data-level comments

PreviousCommentsNextAssign & track tasks

Last updated 1 year ago

Was this helpful?

Data-level commentary is very common in real-life scenarios. In this section, we'll see how you can add data-level comments, mention other users, reply to comments and receive instant notifications on replies/mentions.

While all comments can be written back to databases or shared drives, only the comment column can be exported to an Excel/PDF file.

1. Add comments

You can add formatted data-level comments which are saved securely to the database along with details such as author and time stamp.

a) Select a cell/row/column. The 'Add a comment' icon gets enabled. Click on the icon.

b) The comments editor opens up. Enter a comment as shown below.

c) Let's apply some formatting to 'margins'. Select the text, click on the 'Font color' icon and select a color from the color picker.

d) The font color gets updated. Let us now add a hyperlink to 'document'. Select the text and click on the 'Link' icon.

e) Enter an URL as shown and click 'Apply'.

f) The hyperlink gets added. Click 'Post'.

g) The comment gets added. You can see a blue indicator on the top right corner of the cell. There are a number of options in the comment box which we'll be covering in the other sections.

h) You can edit/delete a comment added by you as shown. Report authors/editors can edit/delete comments added by other users as well.

i) To hide comments temporarily, turn on the 'Hide all comments' toggle.

j) All the comments are hidden.

k) Certain comments can be locked to prevent editing and replies. Click on the 'Three dots' icon and click on 'Lock thread' highlighted below.

l) The comment thread gets greyed out. To unlock the thread, click on the 'Unlock' icon.

m) To delete all comments, in the 'Comments' dropdown, select 'Settings'. In the side panel, in the 'General' tab, click 'Delete all comments'.

2. Mention other users

You can use @ symbol to tag other stakeholders and draw their attention​.

a) Click on a cell and 'Add a comment'. Type @ in the comment editor. You will see a list of the users in the workspace.

b) Select the desired user, add the comment and click 'Post'.

c) The comment gets posted successfully.

3. Reply to comments

Users can reply to comments posted by others and have interactive conversations.​​

a) Click on 'Reply'.

b) Enter the reply in the comments editor and click 'Reply'.

c) The comment reply gets added as a thread.

4. Comments column

You can add a dedicated comments column to capture row-level comments.

a) In the 'Comments' dropdown, turn the 'Comments column' toggle on.

b) The comments column gets added.

c) Click on any cell in the comments column. The comment editor opens. Enter a comment and click 'Post'.

d) The comment gets added as shown in the below image.

e) To reply to a comment in the comments column, simply click on the comment and 'Reply'.

f) The number of replies is also shown along with the comment.

g) To hide the comments column, turn off the toggle.

5. Roll-up comments

In reports with large number of hierarchies, you can see comments rolled up at the subtotal and grand total level even if the hierarchies are collapsed. This enables executives to see collapsed and summarized reports but still see exception comments rolled up at the parent levels.

In the below image, comments are added at the product category and sub category levels which are consolidated and shown at the region level.

Roll-up comments work in the Comments column too. In the image below, comments are added at the product category, sub category and sub-region levels which are consolidated and shown at the region level.

To turn on roll-up comments, turn on the 'Rollup indicator' toggle in the 'Comments' dropdown.

6. Email notifications

The ‘@user’ mention in the comment automatically sends an email notification to the user, with a link to the report so that the user can respond to this comment and/or update the report. Replies to the comments are also notified to the user instantly.

a) Email notifications on comment replies can be turned off. In the dropdown highlighted, click on 'Profile settings'. In the side panel, turn off the toggle.

b) Email notifications for new replies or mentions can be turned off. In the 'Settings' panel, uncheck the highlighted checkbox.

In the next section, we'll see how you can assign & track tasks.

Adding a data-level comment
Comment editor
Changing text color
Adding hyperlink
Adding hyperlink
Posting a comment
Comment gets posted
Edit/delete a comment
Hide all comments
All comments get hidden
Comments can be locked
Locked comments can be unlocked
Delete all comments
Using @mentions
Mention other users
Comment posted successfully
Reply to comments
Reply added
Threaded comments
Turn on comments column
Comments column gets added
Entering a comment in the comments column
Comment gets added
Comments column supports replies
Comment along with number of replies
Hide comments column
Roll-up comments in parent level cells
Roll-up comments in Comments Column
Roll-up indicator
Email notification on mentioning user
Turn off email notifications on comment replies
Turn off email notifications for new reply and mention