Table Total Row and Beast mode Aggregation

VictorLuiz · 2023-12-12T18:54:31+00:00

There was an error rendering this rich post.

VictorLuiz

Hi experts,

I'm tying to build a table of consumption by subtracting a total on different days.

I'm using the lead to get the next value and subtracting the current one:

When I able the total row option an error occurs:

My first question is why is it happening?

My second question is why doesn't the bar chart aggregate the calculated Consumption when I graph by month? (The values are listed per day)

Find more posts tagged with

Charting

Table

Beast Mode

Federated

Accepted answers

All comments

DashboardDude

Hi @VictorLuiz ,

Just making sure, your dates are dates and not datetimes right? So if you go to the dataset that powers these cards, is that column DateTime a date or does it show hours and minutes too? That might be the issue for the 2nd question. I think I need to see more about the 1st question to understand.

VictorLuiz

Hi John,

Yes, the DateTime column shows date, hours and minute. I used the Beast Mode to extract only the date an it worked, thank you for the tip.

Regarding my first question, I tried to adding the consumption column directly in database but when I select to show total row it still doesn't working.