Skip to content

Troubleshooting

Datama mixes up dimensions and metrics. Datama reads the columns from left to right: every column up to the last text column is a dimension. Put the dimensions first, then the metrics, and check that metrics are numbers. See Data requirements.

The KPI looks wrong. Check that your metrics can be summed: a ratio or an average in the data gives wrong totals. Let the market equation compute the ratios.

My dataset is too big. An analysis handles up to 300,000 rows, and a Power BI visual up to 200,000. Aggregate the data first, for example by day instead of by event.

Web app

My source does not show the latest data. Source blocks are cached for one hour. Refresh the data from the header. See Connect a source.

Datama does not compare the periods I want. By default, Datama compares the last two values of the comparison dimension, or splits a date range in two. Set the comparison, or filter the data in your BI tool.

The comparison changes when new data arrives. Comparisons are relative by default. Turn relative comparisons off to keep the exact values. See Relative or fixed comparisons.

Datama warns that the covariance is high. The steps moved together so much that the two sides may not be comparable populations. Check the comparison, or isolate the covariance. See How it works.

A new or closed segment distorts the waterfall. Declare the dimensions of the out of scope segments.

“There is not enough data for current baseline definition”. The baseline needs more history than the data holds: with Same day of week, 5 points need 5 weeks. Lower Number of points in baseline, or choose All points. See Baseline.

“Variation volatility is only available for date dimensions”. Choose a date in Detect anomaly on, or another method.

Too many anomalies are flagged. Raise the Level of confidence, raise the Min impact threshold, or turn on Latest Point only. See Detect visual settings.

Looker Studio

My settings are lost when the report reloads. Looker Studio does not let Datama save its settings. Paste them in Config JSON. See Looker Studio.

Viewers see the Datama header and settings. Turn Edit mode off in the format options of the visual. See Edit mode.

Viewers cannot see the analysis, or see the Datama branding. Sharing with viewers and removing the branding need a paid licence. See Plans and billing.

Excel, Google Sheets

I cannot install the add-on. If your account is managed by your organisation, ask your administrator to install it.

Web app

The Help menu of the web app header gives access to:

  • Search: find a word in your workbooks and in the documentation;
  • Tutorials: interactive tours of the interface;
  • Documentation: this site;
  • Feedback: report a problem, with a screenshot if you can.

You can also write to contact@datama.fr, or use the contact form.