Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
See attachment of issue.
My issue is for bPeriod 8 and 12, the information for newGP, newRevenue and newLoads does not show on the DashBoard when anGP, anLoads, and anRevenue are null. Not sure what you need to resolve this issue. If you need more information, please let me know. tks
Can you share the dashboard you are using for these data?
which is your expression ?
can you attach you qvw please.
Essentially it will depend on what your expression is. If you want to show all the fields and the full table, then your expression must have a value on every row. It's not clear exactly what you want to do with the data, but assume you don't want to summarize it, you could try this (expression is the period) if you want to use a straight table, or just put it all in a table box.
This is the expression.
=sum({<bPeriod={"<=$(vCurrPeriod)"},bYear={$(vMaxSelectedYear)}
,bMon={$(vSelectedMonth)},bFQtrS={$(vSelectedQtr)},[Parent Alias Name]=>} newLoads)
What is happening is newGP, newLoads, and newRevenue are not showing up on the DashBoard for bPeriod 8 and 12.
My expressions for these three columns are:
You try sum({1<..........
1 means all the data, or $ means only selections
This works if I want all (example) sales persons. However, if I only want John Doe to appear when he is selected, I still get everyone.
If in Nov. and Mar. he has zero actuals, but he does have a budget for these months, the budget amounts should appear even though
the actuals are zero. (as per my attachment).tks
If John Doe is [Parent Alias Name] try :
....,[Parent Alias Name]=$::[Parent Alias Name]>} ...