Vizlib sparklines

[hamza99a]

I would like to show the sparklines based on two date fields. I have an open date field and production date field. I also have a field called deposits_balance_amt. Essentially I would like to show a running sum of the data from  my min production date to today IF  my open date has been within the this year. For some reason when I use set analysis or if statements my sparklines show a 0 value. Any help would be greatly appreciated.

[groveliam]

[hamza99a]

[balabhaskarqlik]

What are the Expressions you're using?

Post some sample data, to get an idea on issue.

[juraj_misina]

First try the expression and dimension you use for sparklines in a standalone table to see if it is working.

[hamza99a]

so the expression works and i get sparklines that show the sum for the day. However, I need to see a cumulative summation in the sparklines.

Thanks

[balabhaskarqlik]

May be add Cumulative sum like this:

RangeSum(Above(TOTAL Sum(Amount), 0, ColumnNo(TOTAL)))

[hamza99a]

For those that asked this is my set analysis formula for the sparklines:

sum({1<open_dt = {">$(=min([Production Date]))"}>}Deposits_curr_bal_amt)

[groveliam]

Excuse me ma'am can you please give more information