How can we help?

New post
0

Stop cumulative function happening with SELECT

Avatar
Steve Walker
None
Follow

Hi there,

I'm sorry if this is basic question, but I cant figure it out...

I have a really simple line graph where I use the Timestamp data on the X axis https://www.evernote.com/l/AAJMNjCU9zRM67MA27w5WHDAFfhVGMU-yto and then use the "Funding Used" column to show the sum of funds used inside a month https://www.evernote.com/l/AALu5aSU6UhBH6lUiGaFlNhhf_jI69PRdvg 

This all works perfectly - except in the data I want to filter out some of it as it belongs to a different project - so I use a SELECT which correctly filters the data I do not want out (when I check with the lightening bolt it is working fine) but now the data in the graph seems to be cumulating. It should be pretty much identical to the display in the previous working example...

https://www.evernote.com/l/AAJSZAPzIH9ACaQfbDR86k5qSg0PWEUBzJg

I have tried looking at ways to sum and groupby via month but i cannot work it out.

Any help would be greatly appreciated.

Kind regards, Steve

 

Date Votes

2 comments

  • 0
    Avatar
    Yvonne Van Alphen

    Hi Steve

    Thanks for the detailed explanation.

    Can you try using the IF function instead of the SELECT function for your series.

    https://support.klipfolio.com/hc/en-us/articles/216182997-How-do-I-align-data-using-the-IF-function-

    The SELECT function will bring back everything that is true, while the IF function will bring back what is true and false.

    For the false case you can specify 0.

    Does this work for you?  

    Yvonne

  • 0
    Avatar
    Steve Walker

    Hi Yvonne,

    That worked perfectly - thank you :)

    Kind regards, Steve.

Please sign in to leave a comment.