Forum Discussion
fixed values in the graph
- 7 years ago
To remove summation for any graphs,in the value feild,click the dropdown and choose the value option to anything else other than sum or summarize.
For First day and last day price of a year.Considering you have two filters one for year and other one for stock item.
You can create 2 measures:
1.First_day_price=calculate(sum(stockprice column),filter(tablename,stockdate=min(stockdatecolumn)))
2.Last_day_price=calculate(sum(stockprice column),filter(tablename,stockdate=max(stockdatecolumn)))
You can create 2 score cards for the above 2 measures
So when you select the respective year and stock items in your filter the score cards will show the stock proce for those filter
To remove summation for any graphs,in the value feild,click the dropdown and choose the value option to anything else other than sum or summarize.
For First day and last day price of a year.Considering you have two filters one for year and other one for stock item.
You can create 2 measures:
1.First_day_price=calculate(sum(stockprice column),filter(tablename,stockdate=min(stockdatecolumn)))
2.Last_day_price=calculate(sum(stockprice column),filter(tablename,stockdate=max(stockdatecolumn)))
You can create 2 score cards for the above 2 measures
So when you select the respective year and stock items in your filter the score cards will show the stock proce for those filter
- strikw7 years agoHelper I
Thank you
Problem solved.