topic Re: Sum distinct By Default? in App Development

Sum distinct By Default?

Gestion-PSD — Mon, 28 Mar 2022 11:35:35 GMT

Hi all,

We're facing a very strange issue in one of our dashboards. Suddenly, it starts to apply "distinct" in all its values. Please see the attached image. You can see a table with two dimensions (Hora (hour), Value as dimension) and a measure sum(Datosn) . If you sum all data on the measure, it sums 488, but table shows 377, that is the result of sum(distinct datosn).

It's happening in all the dashboard visualizations.

The weirdest thing is that it doesn't happen in a twin paralell-built (not duplicated form this one) dashboard (same data load script, same visualizations).

Have you any idea about what's happening and how to solve it?

Best regards,

Alonso Torres.

Re: Sum distinct By Default?

Or — Mon, 28 Mar 2022 11:40:39 GMT

Are you sure that each line in your table corresponds to an actual row in your data? For example, consider this structure:

Key, Hour

A, 1

B, 2

B, 3

Key, Value

A, 10

B, 20

In that scenario, you would get:

Hour, Value

1, 10

2, 20

3, 20

But the sum would only be 30 because it would be applied to the values from the second table, where Value resides.

Re: Sum distinct By Default?

Gestion-PSD — Mon, 28 Mar 2022 11:48:37 GMT

Hi Or.

Absolutelly yes. There doesn't exists relations in data model in the way you show.

This is the aggregated values directly stored from resident dashboard data:

As I said before, We've a similar dashboard with similar data, data load script and visualizations, and it isn't affected by this weird behavior.

Re: Sum distinct By Default?

Or — Mon, 28 Mar 2022 12:00:41 GMT

In that case, the only thing I can think of is to confirm that this isn't referring to a master item called Datosn which may behave differently from the field Datosn (We've had some issues before when a field name and master item name are identical). Otherwise, I'm at a loss as to what might cause this sort of behavior for a flat file and simple sum.

Re: Sum distinct By Default?

Gestion-PSD — Mon, 28 Mar 2022 13:48:20 GMT

Hi again.

There's no master item called as this field.

I think the dashboard must have got some kind of corruption out of our knownledge. We're going to rebuild it.

Thanks for your quick replies.

Best regards,

Alonso Torres.

Re: Sum distinct By Default?

Or — Mon, 28 Mar 2022 14:15:06 GMT

Good luck. Sorry I couldn't actually help.