Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a straitgh table with several dimensions.
one of dimension has different criterias therefore my straigth table duplicates the rows. as you can see in atthached file. my question is how can I pick just the latest date criteria with using expression or dimension set.
I haven't fully understood yet. Is this dimension you are talking about GBTS with values Odemesi and Devam?
And per two lines of your chart table, you want to filter one, either Odemesi or Devam? Based on what criterium do you want decide that since all other values seem to be identical (for the two lines each)?
GBTS İs a table of customer interactions therefore there is diffrent informations in different dates. Devam is last updated position Odemesi is previous position. İ just want to see Devam in my chart
Either use a calculated dimension instead of field dimension GBTS like
aggr( if(GBTS='Devam',GBTS), GBTS)
or use a set expression in all your expressions, e.g.
sum({<GBTS = {Devam}>} Value)
{<GBTS = {Devam}>} is the set expression you need to add to your aggregation functions. Please check also the Help about set analysis.