Profile Picture

Date range (filter) not working

Posted By Bob Smith 11 Years Ago
Author
Message
Bob Smith
Posted 11 Years Ago
View Quick Profile
Forum Guru

Forum Guru (69 reputation)Forum Guru (69 reputation)Forum Guru (69 reputation)Forum Guru (69 reputation)Forum Guru (69 reputation)Forum Guru (69 reputation)Forum Guru (69 reputation)Forum Guru (69 reputation)Forum Guru (69 reputation)

Group: Forum Members
Last Active: 11 Years Ago
Posts: 69, Visits: 1

I have created a stacked area chart that uses a date range on the X axis. I've attached a copy of the NCSP file and a screenshot to this message. The "FilterProblem1" attachment is a screenshot of the problem.

Using filters on the chart only impacts the end date. The X Axis seems terminate at the current month despite the date range being outside of that.

The "Stacked_Chart_1_NCSP.gif" attachment is the NCSP configuration file for this chart; the "People_Proj_3_XLSX.gif" is the data sheet for making a SharePoint list.

To set up the chart, import the NCSP file, create two Date Filters titled "Start Date" and "End Date" on the web part page and pass the filter values into the chart web part. Create a list titled "People_Proj_3" using the data (should be able to import the excel spreadsheet as a list).

Would love to be able to properly filter the inputs to this chart!



Attachments
FilterProblem1.gif (365 views, 64.00 KB)
Stacked_Chart_1_NCSP.gif (399 views, 41.00 KB)
People_Proj_3_XLSX.gif (360 views, 15.00 KB)
Nevron Support
Posted 11 Years Ago
View Quick Profile
Supreme Being

Supreme Being (4,329 reputation)Supreme Being (4,329 reputation)Supreme Being (4,329 reputation)Supreme Being (4,329 reputation)Supreme Being (4,329 reputation)Supreme Being (4,329 reputation)Supreme Being (4,329 reputation)Supreme Being (4,329 reputation)Supreme Being (4,329 reputation)

Group: Forum Members
Last Active: Last Year
Posts: 3,039, Visits: 3,746

Hello Bob,
Please, make sure to submit support tickets when you have technical questions.

We were able to load and review your chart.
The problem is that you have specified X-axis range as strings. You need to use:
Begin: =DATETIME(Params!SPF_Start_Date.STR, "en-us")
End: =DATETIME(Params!SPF_End_Date.STR, "en-us")

