Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
Could anyone let me know is it possible to show only Total bar instead of all bars for a month data. for more clarification I am attacing my Bar chart.please could anyone help me as my user wants to see only total data.
Thanks.
Amelia
Try removing the dimension 'Test'.
If that does not give what you are after then please clarify your requirements.
Best Regards, Bill Markham
you can use TOTAL in your expressions...
for example:
Sum(TOTAL Sales)
or
sum(Sales)/sum(total <Month> Sales)
Please could anyone help me as it is urgent please help
how to use SUM as I need to use expression like below.
count
({<Result={'Fail'}>} distinct Reference)/Count(Distinct(Reference))
please help
I have to consider % of Failures so I need to use
count
({<Result={'Fail'}>} distinct Reference)/Count(Distinct(Reference))
so when I am using SUM it is showing error. In this case please tell me how to use SUM
Hi,
In the Style tab of your chart, check Filled instead of Grouped
Thanks for this.
But my user wnats to see only the total bar
Could you please help how to select this
Please help
Amelia
From your attached *.docx it looks as if you have more than one dimension on the bar chart, you may well only need a single dimension.
Although to be honest I am a bit unsure as to what you are actually trying to achieve. Could you post a picture of what you want to display and what your current dimensions & expressions are [ or the qvw].
Best Regards, Bill Markham