Hello dear users of Stimulsoft reporting tools! We are always glad to share you the latest news about our product and various novelties. This time we want to tell you about Text Format.

Text Format

Text Format is a functionality that allows to apply various templates to text. With the help of it you can display your text in different variants, such as money, percents, decimal numbers and phone numbers.

All settings of the text format you can find in Home tab in Text Format panel:

Text Format Tab
There is a set of standard templates, their settings depend on the localization of operating system, and a form call-button of Text Format in the Text Format panel:

Text Format Button
This button allows to set additional format properties:

Format

Currency Format

For example you want to type a dollar symbol "$", but you use a computer with Russian locale and you have to send a financial report to your colleagues in the USA, using symbol "$". Also you want to type percentages and decimal numbers in this report.

To do it you should choose Currency Format:

Currency Format Properties
This format is applied to text, if you need to use currency designation. With the help of this format you can type currency symbol, in your case it`s a dollar symbol "$". For example you just type "1500" text, highlight the text component and then choose Currency format:

Currency Format
Set the currency symbol you need:

Currency Format PropertiesAnd you get "$1,500".

Currency Format Result

Percentage Format

You can type percentages too. For example you have "87" symbols and you need to turn them into "87%". To do it you should highlight the text component and choose Percentage Format. Remember, that the percentage Format multiplies a value by 100:

Percentage Format
Next, you should set percentage symbol in format properties:

Percentage Format Properties
After that you get the result you need.

Number Format

Besides, with the help of Number Format you can change number`s format. For example you need to apply a format with division into groups and adding a fractional part for "1500" text. To do it you should highlight the text component and choose Number Format:

Number Format
Next, you should set necessary number of fractional signs in format properties:

Number Format Properties
All of the above formats – Currency, Percentage, Number have the following properties: the number of decimal places, group separator, group size, positive template, negative template and currency template.

Date Format

Also you can change date format. Suppose you have the same situation - you are in Russia, sitting at a computer, where date is put firstly, then month and year and you need to send a report to your colleagues in the USA, where month is put first and only then date and year. To do it you should type in your text the date you are used to, then highlight the text component, choose Date Format and the date format you need:

Date Format
A few more words about changing time format. For example you typed text "14:00", but you decided to change it to "2:00 PM" for your American colleagues. To do this you should highlight the text component, then choose Time Format and P.M. format:

Time Format
And you get the result you need:

Time Format Result

Custom Format