You should also consider updating your Title expression since you can receive an error for the SPLIT function. Use something like:
=IF(Fields![RowCount]=0, "Empty", "Work Year Portion Sums <br/>" + GETAT(SPLIT(Fields!User_Name_Enum, "\"),1) + "<br/> <u>Click to return to Project WY Breakdown</u>")



Best Regards,
Nevron Support Team



Bob Smith
Posted 11 Years Ago
View Quick Profile
Forum Guru

Forum Guru (69 reputation)Forum Guru (69 reputation)Forum Guru (69 reputation)Forum Guru (69 reputation)Forum Guru (69 reputation)Forum Guru (69 reputation)Forum Guru (69 reputation)Forum Guru (69 reputation)Forum Guru (69 reputation)

Group: Forum Members
Last Active: 11 Years Ago
Posts: 69, Visits: 1
As a note - when I change the type to XY Scatter (3) and not XY Scatter Stacked (4) all my data points are displayed. I have attached a GIF image. Is there something missing from my data set?

Attachments
DataProblem3.gif (327 views, 74.00 KB)
Nevron Support
Posted 11 Years Ago
View Quick Profile
Supreme Being

Supreme Being (4,329 reputation)Supreme Being (4,329 reputation)Supreme Being (4,329 reputation)Supreme Being (4,329 reputation)Supreme Being (4,329 reputation)Supreme Being (4,329 reputation)Supreme Being (4,329 reputation)Supreme Being (4,329 reputation)Supreme Being (4,329 reputation)

Group: Forum Members
Last Active: Last Year
Posts: 3,039, Visits: 3,746

Can you please elaborate or send details to: support@nevron.com

 



Best Regards,
Nevron Support Team



Bob Smith
Posted 11 Years Ago
View Quick Profile
Forum Guru

Forum Guru (69 reputation)Forum Guru (69 reputation)Forum Guru (69 reputation)Forum Guru (69 reputation)Forum Guru (69 reputation)Forum Guru (69 reputation)Forum Guru (69 reputation)Forum Guru (69 reputation)Forum Guru (69 reputation)

Group: Forum Members
Last Active: 11 Years Ago
Posts: 69, Visits: 1

Hey! Thanks for getting back to me (and I do have one additional chart related question).

I can definitely submit a support ticket in the future - what email address would you like me to send it to? Or should I submit it via the web somehow? Also, what information do you need from me in order to provide official support? I can get any information you need from the network admin.

I like posting to forums as I know that it is a lower priority for you and I also think that the answer to my problem will probably solve some else's problem in the future. Never know - perhaps it will avoid a ticket for someone else! It's always nice to find the answer already waiting for you without having to contact support But I'm happy to play by the rules, no problem.

One additional question regarding this chart: I have date stamps in my data set that are beyond May 2013; for some reason the data is truncated there on the chart. Even if I remove the filter from the "Pivot" configuration tab on chart, the data points after May 2013 never show up. I've searched to see if there is something pertaining to "Now()" in the configuration - perhaps because this is the month of April 2013, no data past this month is being loaded. I'm not having any luck finding it. I will attach additional screenshots highlighting the problem.

Again, please let me know who to contact in the future and what information you need from me in order to submit a ticket! Thanks again!



Attachments
DataProblem1.gif (330 views, 57.00 KB)
DataProblem2.gif (326 views, 21.00 KB)
Bob Smith
Posted 11 Years Ago
View Quick Profile
Forum Guru

Forum Guru (69 reputation)Forum Guru (69 reputation)Forum Guru (69 reputation)Forum Guru (69 reputation)Forum Guru (69 reputation)Forum Guru (69 reputation)Forum Guru (69 reputation)Forum Guru (69 reputation)Forum Guru (69 reputation)

Group: Forum Members
Last Active: 11 Years Ago
Posts: 69, Visits: 1

I now know what the problem is... If any value in the stack does not exist then all data is drawn as "0" on the Y axis.

Can I access the values inside of a Series using C Sharp and add 0's in for "null" values? NSeries Series1 = chart.series[0] as NSeries?

How do I add a value into a series programatically? Series1.value[i]?



Attachments
DataProblem4.gif (355 views, 121.00 KB)
Bob Smith
Posted 11 Years Ago
View Quick Profile
Forum Guru

Forum Guru (69 reputation)Forum Guru (69 reputation)Forum Guru (69 reputation)Forum Guru (69 reputation)Forum Guru (69 reputation)Forum Guru (69 reputation)Forum Guru (69 reputation)Forum Guru (69 reputation)Forum Guru (69 reputation)

Group: Forum Members
Last Active: 11 Years Ago
Posts: 69, Visits: 1

Finally got it fixed! Was able to submit a support ticket and my problem was resolved - two statements were the key. These are located in Pivot>Data Groupings>Values>General (and they were settings for "Value 0" as that was the only Y value I was tracking):

Value: =IF(ISEMPTY(SUM(Fields!WY_Portion_Enum)), 0, SUM(Fields!WY_Portion_Enum))

X: =FIRST(Col.Fields!Start_Date_Enum)

By specifying "ISEMPTY" for Y, you're sure to get a "0" return in spots with no data. By specifying "=FIRST(Col.Fields!Start_Date_Enum)" the full set of X values from the column for the current series is returned, not just the X values that correlate to the data points in the series. This causes the chart to fill out across the X axis and display all the data points.

The following expression was used for displaying only labels that are not equal to zero: =IF(SUM(Fields!WY_Portion_Enum, 0) > 0, SUM(Fields!WY_Portion_Enum, 0) ,"")

Attached is a screenshot of the appropriate configuration.

Nevron support to the rescue! Thanks again



Attachments
FixedStackingProblem.gif (350 views, 157.00 KB)


Similar Topics


Reading This Topic