Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Experts,
I am trying to show 4 different lines in a line chart but only 2 of them are showing at a time. How do I show all 4 lines all at once in a line chart? The line chart does output the data correctly based on the selections I make.
My chart currently looks like this:
I have 4 expressions w/ definitions that I am trying to show:
- Experience Trend Selected
Definition: sum(ExperienceTrend)
- Future Trend Selected
Definition: sum(FutureTrend)
- Experience Trend Realized
Definition: sum(ExperienceTrend)
- Future Trend Realized
Definition: sum(FutureTrend)
Is it because I have the same definitions?
Thank you in advance!
I just needed to have the fields equal to the selection in my definition.
For instance,
sum({<TrendType={'Frequency'},Selected_Realized={'Selected'}>}ExperienceTrend)
Presumably, since you have two sets of identical expressions, the two extra lines are there, just not visible because they are completely overlapped by another line.
If you change the first two lines to being dashed/dotted, you'll presumably be able to see the other line below.
I tried changing the first two lines to being dotted but it is still not showing up...
I am trying to output this data to the chart
When I don't make any selections to the Selected_Realized field, it just sums it up the ExperienceTrend and FutureTrend, which makes sense based on my definition of summing up those values.. But I am unsure what to put in my definition so that it will sum up the values based on other fields.
I just needed to have the fields equal to the selection in my definition.
For instance,
sum({<TrendType={'Frequency'},Selected_Realized={'Selected'}>}ExperienceTrend)