In addition to the above you can format a phone number. For example you need to display a phone number with a code, brackets, dash and so on. To do this you should highlight the text component and choose Custom Format. In this format you can find (###) ### - #### format mask:

Custom Format
Choose it and you will be able to format a phone number as you need. Next, you should make the template you need: +(##) ## - ## - ##, then the numbers from the text appear instead of hashes and you get "+1 (23) 45 - 67 - 89" from "123456789" text.

Dashboards

It`s worth noting that Text Format can also be applied to many elements in dashboards. For example, indicators and charts.

Indicator

So let`s consider its applying to indicators. To do this, choose an indicator:

Indicator Format
Next, go to the Home tab, then Text Format and choose Currency Format:

Indicator Format Properties
Set currency symbol and you get:

Indicator Currency Format Result

Chart

Things are a little bit different with charts. For example at your chart thousands are displayed in the standard way: "1,800"; "1,600", and you want to shorten them and give them a different look, for example like this: "1.8K"; "1.6K". How to do this? Firstly choose a chart:

Chart Value Format
Next, go to the Properties. You can find 2 properties there: Argument Format and Value Format. Choose Value Format and click on the edge button:

Chart Value Format Properties
Then at the appeared Text Format form choose Number Format and activate Use Abbreviation property:

Chart Use Abbreviation
And you get a chart with formatted values:

Chart Value Format Result
It was value axis (Y). And let`s look at applying Text Format to the argument axis. At an argument axis (X) chart you have axis values as prime numbers and you want to turn them into percentages:

Chart Argument format
To do this you should choose Argument Format and click on the edge button in properties:

Chart Argument Format Properties
Next, on the opening Text Format window you choose Percentage Format and set percentage symbol:

Chart Percentage Format
And you get the result you need:

Chart Argument Percentage Format Result

Table

In addition, there are tables in dashboards. And you can also apply Text Format to them. For example you have a table with three columns and at one of them you want to apply Percentage Format. Let`s have a look how to do it.

Firstly, choose a table:

Table Format
Let`s say you want to change Rank column and apply Percentage Format to it. To do this you should open a table editing form.

Next, you should highlight the column:

Table Format Properties
Click on the dialog box button, then go to the Home tab and in Text Format group choose Percentage Format and percentage symbol:

Percentage Format Properties
And you get the result you need:

Table Percentage Format Result
We hope this article will help you to understand Text Format features of use, when creating tables, charts, indicators and the like in Stimulsoft report designer. If you have any questions, please contact us – we are always glad to help you!
Welcome to all readers of Stimulsoft`s blog. In our articles we share the secrets of building reports and developing dashboards with the help of our reporting tools. Today we will talk about skill levels in the report designer again.
In the previous article we considered how a chosen skill level exerts influence over the display of Publish and Actions. These tools display only on Professional skill level, while when choosing Standard or Basic levels they don`t. Apart from these tools, skill level exerts influence over the display of report`s components in the designer. And in this article, we will talk about it in more detail.

All the components, which are intended for reports` development are divided into groups. When choosing Standard or Professional skill level the groups of components Bands, Cross, Components, Bar Code, Shapes, Chart, Gauge, Map display in the report designer in Insert or Toolbox.



However, when choosing Basic skill level, the groups of components Gauge and Map don`t display.



Also it`s worth considering that when choosing Basic skill level some components can be or not to be in the list of components of a definite group. Let`s consider it in more detail.

In Bands group they won`t display:
  • Column Header
  • Column Footer
  • Hierarchical Data
  • Child
  • Empty Data
  • Overlay


And in Components group they won`t display:
  • Clone
  • Sub-Report
  • Table

This way skill level exerts influence over both the display of components` groups and the display of components in these groups.

Besides, the display of properties of a definite report`s component or a dashboard depends on a chosen skill level. In our documentation we made comparison`s tables of skill levels and components` properties display. To get acquainted with this tables you can at the link.

This is where we complete the series of articles about skill levels and their influence on the display of various tools, groups, components and properties in the report designer. If you have any questions, please contact with us.

We wish you success in drawing up reporting and all the best!
The previous articles related:
In the previous article we considered skill levels in the report designer, familiarized with the process of their changing, learned the description of each level and recommendations for their selection. We hope this information was useful for efficient and fast reports` development and analytics dashboards.
This time we will talk about tools Publish and Actions in data dictionary. Their display depends on chosen skill level. When choosing skill level Basic or Standard these tools don`t display. It`s connected with that the tools for creating reports and dashboards are intended mainly for app developers.

Skill Level Dialog

For example Publish gives an opportunity to simplify and accelerate the process of report`s embedding or indicator panels in a custom app for various platforms. And Actions contains different commands for working with report data`s dictionary, for its synchronization and used sources` embedding in report`s resources.

Report Designer

When developing reports and dashboards, these tools are rarely used. So they are available only when choosing Professional skill level.

As it was said before it`s all explained with the fact that Professional is the most advanced level. In general it`s intended for both experienced report developers and software developers. At this skill level all components, their properties and tools are available in the report designer. This way if Publish doesn`t display in the report designer and Actions doesn`t display in data dictionary you should set up such skill level as Professional.
In our next article we will consider components in the report designer and their properties, which display depends on chosen skill level.
Today due to the development of information technologies, many spheres of human activity got an opportunity quickly and qualitatively keep, process and analyze the data of their work and its effectiveness.

Medicine isn`t also exception. So as it`s very important sphere of human activity. It has quite a lot of information and data, which require qualitatively analysis. Stimulsoft was always interested in creating modern tools of data analysis including medicine. We developed dashboards, which reflect key performance indicators in medicine.

These examples of dashboards give an opportunity to analyze data in the following categories of medical coefficients of performance indicators (KPI): Emergency, Finance, Internal, Operations, Patient Health, Public Health. Except KPI dashboards, we also have dashboards, such as: Hospital Overview, Hospital Performance, Medical, Patient Satisfaction.

Emergency KPI

Dashboard Emergency KPI gives an opportunity to analyze data in emergency departments of medical care.
Emergency KPI

In this example the following KPIs are presented:
  • The Time by Process Step, in min metric shows the time from patient`s visit to his hospitalization.
  • The Hours between symptom onset & hospitalization metric displays the time from the moment a person develops a symptom until his hospitalization.
  • The Number of patient metric displays the number of patients for the last period.
  • The Visitors who leave without being seen metric indicates the number of visitors who were unwilling to wait to see a doctor. It can help determine if more beds or staff are needed to handle the number of patients coming in.
  • The Chart element displays the ratio of the number of admitted to discharged patients.

Finance KPI

In the dashboard Finance KPI economic indicators of a medical institution are presented.
Finance KPI

This example includes the following analytical elements:
  • Average Insurance Claim Processing Time & Cost metric averages the amount of time and money spends processing insurance claims. When low, it indicates that the facility receives payment faster and there is less cost to the patient.
  • Average Doctor & Employee Wages Ratio metric displays average ratio of doctor`s and employee`s wages.
  • Claims Denial Rate metric provides insight into the effectiveness of the organization`s revenue cycle.
  • Average Treatment charge Per hour metric gives an opportunity to display the average amount that a facility charges a patient for a treatment.
  • Average Doctor Wages metric displays the value of wages paid to a doctor for an hour.
  • Average Employee Wages metric shows the value of wages paid to an employee for an hour.

Internal KPI

Internal KPI dashboard is an analytics of the internal interaction of a hospital.
Internal KPI

This dashboard includes the following metrics:
  • Trainings per Department metric displays the number of trainings conducted for medical staff and also their statistics by months.
  • Partnerships with Advocacy Groups metric displays the total number of partnership agreements of a hospital with legal organizations as well as their statistics by month.
  • Patient Confidentiality metric element displays the number of times a patient`s confidential medical records were compromised or seen by an unapproved party.

Operations KPI

In the Operations KPI dashboard the data analytics of patient care in a hospital is presented.
Operations KPI

All these data are presented with the following metrics:
  • Staff to Patient Ratio metric measures the number of active staff, looking after patients in a hospital in a definite period of time.
  • Bed or Room Turnover metric, in days displays the number of turnovers of beds or rooms a day.
  • Rate of Patient Satisfaction metric shows the level of satisfaction with medical staff`s work.
  • Average Patient Wait Time, in min fixes the average calculates the average number of time a patient must wait between checking in and seeing a provider. This can help with staffing and scheduling and provide insight into patient satisfaction.
  • The chart element Number of Patient Beds displays the number of beds for patients by months.

Public Health KPI

In the Public Health KPI dashboard the data analytics of public health is presented: childhood immunizations, the number of educational programs and the number of preterm births.
Public Health KPI

  • Childhood Immunizations metric displays the number of childhood immunizations by months.
  • The Number of Educational Programs metric displays the number of educational programs in medicine conducted with the total of all programs by months.
  • The Number of Preterm Births metric displays the number of preterm births with the common sum of all preterm births by months.

Medical Dashboard

Also, in our examples you can find Medical dashboard, which includes all of the above dashboards.
Medical

Choose appropriate dashboard and analyze your data.

We considered the examples of dashboards directly in key areas of medical institutions. However, among the examples of Stimulsoft some dashboards for analyzing patients` health and their satisfaction are presented.

Health Patient KPI

Dashboard Health Patient KPI displays the total data of a patient and his health.
Health Patient KPI

  • Blood Type indicator displays patient`s blood type.
  • Age indicator displays patient`s age.
  • Height indicator reflects patient`s height.
  • Weight indicator reflects patient`s weight.
  • Cholesterol metric records the patient`s cholesterol level.
  • Heart Rate metric displays patient`s heart rate.
  • Body Temperature metric shows patient`s body temperature.
  • Triglycerides metric displays patient`s triglycerides level.
  • HDL metric displays the level of high density lipoproteins.
  • LDL metric reflects the level low density lipoproteins.
  • Systolic metric displays the upper blood pressure.
  • Diastolic metric displays the lower blood pressure.
  • Pulse metric records the number of heartbeats per minute.
  • Blood Glucose metric displays the blood glucose level.

Patient Satisfaction

With the help of dashboard Patient Satisfaction you can display how satisfied patients are with the treatment and medical staff`s work.
Patient Satisfaction

In this dashboard the following metrics are presented:
  • Patient Satisfaction records the common prcent of patient`s satisfaction.
  • Arrival to Bed metric displays the time a person waits until to be put into bed.
  • To See a Doctor metric reflects the waiting time for an appointment.
  • To Get a Treatment metric displays the duration of treatment`s process.
  • The Staff explained instructions in an understandable way metric displays the patient`s agreement with staff`s understandable explanation of instruction.
  • The Staff took time to answer my question metric reflects the patients` agreement with staff`s taking time to answer patients` questions.
  • Patient Falls metric displays the precent of patients` falls.
  • Lab Test Turnaround shows the results of laboratory tests and the time taken to complete them.

Hospital Overview

Except this, among the examples of Stimulsoft there are dashboards for a hospital. In the dashboard Hospital Overview total analytical information about a hospital is presented.
Hospital Overview

All these data are presented with using such elements as indicators, measuring instruments and charts:
  • Total Patients metric displays the common number of patients who applied.
  • Total Patients Admitted metric gives an opportunity to display the common number of hospitalized patients from the number of those who applied.
  • Average Treatment Costs metric displays the average treatment cost.
  • Average ER Waiting Time displays the waiting time for a doctor`s appointment on average equivalent.
  • The Chart element displays the number of inpatients and outpatients by months.
  • With the help of Total Inpatients metric you can analyze the number of patients who are in a hospital.
  • And with the help of Total Outpatients metric you can display the number of patients who are on outpatient treatment.
  • Average Waiting Time by Division metric displays the patient`s waiting time (in minutes) for a doctor`s appointment, for each department of medical institution.

Hospital Performance

The Hospital Performance dashboard displays the analytics of hospital`s activity.
Hospital Performance

All of this is presented with the using of different charts:
  • Length of Stay chart shows the duration of stays in a hospital by months.
  • Admissions & Readmission Rate element records the number of admissions and readmission rate.
  • Average Treatment Costs element records the number of money spent on treatment over the years.
  • Hospital Acquired Infections element records the precent of surgical and central-line catheter infections of a hospital.
  • Stays by Payer element records the number of stays by payer. That is to say the percent of people getting treatment with private insurance, uninsured, medicate, medicare is displayed.
  • The Costs by Payer & Type of Stays element displays costs by payer and type of stays. That is to say surgical stays costs, medical, maternal and neonatal stays. And also costs on private insurance, uninsured, medicare, medicaid patients.

This way you can use the examples of Stimulsoft Dashboards to analyze the activity of your medical institution. We wish our clients good health and polite patients.
white
Dear friends, clients, the pandemic of coronavirus swept the whole world. Perhaps, there is no such country, which didn`t face this trouble. However, our life and work go on, and we don`t stand aside, our products are actively used for monitoring the situation with COVID-19.

In March when the world went into quarantine, our clients started creating dashboards which demonstrate the tendencies of pandemic of COVID-19 in the world, the number of infected, dead and recovered people. The examples of our users` dashboards represent analytical data, which include following elements: indicators, tables, maps, charts.

Indicators

Indicators represent aggregated data on identified cases of infection, death and recovery from coronavirus. For example, in more successful from our point of view, dashboard, following metrics with the using of indicators are presented:

Global Cases

Global cases

Global Deaths

Global deaths

Global Recovered

Global recovered

Tables

In the tables the statistics of deaths and recoveries by countries are presented. Changing the sorting of data, thus we can monitor the countries with the greatest number of deaths` cases or recovery.

Tables

Charts

Charts give an opportunity to visualize data for each date during the pandemic. Data`s array from the beginning of the pandemic gives an opportunity to guess the tendencies of development of situation with COVID-19.

Chart

Online Map

With the help of the Online Map you can display the number of infections for each geographic object on the dashboard. The bubbles of the map give an opportunity visually compare the number of identified cases in a definite country. This way with the help of the map you can watch the most infected territories and the places with most spreading of COVID-19 in the world.

Online Map
As a result, you can use products of Stimulsoft for analysis and visualization of data in the situation with coronavirus in all over the world. And, we in turn, wish our clients never face this pandemic and good health, of course.