cancel
Showing results for 
Search instead for 
Did you mean: 
intapiuser
Community Team Member
Community Team Member
Looking to create a radial bar chart with plot.ly? Look no further! Radial bar charts are a great way to show progress to a goal. The following python script easily plugs in with your SQL output, simply paste this into your Python 3.6 code box provided with the Python/R Integration, ensuring that your SQL output has 1 row with 2 columns columns:
  1. current: the currently  attained value
  2. goal: the goal value
 
(optionally apply dollar formatting by naming the columns  current_$ and goal_$)
 
Python 3.6 Script
# SISENSE FOR CLOUD DATA TEAMS PROGRESS TO GOAL TEMPLATE
# SQL output should have 2 columns:
#    1) current: the currently attained value
#    2) goal: the goal value
#      optionally apply dollar formatting by naming the columns current_$ and goal_$

import pandas as pd
import plotly.plotly as py
import plotly.graph_objs as go
import math
import sys

community_post = ''
dummy_df = pd.DataFrame()
dummy_df = pd.DataFrame()
dummy_df['current_$'] = [1000]
dummy_df['goal_$'] = [2000]

# GENERIC HELPER FUNCTIONS
def get_formatter(column):
  if '$' in column:
    return '$'
  elif '%' in column:
    return '%'
  else:
    return None

# formats a number based on its formatter ($ or %)
def format(num, formatter = None):
  if formatter is None:
    return abbrev(num)
  elif formatter == '$':
    return dollars(num)
  elif formatter == '%':
    return percent(num)

# formats a number to dollars
def dollars(num):
  num = float('{:.3g}'.format(float(num)))
  magnitude = 0
  while abs(num) >= 1000:
    magnitude += 1
    num /= 1000.0
  return '${}{}'.format('{:f}'.format(num).rstrip('0').rstrip('.'), ['', 'K', 'M', 'B', 'T'][magnitude])

# makes a number human readable e.g. 100000 -> 100K
def abbrev(num):
  num = float('{:.3g}'.format(float(num)))
  magnitude = 0
  while abs(num) >= 1000:
    magnitude += 1
    num /= 1000.0
  return '{}{}'.format('{:f}'.format(num).rstrip('0').rstrip('.'), ['', 'K', 'M', 'B', 'T'][magnitude])

# formats a number to a percent
def percent(pct):
  return str(int(round(pct*100))) + '%'

# adds flair to a percent if it's above 100
def pretty_percent(pct):
  fmt_pct = percent(pct)
#   if fmt_pct == '100%':
#     fmt_pct = '💯'
  if pct >= 1:
    fmt_pct = f'🎊<br><br>{fmt_pct}'
  return fmt_pct

# prints text in the center of the plot
def number_overlay(text):
  axis_setting = dict(range=[-1,1], showline=False, ticks='', showticklabels=False, showgrid=False, zeroline=False, fixedrange=True, autorange=False)
  annotation = dict(x=0, y=0, ax=0, ay=0, text=text)
  margin = dict(t=60,l=0,r=0)
  layout = go.Layout(xaxis=axis_setting,yaxis=axis_setting,annotations=[annotation],margin=margin)
  fig=go.Figure(data=[], layout=layout)
  periscope.plotly(fig, config={'displayModeBar':False})

# returns css-styled text
def style_text(text, **settings):
  style = ';'.join([f'{key.replace("_","-")}:{settings[key]}' for key in settings])
  return f'<span style="{style}">{text}</span>'

def style_link(text, link, **settings):
  style = ';'.join([f'{key.replace("_","-")}:{settings[key]}' for key in settings])
  return f'<a href="{link}" style="{style}">{text}</a>'

# translates hex code to RGB values
def rgb_from_hex(hex):
  h = hex.lstrip('#')
  return tuple(((int(h[i:i+2], 16))) for i in (0, 2 ,4))

# translates RGB values to hex code
def rgb_to_hex(rgb):
  return '#%02x%02x%02x' % rgb

# translates hex code to RGB values with alpha
def rgba_from_hex(hex, alpha):
  rgb = rgb_from_hex(hex)
  return f'rgba({rgb[0]},{rgb[1]},{rgb[2]},{alpha})'

def plot(df, annotation=None):
  color = '#1c6cab'

  # get current and goal values
  df.columns = [c.upper() for c in df.columns]
  current_col = [c for c in df.columns if c.startswith('CURRENT')][0]
  goal_col = [c for c in df.columns if c.startswith('GOAL')][0]
  data = df.iloc[[0]]
  current = data[current_col].iloc[0]
  goal = data[goal_col].iloc[0]

  formatter = get_formatter(current_col)
  current_formatted = format(current, formatter)
  goal_formatted = format(goal, formatter)

  pct = 1.0 * current / goal
  if pct > 1:
    color = '#00be11'

  donut = go.Pie(
    values = [current, goal - current if goal > current else 0],
    marker = {
      'colors': [color, rgba_from_hex(color, .2)]
    },
    hole = .8,
    textinfo='none',
    hoverinfo='none',
    sort=False
  )

  x = .5 * (1 + math.cos(math.radians(max((1 - pct), 0) * 360 + 90)))
  y = .5 * (1 + math.sin(math.radians(max((1 - pct), 0) * 360 + 90)))
  xsign = 1 if pct <= .5 else -1
  ysign = 1 if pct <= .5 else -1

  annotations = [
      {
        'x': 0.5,
        'y': 0.55,
        'ax': 0,
        'ay': 0,
        'text': style_text(pretty_percent(pct), font_size='32px', font_weight='bold') + '<br><br>' + style_text('Goal: ' + goal_formatted, font_size='18px')
      },
      {
        'x': x,
        'y': y,
        'ax': xsign * 10,
        'ay': ysign * 10,
        'arrowcolor': 'rgba(0,0,0,0)',
        'text': style_text(current_formatted, font_size='14px', font_weight='bold')
      }
    ]

  if annotation is not None:
    annotations.append(annotation)

  layout = go.Layout(
    font = {
      'color': '#000000'
    },
    showlegend = False,
    margin = {
      't': 30,
      'b': 30,
      'l': 30,
      'r': 30
    },
    annotations = annotations
  )

  fig = dict(data=[donut], layout=layout)

  periscope.plotly(fig)

try:
  plot(df)
except Exception as e:
  print(e)
  annotation = {
    'x': 0.5,
    'y': 0.5,
    'ax': 0,
    'ay': 0,
    'xref': 'paper',
    'yref': 'paper',
    'text': style_link('DUMMY<br><br><br><br>DATA<br><br><br><br>EXAMPLE', community_post, font_size='60px', font_weight='bold', color='rgba(0, 0, 0, .25)'),
    'showarrow': False,
    'textangle': -25
  }
  plot(dummy_df, annotation=annotation)
Rate this article:
Version history
Last update:
‎02-15-2024 02:16 PM
Updated by:
Contributors