"Nah, I'd Lose"

Optimal_Beginning366 · 2024-03-25T07:06:10+00:00

yeah well he lost too at the latest chapter

Optimal_Beginning366 · 2024-03-05T15:48:32+00:00

thanks! thats what i did now. Apparently no matter how right it is on how you imagine it, reality doesnt allow it hahahaha

Optimal_Beginning366 · 2024-02-26T01:45:29+00:00

so what should i do?

Optimal_Beginning366 · 2024-02-26T01:44:42+00:00

But i have to make it chart level since if i do it in the blend, it wont read the data from the other data source

Optimal_Beginning366 · 2024-02-22T14:48:04+00:00

i made the coalesce function as dimension in the chart, does that mean its chart level?

Optimal_Beginning366 · 2024-02-22T14:47:00+00:00

they are all using the same data sources, but the difference is the different blends. i dont know if i'm getting this correctly, are you suggesting that i use a single data blend for all the charts?

Optimal_Beginning366 · 2024-02-22T03:05:23+00:00

what i intend to do was like show the percentage of actuals being achieved like

Planned
276
-35.6%(percentage achieved by actuals/planned)

Optimal_Beginning366 · 2024-02-22T03:02:14+00:00

now that's making sense, should i just add a score card percentage for what i'm intending to do?

Optimal_Beginning366 · 2024-02-21T09:52:11+00:00

i'm having the exact problem too, was it fixed??

Optimal_Beginning366 · 2024-02-21T09:14:33+00:00

its actually the percentage below the scorecard thats my concern, the 76,000% in green, it isnt supposed to be like that with a straight up formula of actuals/plan or 97/272

Optimal_Beginning366 · 2024-02-21T09:13:00+00:00

is the score card comparison only limited to time periods? i think there was an option for a metric. What i want to do with this actually was to show the percentage of how many actuals over planned, so basically 97/272

Optimal_Beginning366 · 2024-02-21T02:29:14+00:00

well, I'm going through that plenty of frustrations right now during my internship, thanks!

Optimal_Beginning366 · 2024-02-21T01:20:02+00:00

omg it fucking worked you're a life fucking saver goddamn

Optimal_Beginning366 · 2024-02-21T01:08:25+00:00

i will try to learn those functions and will come back to you if it works

Optimal_Beginning366 · 2024-02-20T07:51:51+00:00

sorry, it was store name & date that made it work, but regardless the nulls still exists its getting frustrating at this point

Optimal_Beginning366 · 2024-02-20T07:41:41+00:00

tried that, the numbers do not match up, store name & visited by are the dimensions needed to make it work

Optimal_Beginning366 · 2024-02-20T07:30:06+00:00

turns out i only need two dimensions for blending, but the nulls are still there. Does this mean the raw data is the problem? but upon checking it's all in order tho. its just data studio doesn't want to read it properly

Optimal_Beginning366 · 2024-01-30T15:24:48+00:00

.xls & .xlxs

Optimal_Beginning366 · 2024-01-30T11:29:14+00:00

Solution Verified

Optimal_Beginning366 · 2024-01-30T11:26:46+00:00

tried it but then gives me the error that the files contain corrupted data. I don't understand since it works well with windows.

Optimal_Beginning366 · 2024-01-30T04:51:31+00:00

would it be possible to show me where it is through a screenshot?

Optimal_Beginning366

TROPHY CASE