Using News Feeds
  • 19 May 2022
  • 4 Minutes to read
  • Contributors
  • Dark
    Light
  • PDF

Using News Feeds

  • Dark
    Light
  • PDF

News Feeds enable a data story to be pushed directly to a user or a channel based on a defined time interval and a data condition.

Note:
The News Feeds feature is only supported for Slack and will be made available for all Infusion Apps in future releases.

Before Creating a News Feed

Before a News Feed can be scheduled, the following steps must be performed to ensure that the Sisense alerting services can successfully interface with Infusion Apps:

Creating the SISENSE_EXTENSE_ALERTS user group

Users added to the SISENSE_EXTENSE_ALERTS user group will be able to create alerts, which enable News Feeds to be created.  

  1. Create a new user group in the Sisense instance where the views exist.
  2. Name the group: SISENSE_EXTENSE_ALERTS.
  3. Add relevant users to the group.
Note:

If users are added to SISENSE_EXTENSE_ALERTS groups after they have already connected Sisense to an Infusion App, they will need to:

  • Log out and reconnect
     or
  • Wait for up to 3 hours to see the changes (due to caching of user profiles within the Infusion App)

Creating Alerts in Sisense

  1. Create a Build Alert to support any views built using Elasticube data.
  2. Create a Pulse Alert to support any views built using Live data.
Note:
It is strongly recommended that you review the alert documentation as there are some limitations and advanced settings.

Adding a Webhook Notification

A webhook defines on which channel users are notified of alerts. For both types of alerts (build or pulse) a webhook notification must be set up.

  1. Open the relevant alerts window:
    • For build alerts, select the tab.
      or
    • For pulse alerts, select Advanced Options > .
  2. Add the following URL to the webhook URL field:
    https://extense.sisense.com/slack/ecbuild?ec=<modelname>&appUserID=<app userID>
    • Replace <modelname> with the URL encrypted name of the data model
    • Replace <app UserID> with the appUserID of the user creating the alert
      • The user must belong to the SISENSE_EXTENSE_ALERTS group and must have one of the following Sisense roles: Designer / Data Designer / Data Admin / Admin

For example:
https://extense.sisense.com/slack/ecbuild?ec=Salesforce+Model&appUserID=abcdefg

Creating a News Feed

News Feeds can be created by any user.

Note:
  • If the steps in Before Creating a News Feed are not completed, users will not see the News Feed button in the Infusion Apps.
  • The News Feed executes under the user profile (data security) of the Author, who should use caution when sharing this with other users or channels if data security is a concern.

To create a News Feed:

  1. Run a query and click Add News Feed.
  2. Enter all the required details and click Save.
  3. Invite the Sisense Analytics Slack bot to the channel.

A News Feed consists of the following components:

Field

Description

Behavior

Headline

Title of the News Feed displayed as the heading.

Can be changed by editing and renaming.

Write-Up

The actual message containing the description of data returned from the query.


Notify Me When

Defines the two conditions in which a notification occurs - Always or Record Count Change from Previous Reading.

Always:

Sends subscribers the current status based on the query. 

Record Count Change from Previous Reading:

Sends subscribers a News Feed story when records are added or removed from the previous result set. 

Add Subscribers


  • You can add channels or individual users to receive the News Feed.
  • When adding channels make sure the bot is invited.
  • There is no need to add yourself. You are automatically added as a subscriber.

Query

The query forms the basis of the News Feed. 

It’s highly recommended to limit the query to a specific time window or operational stage. 

For Example:

  • Won Deals Closed This Quarter
  • Open High Priority Support Tickets
  • Pipeline Opportunities more than 100k
  • Active Leads

Actions

You can make the results of the News Feed actionable by specifying webhooks. 

To create an action select the [+] Add Action button.

Composing Queries

  • You can reference the aggregated value of any view column in the resultset of the query via the <col name> notation.
    For example: <amount>
  • You can reference up to 10 historic values with an offset appended to the column name.
    For example:
    • <col name>-N
    • <amount>-1 (previous value of amount)
  • You can include a mathematical expression using the EXP{mathematical expression} notation. You can also use the JS Math function library.
    For example: 
    • EXP{<amount> - <amount>-1} - Diff between the current amount and the previous value
    • EXP{Math.abs(<id> - <id>-1)}
  • You can also use the IF{condition, text if true, text if false} notation for conditional text.
    For example: IF{<id> > <id>-1, Up, Down}

Consuming News Feeds

A News Feed will be automatically pushed to a user or a channel. Users can interact with a News Feed story to see the underlying data.

Action

Description

Show Data

Displays all records in the story.

Show New Data

Displays all the new records (if any) added from the previous reading of the News Feed.

Troubleshooting News Feeds

I do not see the Add News Feed option.

  • Contact your Sisense admin to make sure you are added to the SISENSE_EXTENSE_ALERTS group.

My News Feed never gets delivered to me or my subscribers.

  • Contact your Sisense admin to ensure that the appropriate Pulse Alerts are defined on the data models your News Feed view is based on (as described in the Setting up News Feeds section.
  • Check your query, if it is invalid or returns no data, the News Feed will not be triggered.

My News Feed gets delivered to me but not to my subscribers.

  • Individual users must install the Slack Bot to receive News Feeds.
  • The Sisense Analytics slack bot must be invited to the Channel for it to push News Feeds to it.

Was this article helpful?