Table Total Row and Beast mode Aggregation

Options
VictorLuiz
VictorLuiz Member
in Charting

Hi experts,

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

s1.jpg

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

csp.jpg

When I able the total row option an error occurs:

Error.jpg

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)

image.png

Tagged:

Answers

  • DashboardDude
    DashboardDude Coach
    Options

    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.

    Circle.png

    John Le

    You're only one dashboard away.

    Click here for more video solutions: https://www.dashboarddudes.com/pantry

  • VictorLuiz
    VictorLuiz Member
    Options

    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.

Categories